R: Creating CSV files on the IFS

Good morning. Personally, i often use:
insert into fileb
select trim(fieldA) , ',' , digits(fieldb), ',' and so on
and then transfer fileb via TCP/IP.
You may bind both SQL and TCP in a CLP.
Sincerely

Domenico Finucci
Fiditalia , Milano, 02- 4301-2494


-----Messaggio originale-----
Da: Goodbar, Loyd (AFS-Water Valley) [mailto:LGoodbar@afs.bwauto.com]
Inviato: mercoledì 14 novembre 2001 16.12
A: 'midrange-l@midrange.com'
Oggetto: Creating CSV files on the IFS


I want to create CSV files on the IFS.
I'm using the CPYTOIMPF command, and it does create CSV files. However, it
does not trim spaces from character fields. Downloading the same file in
Client Access' Data Transfer correctly trims character fields.
A couple of times in the past, I created a file with a single field,
manually createed the CSV entries, and did a CPYTOSTMF. I was hoping a
native OS400 command would do what I want.

Thanks,
Loyd

--
Loyd Goodbar
Programmer/Analyst
BorgWarner Incorporated
Air/Fluid Systems, Water Valley, MS



_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.