Archives

New XLPARSER4 Tool Supports XLSX Format

of HSSFR4, namely: IBM i release 5.4 or higher ILE RPG Compiler (licpgm 57 xx -WDS, option 31) IBM... recommended) The XLPARSER4 RPG code (link is at the end of this article) With those options ...

Topics:
RPG
Java
Application Development

How Can I Get a List of the Environment Variables That Are Set

March 10, 2010

into your own RPG programs. Another key thing to understand is that environment variables ... of retrieving the environment variables in a job from an RPG program: H DFTACTGRP(*NO) ACTGRP(*NEW) D...: The environ variable in ... code is specified with the "import" keyword. This tells RPG to import... parameter to RPG's native format. In your situation, ...

Topics:
RPG

Create Qualified IFS Path Names

March 08, 2010

Trimming blanks from the end of an IFS file or path name isn't the only challenge to using the IFS. Inserting a forward slash to separate the file from the folder name also can be challenging. In this week's Tuesday Tip, Bob Cozzi demonstrates how to crea ...

Topics:
RPG

Reading XML, HTML, CSV, or Plain ASCII Text into RPG

March 04, 2010

Reading an IFS Text File into RPG XML Parsing is easy with the XML-INTO opcode in RPG . You rarely... the XML into RPG ? For that matter, how do you read any IFS ASCII text file into RPG ? ...

Topics:
RPG

APIs by Example: Directing API Output to Output Files Using the SQL CLI APIs

on any IBM i system. While RPG /IV embedded SQL from an SQL perspective provides you with many... an SQL Result Set with RPG ." Now back to the LSTNETCNN command. I've included the command prompt... articles: Read and Write LOBs from an RPG Pointer Field Retrieve an SQL Result Set from a Stored... Retrieve an ...

Topics:
RPG
Application Development
APIs

New POI Release Brings Excel's XLSX Support to RPG

Excel spreadsheets from RPG . The articles have been wildly popular, but they were missing ... were massive, and it's taken me awhile to rewrite the RPG interfaces to be compatible... version as I write this, and it's the version that I've tested all my RPG interfaces... for using the new version of the POI package from RPG : ...

Topics:
Utilities
RPG
Java
Application Development

Podcast: Documentation for ILE RPG Applications

... This is another excellent podcast from the team at the RPG DB2 Summit conference. This time around, Jon Paris interviews Paul Tuohy ... writing documentation in an ILE..., assists with ILE RPG documentation. Click here to access RPGLEDOC on SystemiDeveloper.com . ...

Topics:
Utilities
RPG
ILE (Integrated Language Environment)
Application Development

Calculate the Maximum Size of VARYING Field

February 10, 2010

reserved for RPG to store a number that tracks the current length of the variable. In 5.4 ... return maxlen; /end-free P E The OPDESC keyword tells RPG to use an operational descriptor ...

Topics:
RPG
Application Development

Display Program Version

February 09, 2010

... Program conversion is required to move to i 6.1 and the RPG compiler continues to support just n-2 for the target release parameter. ...

Topics:
RPG

APIs by Example: Work with LAN Printers Command

In the October 22, 2009, APIs by Example column, I present a homegrown version of the Additional Message Information panel. This panel lets you display and optionally reply to a message residing in a message queue, based on the qualified name of the messa ...

Topics:
RPG
Application Development
APIs

ProVIP Sponsors

ProVIP Sponsors