|
Jim,
If your requirement is ASCII format , you can use the following parameters
in the CPYTOSTMF command.
If you need any other format , you can use the corresponding translation
table.
Copy To Stream File (CPYTOSTMF)
Type choices, press Enter.
From database file member . . . >
'QSYS.LIB/YourLib.LIB/Yourflatfile.FILE/YourflatFile.MBR'
To stream file . . . . . . . . . >
'QDLS/YourFolder/YourStreamfile'
Copy options . . . . . . . . . . > *REPLACE
*NONE, *ADD, *REPLACE
^^^^ Data conversion options . . . . > *TBL
*AUTO, *TBL, *NONE
Database file CCSID . . . . . . *FILE 1-65533,
*FILE
Stream file codepage . . . . . . *STMF 1-32767,
*STMF
^^^^ Conversion table . . . . . . . . 'QSYS.LIB/QASCII.TBL'
End of line characters . . . . . *CRLF *CRLF,
*LF, *CR, *LFCR...
Note: Here QASCII is the TABLE is QSYS library for conversion to ASCII.
Chellaprabhu.
Metamor Global Solutions Inc.
jim_anderson@kandkinsurance.com on 12/14/98 02:34:31 PM
Please respond to MIDRANGE-L@midrange.com
To: MIDRANGE-L@midrange.com
cc: (bcc: Prabhu Chella/SMS)
Subject: CPYTOSTMF
OK, I've located a command that I belive will copy an AS/400 flat file to a
DIR, which is the CPYTOSTMF (Copy to Stream File) command. I am able to
execute the command just fine, but the data gets scrambled to something I'm
not sure what is.
The file is simple text. Is anyone familiar how I should handle the data
conversion options and code pages?
Jim Anderson
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.