iSeries Export to CSV

Question

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.

Are you still here? I would be very grateful igf you could provide me with some help on the exact same topic — Alkis Ko, Mar 29 '21 at 14:57
could i please get some extra help on this? @nearly_lunchtime — Alkis Ko, Mar 29 '21 at 15:02

score 13 · Accepted Answer · answered Sep 30 '08 at 17:35

13

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)

answered Sep 30 '08 at 17:35

Todd Waldorf

156
5

You can also use this command with the TOFILE keyword instead of the TOSTMF keyword to load a CSV file in a library. – Paul Morgan Nov 07 '08 at 18:13
So that copies your file to the ifs . How are you supposed to take the file from the ifs and into a folder in your pc? – Alkis Ko Mar 29 '21 at 14:56
could i please get some extra help on this? @mike – Alkis Ko Mar 29 '21 at 15:04

score 1 · Answer 2 · answered Sep 29 '08 at 14:29

If you want the data to be downloaded directly to a PC, you can use the "Data Transfer from iSeries" function of IBM iSeries Client Access to create a .CSV file. In the file output details dialog, set the file type to Comma Separated Variable (CSV).

You can save the transfer description to be reused later.

score 1 · Answer 3 · answered Sep 30 '08 at 23:32

1

You could use a trigger. The iSeries Client Access software wont do since that is a windows application, what I understand is that you need the data to be exported each time that the file is written. Check this link to know more about triggers.

answered Sep 30 '08 at 23:32

Gustavo Rubio

10,209
8
39
57

score 0 · Answer 4 · answered Aug 21 '13 at 01:57

You are going to need FTP to perform that action. If your iSeries shop uses ZMOD/FTP your shortest solution is a few lines of code away -- 3 lines to be exact -- the three lines are to Start FTP, Put DBF, and finally, End FTP.

IF you don't use ZMOD/FTP: - You could use native FTP/400 to accomplish what you need to do, but it is quite involved!!! - you may probably need to use an RPGLE program to parse, format, and move, data into a "flatfile", then use native FTP/400 to FTP the file out - and yes, a CL will need as a wrapper!

FTP might or might not be needed. Without knowing the network connectivity, we have no way to know. — user2338816, Jan 31 '16 at 07:43

score 0 · Answer 5 · answered Jan 30 '16 at 19:18

0

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

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

It works like a charm

answered Jan 30 '16 at 19:18

FredericP

1,119
1
14
27

iSeries Export to CSV

5 Answers5