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.

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....

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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

Common AS/400 FTP questions answered

Converting Lotus Notes views to XML documents using JavaScript

How to create a SQL Server linked server to DB2

Transferring data via FTP on AS/400 systems

Get a template to estimate server power consumption per rack

When the chips are down, Intel turns to VMware's Pat Gelsinger

Intel CEO Bob Swan to be replaced by VMware's Pat Gelsinger