Ad
ISeries Export To CSV
Is there an iSeries command to export the data in a table to CSV format?
I know about the Windows utilities, but since this needs to be run automatically I need to run this from a CL program.
Ad
Answer
You can use CPYTOIMPF and specify the TOSTMF option to place a CSV file on the IFS. Example: CPYTOIMPF FROMFILE(DBFILE) TOSTMF('/outputfile.csv') STMFCODPAG(*PCASCII) RCDDLM(*CRLF)
Ad
source: stackoverflow.com
Related Questions
- → OctoberCMS - Creating file attachment in seeder
- → Laravel save CSV file error
- → October CMS export data to CSV from backend
- → Importing large CSV files in MySQL using Laravel
- → VBA how do I edit cell contents based on contents of two other cells in same row
- → Rake task handle 404
- → Can I assign products to collections using csv in shopify?
- → Shopify customize order export csv file
- → Shopify import reviews via API?
- → Can files be updated and read using the JavaScript FileReader interface?
- → Export a list of users in OctoberCMS to CSV
- → Convert array to CSV including multi-line image
- → Shopify_api Ruby Gem not creating fulfillment
Ad