Setting a record length when FTP DB2 Report

July 28, 2011 at 08:52:01
Specs: Windows XP
I'm trying to FTP my DB2 reports to the LAN but the report wraps around. I'm using the FTP command to connect to the mainframe then the GET command to transfer the file.

See More: Setting a record length when FTP DB2 Report

Report •

July 28, 2011 at 21:53:25
How are the DB2 reports being created? SPUFI? QMF? SQL query "PUT" to the DB2 subsystem via FTP? What is the LRECL of the datasets on the 'frame? A couple of places to check out:
Communication Server: IP User's Guide and Commands, specifically chapter 5, FTP subcommands;

STRucture Record,
SITE LRECL=133 (or whatever), and
SITE NOWRAPrecord may get you closer to what you're looking for.

When your only tool is a hammer, every problem looks like a nail.

Report •

July 29, 2011 at 09:11:02
The reports are created via SQL. The reports have a length of 132.

Report •

Related Solutions

Ask Question