All geek questions in one place

Export iSeries to CSV

Is there an iSeries command to export data to a table in CSV format?

I know about Windows utilities, but since it needs to be started automatically, I need to start it from the CL program.

+3
source share
5 answers

You can use CPYTOIMPF and specify the TOSTMF option to place the CSV file in IFS. Example: CPYTOIMPF FROMFILE (DBFILE) TOSTMF ('/outputfile.csv') STMFCODPAG (* PCASCII) RCDDLM (* CRLF)

+11
source

, , " iSeries" IBM iSeries Client Access .CSV. Comma Separated Variable (CSV).

.

+1

. iSeries Client Access , Windows, , , , . , .

+1

FTP . iSeries ZMOD/FTP, - - 3 , , - : " FTP", " DBF" , , " FTP".

IF you do not use ZMOD / FTP: - You can use your own FTP / 400 to accomplish what you need to do, but it is very attractive !!! - you may need to use the RPGLE program to analyze, format and move the data to a "flatfile", and then use your own FTP / 400 for the FTP file - and yes, CL will be required as a wrapper!

0
source

You can do all this in one very simple CL program:

  • CPYTOIMPF file TOSTMF -> cvs file will be in IFS
  • FTP file elsewhere (on a server or PC)

It works like a charm

0
source

Source: https://habr.com/ru/post/1697669/

More articles:


All Articles