|
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-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.