- 1401. In the Wheelhouse: F3=Exit Stage Left
- (Commentary)
- ... is hosted through the Domino server on IBM i). That also covers WebSphere, PHP apps through Zend, RPG Open Access, and a slew of other options running on IBM i that offer a graphical user interface. A ...
- Created on 16 September 2013
- 1402. You Asked for It and You Got It: Dynamic Library List Implementation in DB2 Web Query
- (DB2)
- ... integer value. An example RPG prototype for the exit program has been provided below: d rteExitPgm PR ExtPgm(MYEXITPGM) D currentUser ...
- Created on 11 September 2013
- 1403. Profound Logic Brings IBM i Application Modernization Message to 2013 COMMON Fall Conference & Expo
- (Certification / Training)
- ... will give attendees the opportunity to learn about the benefits of modernizing their RPG code and application interfaces using Profound Logic's products and services. "The Profound UI suite is the most comprehensive ...
- Created on 09 September 2013
- 1404. Fresche Legacy Acquires Databorough
- (Mergers / Acquisitions)
- ... X-Migrate & X2E industry-leading solutions enabling sophisticated environment analysis and code transformation from Synon, RPG and COBOL to Java or C#. "This agreement unites two of the most powerful ...
- Created on 09 September 2013
- 1405. Genuine Dynamic Program-Exported External Data in IBM i
- (RPG)
- ... System built-ins that can be used in ILE high-level languages to resolve a program-exported data item include _RSLVDP2 and _RSLVDP3, the ILE RPG prototypes of which are the following (see mih-ptr.rpgleinc): ...
- Created on 04 September 2013
- 1406. TechTip: BLOBs Keep PDF, XLS, and Other Reports Safe in DB2, Part 1
- (RPG)
- Ever had a user asking for a report you couldn't generate again because it was a "snapshot" of your database at a certain time? Here's how to fix that! Written by Rafael Victória-Pereira This TechTip ...
- Created on 30 August 2013
- 1407. The Essential Guide to IBM i Database Modernization
- (DB2)
- ... the growth and acceptance of this remarkable platform. In fact, the biggest constraint of application agility is neither the user interface nor the RPG-written applications; it's the fact that we're not ...
- Created on 30 August 2013
- 1408. Kisco Announces Native IBM i File Tool iFileUtility
- (Database)
- ... Consultant’s carry-around version available Easy to use, intuitive Generates RPG programs that can be converted to application use iFileUtility is available from Kisco Information Systems. ...
- Created on 29 August 2013
- 1409. LANSA Releases LongRange RV14 with Extended Mobile Features
- (Other Industry Solutions)
- ... i community, enables developers to use their existing RPG, COBOL and DDS skills to quickly create native mobile applications for iPhone, iPad and Android devices that fully integrate with their IBM i application ...
- Created on 27 August 2013
- 1410. TechTip: Compress Large Object (LOB) Data in DB2 for i
- (DB2)
- ... These CREATE FUNCTION SQL statements are in the source header. (For an introduction to writing external user-defined functions using RPG, see Reuse Your RPG Code with SQL User-Defined Functions. The concepts ...
- Created on 23 August 2013
- 1411. The API Corner: Accessing Job Queue Entries
- (APIs)
- Use the Open List of Jobs API. Written by Bruce Vining In last month's column, "Monitoring a Job Queue from an RPG Application Program," we looked at how an application program could be notified, via ...
- Created on 21 August 2013
- 1412. TechTip: Avoid Pitfalls When Diving into PHP Arrays
- (Web Languages)
- ... of the things that are very different from RPG. Let's get started! More About Defining Arrays and the Pitfalls They Can Cause Unlike with RPG, you don't have to specify the number of elements in ...
- Created on 16 August 2013
- 1413. Build a Searchable Web-Service Using OmniFind Text Search Server for DB2 for i
- (DB2)
- ... and explains how to implement text searches using embedded SQL within an RPG procedure. Discover the advantages offered by full-text search capabilities in modern applications. In modern IT ...
- Created on 14 August 2013
- 1414. TechTip: Fixed-Format to Free-Format: Missing Op-Codes
- (RPG)
- One challenge when switching from fixed- to free-format RPG IV is the disappearance of many frequently used op-codes. This tip reveals what to do for six of the lost operations. Written by Jim Martin ...
- Created on 09 August 2013
- 1415. 1001 Activation Groups Within a Single Job
- (RPG)
- ... to the interactive user in hexadecimal format. The source code of the STRUAG program, struag.rpgle and struag_dq.clle, is the following: struag_dq.clle /** ...
- Created on 07 August 2013
- 1416. newlook version 10
- (Other Industry Solutions)
- ... popular browsers, tablets and smartphones, including Apple iPhone, iPad and Android devices. Achieve the Impossible with RPG Open Access All new features work equally easily with RPG OA as ...
- Created on 01 August 2013
- 1417. Achieving IBM i Mobile Computing Clarity
- (Development Tools / Utilities)
- ... can make mobile developers out of your RPG programmers. Don't undervalue this. Properly enabled, your RPG programming team can create mobile apps in the time it would take you to explain the specs to an ...
- Created on 24 July 2013
- 1418. PHP: Variables, Arrays, and Functions (Don't Say It
- (Web Languages)
- You've used arrays in RPG, but they're so much more important in PHP. Written by David Shirey Last May, we talked about variables and how they're used in PHP. If you were paying any attention, which I ...
- Created on 17 July 2013
- 1419. Practical SQL: OLAP, Part 2
- (SQL)
- In this next installment on SQL's Online Analytical Processing (OLAP) functions, you'll see how OLAP continues to provide SQL users the business functions we've enjoyed in RPG for so long. Written by Joe ...
- Created on 03 July 2013
- 1420. Change the Last-Used Date of an IBM i System Object Arbitrarily
- (RPG)
- ... state, since MODSOBJ is a blocked MI instruction. This article discusses the above-shown technique in detail. A complete example RPG program following Gene's technique is provided at the end of article. ...
- Created on 03 July 2013
- 1421. TechTip: jQuery Fundamentals, Part IV
- (Web Languages)
- ... way around. You'll see XML, RPG, PHP, and of course a lot of jQuery in action. Although it can seem a bit overwhelming, I tried to create an application that you can run by installing it locally on ...
- Created on 28 June 2013
- 1422. The Once and Future PHP
- (Web Languages)
- ... web and mobile applications that access the RPG/COBOL code, as well as business logic and the DB2/400 database that resides on the IBM i. This means that IBM i clients can avoid the significant risk and ...
- Created on 24 June 2013
- 1423. Storing Metadata the Profound UI Way
- (RPG)
- Discover the benefits of using RPG OA and JSON to store metadata in the display file. Written by Scott Klement Editor's note: This article introduces the white paper "Storing Metadata the Profound UI ...
- Created on 24 June 2013
- 1424. The API Corner: Monitoring a Job Queue
- (APIs)
- ... Needless to say, there is such a capability and that's what we'll be looking at today. One item I want to point out, though. I'm quite aware that the "API Corner" is published in MC RPG Developer, so you might ...
- Created on 19 June 2013
- 1425. IBM Rational Developer for the Enterprise V9.0 Delivers New and Enhanced Capabilities
- (Other Industry Solutions)
- ... COBOL, PL/I, and RPG applications. They comprise a comprehensive set of tools for developing multi-tier, multi-channel applications that support a wide variety of client devices and influence a wide variety ...
- Created on 13 June 2013
- 1426. Profound Logic Software Takes IBM i Mobile Development to the Next Level with Profound UI 4.6
- (Development Tools / Utilities)
- ... application approval process. Native Design Enhancements Profound UI version 4.6 offers RPG and PHP developers a greater range of native features and design elements for their mobile applications: ...
- Created on 11 June 2013
- 1427. TechTip: Compacting a Large Number into a Small Space
- (RPG)
- ... is converting the transaction ID to a binary integer format (such as an SQL BIGINT or RPG 20I 0) and slamming the result (truncating the first two bytes) into the CHAR(6) column. The only drawback to this ...
- Created on 07 June 2013
- 1428. Technology Focus: Tools for Extending Server Apps to Mobile Devices
- (General)
- ... a Web-based management console. ASNA DataGate DataGate provides native access to IBM i and SQL data for mobile, Web, and Windows applications by enabling apps written in ASNA's Visual RPG to ...
- Created on 20 May 2013
- 1429. The API Corner: Just What Release Am I On?
- (APIs)
- ... PrdIFmt 8a const options(*nopass) /copy qsysinc/qrpglesrc,qszrtvpr ...
- Created on 15 May 2013
- 1430. TechTip: Getting Started with Microsoft Visual Studio Express 2012
- (Microsoft)
- Learn Microsoft from the perspective of an RPG developer. Develop C# Web Applications using Visual Studio 2012. Written by Tom Snyder Being a code junkie, I'm thoroughly enjoying all of the career changes ...
- Created on 26 April 2013
- 1431. IBM Rational Integrated Development Environments Raise Developer Productivity
- (Other Industry Solutions)
- ... Support a variety of tools and techniques for maintaining and extending key business assets held in the form of COBOL, PL/I, and RPG applications Represent a complete solution for creating multi-tier, ...
- Created on 24 April 2013
- 1432. TechTip: Check Out the New DB2 for i HTTP Functions
- (DB2)
- Use these new functions to easily extend your applications to the web. Written by Michael Sansoterra If you've been waiting for a DB2 for i feature that is unprecedented in power and simplicity, get ...
- Created on 19 April 2013
- 1433. Profound Logic Software Releases Profound UI Version 4.5
- (Development Tools / Utilities)
- ... and development platform in 2010 alongside the announcement of Rational Open Access for RPG by IBM, Profound Logic has been very active in producing regular updates to Profound UI. This release underscores ...
- Created on 15 April 2013
- 1434. In the Wheelhouse: IBMi25 Campaign Announced at COMMON!
- (Analysis of News Events)
- ... taught the in-house staple (RPG/COBOL), but it seemed only as a reference point. The screens they're creating are graphical; they just use the underlying business logic. And they're passionate about the ...
- Created on 15 April 2013
- 1435. looksoftware Introduces the Most Advanced Design and Development Environment the IBM i Has Ever Seen
- (Other Industry Solutions)
- ... Built-in templates are provided for popular browsers, tablets and smartphones, including Apple iPhone, iPad and Android devices. Achieve the Impossible with RPG Open Access All new features work ...
- Created on 09 April 2013
- 1436. Presto 4.7 Introduces More Visual Editor Palette Styles and Spool-File-to-PDF Feature
- (Other Industry Solutions)
- ... BCD's Director of Sales and Marketing, "We are constantly investing in Presto to make it faster for RPG programmers to modernize their IBM i and our shorter release cycle gets these new features in our clients' ...
- Created on 09 April 2013
- 1437. WebSmart 9.5 Introduces Object-Oriented PHP Grid Template and New Template Themes
- (Other Industry Solutions)
- BCD Int'l., Inc., has announced WebSmart ILE - PHP - Mobile version 9.5, the latest in a series of releases aimed at reducing the web development learning curve while providing tools for RPG and other programmers ...
- Created on 09 April 2013
- 1438. BCD Introduces New WebSmart Mobile
- (Mobile Solutions)
- BCD Int'l., Inc., has announced the release of WebSmart Mobile, which will make it faster and easier for RPG and other programmers to develop new mobile web apps. BCD Int'l., Inc., has announced the ...
- Created on 09 April 2013
- 1439. Zend Announces Zend Server 6 for IBM i
- (Other Industry Solutions)
- ... IBM i Zend Server runs natively on the IBM i. It provides a fully supported platform for creating modern web and mobile applications that access the RPG/COBOL code, as well as business logic and the ...
- Created on 09 April 2013
- 1440. Profound Logic Releases Profound UI Version 4.5; Profound UI Framework Available as Open Source
- (Other Industry Solutions)
- ... open, native and secure modernization solutions to the IBM i community," states CEO Alex Roytman. "By making our Web 2.0 UI framework open source, we are enabling RPG developers to have more control over ...
- Created on 05 April 2013
- 1441. TechTip: Convert iSeries Spool Files to Enhanced PDF Documents using iPDF and iText
- (Document Management)
- ... for installing and using the iPDF APIs, and two demonstration programs are provided that show how the iPDF commands and APIs let you create PDF documents quickly and easily from RPG programs. iPDF ...
- Created on 05 April 2013
- 1442. LANSA to Unveil New Mobile Offerings at COMMON 2013
- (Networking)
- ... native mobile application builder for the IBM i. Using existing skills, LongRange developers code in RPG/COBOL and DDS to build sleek, high-performance native mobile apps that are deployed via the App ...
- Created on 04 April 2013
- 1443. Practical SQL: OLAP, Part 1
- (SQL)
- ... item. However, the next part is tougher: how do we use SQL to find all the cases where this has occurred? It would be relatively easy with an RPG program: read through the file by item and transaction ...
- Created on 03 April 2013
- 1444. Be Kind to Your DBCS Data
- (RPG)
- ... code of RPG would probably truncate the DBCS data in the source string and therefore lead to an invalid result character string. Learn how to ensure the validity of extended character string assignment ...
- Created on 03 April 2013
- 1445. TechTip: User Space Tricks That You Might Have Never Thought Of
- (General)
- ... look like this: find /qsys.lib/mysrclib.lib -type f -ctime -7 > /qsys.lib/mygpl.lib/oneweek.usrspc. Read the search result stored in MYGPL/ONEWEEK in an RPG program, parse the character lines, and write ...
- Created on 22 March 2013
- 1446. Weird, Simple Stuff in PHP: Operators
- (Web Languages)
- Yeah, they're sort of the same as in RPG…but not really. Written by David Shirey Over the last few articles, I have been on a PHP kick, talking about the language in general and how it integrates into ...
- Created on 20 March 2013
- 1447. The API Corner: Determining Key Values
- (APIs)
- ... /copy qsysinc/qrpglesrc,qdbrtvfd /copy qsysinc/qrpglesrc,qusec ...
- Created on 20 March 2013
- 1448. TechTip: Using Color in Printer Files on a Budget
- (Document Management)
- ... values can also be data fields with values supplied by an RPG or COBOL program. For those who would like to natively print a PDF with these features, once you have a PDF document, it is possible to convert ...
- Created on 15 March 2013
- 1449. TechTip: jQuery Fundamentals, Part III
- (Web Languages)
- ... jQuery APIs: the callback function. To understand the callback paradigm on a simple level, you must first understand how a browser executes JavaScript. I'll explain that by making a comparison to RPG. ...
- Created on 07 March 2013
- 1450. Convert Authority Special Values to and Back from MI Authority Bits
- (RPG)
- ... for the user to access the object; however, if the user has *EXCLUDE private authority to the object, object access will be prohibited. The following RPG example program (autbits01.rpgle) uses the ...
- Created on 05 March 2013