By
Published: 17 Mar 2005
I would like to find out whether it is possible to write a program using RPG LE or CL to access text files stored in folders on Windows NT. I'd like to write directly to a DB2 file (flat file) on iSeries. i.e., there are three text files in the folder, and my RPGLE/CL programs are to read all three text files and write to the DB2 file in iSeries.
I have done this myself recently and used an excellent article from Scott Klement in iSeries News magazine, "RPG and the IFS; Text Files in the World". (You may have to subscribe to review these articles and to download the code.)
I also used other articles by Scott: "Don't Submit, Spawn!" to execute a directory list command, and "Communicating through a Pipe" to read the directory listing in my program. These articles are also available on the iSeries Network website, and came through Club Tech Programming Tips to those who subscribe to them. I have created a *MODULE object containing all the relevant procedures (and a few more). You can view the source code here.
==================================
MORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: tips, tutorials and more.
Visit the ITKnowledge Exchange and get answers to your developing questions fast.
Ask the Experts yourself: Our application development gurus are waiting to answer your programming questions.
Dig Deeper on RPG iSeries programming
When an error occurs on an IBM command, the diagnostic messages are sent first, then an escape message, which you can monitor. On AS/400 you see the ...
Continue Reading
Learn how to 'append data to the file' with the FTP DIR command, and eliminate the hassle of having to end the FTP session and restart to view ...
Continue Reading
RPGIV will 'think of' incoming integer fields as binary, and then will redefine them in the program structures as PACKED. So, when you chain a record...
Continue Reading
Start the conversation
0 comments