A program to access stored text files

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

Application development freeware and shareware guide Application development freeware and shareware guide.

PC/Windows connectivity: Top 10 expert Q&As Shahar Mor, iSeries/i5 PC/Windows connectivity expert, has been answering Search400.com's member questions for more than five years. Shahar has seen many of the same issues and concerns asked again and again. Therefore, we've compiled the top 10 questions asked about iSeries/i5 connectivity for you.

SQL Built-In Functions and Stored Procedures -- Chapter 2 As a member of Search400.com, you're entitled to a complimentary copy of Chapter 2 of "Stored Procedures and Built-In Functions" written by Mike Faust and published by MC Press. This chapter, Built-In Functions" will explore the BIFs included in the DB2 implementation of SQL on the iSeries.

Ways to put QSHELL to work in your day-to-day programming life Jagannath Lenka shows you how QSHELL complements CL and how you can use it in your day-to-day iSeries programming life.

Automate programming tasks Learn how to create programming tools that you can use to create sections of code.

Three tips for using WebFacing Trying to find your way around IBM's WebFacing? Site expert Jim Mason guides you through three tricky areas.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

A program to access stored text files

Dig Deeper on RPG iSeries programming

Related Q&A from John Blenkinsop

Monitoring escape messages and using RCVMSG for diagnostic messages

Listing contents of multiple FTP directories on AS/400

Chain operation error after converting RPG3 to ILE RPG (RPGIV)

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Get eco-friendly with LEED data center certification

Top 4 open source automation tools for admins

U.S. facility may have best data center PUE

Dig Deeper on RPG iSeries programming

Related Q&A from John Blenkinsop

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.