|
I have read all through the archives about this but still am unsure of answer. I on v5r1. This is my CPYTOIMPF command in RPGIV: * C Eval Qcmd = 'CPYTOIMPF FROMFILE('+ C %trim(DRKY) + C ') TOSTMF(''QOpenSys/forcastx/'+ C %trim(DRKY) + C '.txt'') MBROPT(*REPLACE) STMFC'+ C 'ODPAG(*PCASCII) RCDDLM(*CR) D'+ C 'TAFMT(*DLM) STRDLM(*NONE) FLD'+ C 'DLM(X''A1'')' * Sub in FXC for DRKY variable. Here is PF = FXC A R FXCR A* A FXABAN8 60 VARLEN A FXABALPH 60 VARLEN A FXABAC02 60 VARLEN A* A K FXABAN8 For some reason after reading I thought that this would create the .txt file with 3 columns and the length of each field would be determined by the largest value found in a field for all records. So you would end up with something like this after copy. 12345~1111111111~123 ~ 123 ~222222 ~1 ~ 1234 ~33333333 ~1234~ Where it strips out blanks down to largest value. I'm I doing something wrong; because it still puts out fields with length of 60A after copy. Or do I need to strip out blanks myself and build file file? Or get something like the DBG/400 command. Thanks Bill Hopkins Questions,Comments, or "Knocks in the Head" welcomed!
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.