Sample AS/400 Command Line for Calling Data Transfer/400 Download

From Support

Listed below is a sample Data Transfer/400 command line for downloading as AS/400 names QCUSTCDT from library QIWS to an Excel Spreadsheet named C:\QCUSTCDT.XLS

FTPRUNPC CMD('"C:\PROGRAM FILES\RJSTRAN\TFRDOWN.EXE" "CMDLINE~SELECT * FROM QIWS/QCUSTCDT~USERID~PASSWORD~C:\QCUSTCDT.XLS~XLS8~YES"') OPTION(*SHELLWAIT)

The PC command line parameters for the Data Transfer/400 program are:

P1 = Type of transfer

     Settings INI File Name = If using stored settings
     CMDLINE = Command Line Transfer
     CMDDEBUG = Displays popup messagebox of command line parms for debugging

P2 = SQL select statement

P3 = AS/400 user

P4 = AS/400 password

P5 = Output PC file

P6 = Output data type

     CSV = Comma Separated Variable
     XLS8 = Excel 97/2000
     DBF4 = Dbase IV
     MDB = MS Access
     FIX = Fixed Length ASCII record

P7 = Replace file

     YES = Replace output file
     NO = Do not replace
     
     Default value if not passed = NO