Problem solve Get help with specific problems with your technologies, process and projects.

Extract data from files on the AS/400

Here's a simple method to extract data from files on the AS/400 and make the results available on another platform.

By
  • Timothy Breuer
Published: 17 Apr 2001

Here's a simple method to extract data from files on the AS/400 and make the results available on another platform....

Create a DB2/400 view and FTP it. Since DB2/400 views are implemented as logical files and AS/400 logical files can be transferred using FTP. No need to write a program or run it. The data is always current and available. A view can join multiple files based on complex conditions.


CREATE VIEW library/viewname AS SELECT field1, .. ,fieldN etc ...
FROM library/filename
WHERE fieldX = conditionX
AND fieldY = conditionY etc ...

Example FTP Command ?

OPEN hostname
PUT library/viewname targetfilename
CLOSE

Dig Deeper on RPG iSeries programming

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close