Re: Exporting DB2/400 records . . .

I tried the "IBM Navigator for i" version of this.

When I asked to "show command" I could see:
/* Creating view to subset the data */
CREATE VIEW QTEMP.AAAKEY AS (SELECT
LOC,
COMP,
CONAME,
SYSTEM,
DBLIB,
THISISAREALLYBIGFIELD
FROM ROB.AAAKEY);

/* Exporting data from ROB.AAAKEY */
CL:CPYTOIMPF FROMFILE(QTEMP/AAAKEY) TOSTMF('/home/ROB/yo.csv')
STMFCCSID(37) STMFAUT(*DFT) MBROPT(*ADD) FROMCCSID(*FILE) RMVBLANK(*NONE)
NUMFLDPAD(*NONE) RCDDLM(*CRLF) DTAFMT(*DLM) STRDLM(*DBLQUOTE) FLDDLM(',')
STRESCCHR(*STRDLM) DECPNT(*PERIOD) DATFMT(*ISO) TIMFMT(*ISO);

Then I tried running it. After several minutes on a two row table I
aborted the process and said to heck with it. Methinks they have an
issues communication between the client and server. The data where there
in the stream file
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+
************Beginning of data**************
"01.999 ",1 ,"DUH LOUIE "," ","
"," "
"81.001 ",81 ,"Hoosier Wire ","HOOSIER ","HWIFILE "," "
************End of Data********************


Rob Berendt