Sample PC Command Line for Calling Data Transfer/400 Download

From Support

"C:\PROGRAM FILES\RJSTRAN\TFRDOWN.EXE" "CMDLINE~SELECT * FROM QIWS/QCUSTCDT~USER~PASS~C:\QCUSTCDT.XLS~XLS8~YES"

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