How can I stop Client Access from enclosing character fields in ASCII double quotes (X'22') when transferring from the iSeries to a PC CSV file?When I used NetSoft files transfers, the data looked like this:
With Client Access it looks like this:
Callasic csv file should contain quotes however you may try the following:
* Use command as follows on the iSeries:
CPYTOIMPF FROMFILE(DBFILE) TOFILE(CSVFILE) STRDLM(*NONE)
* Use ASCII file transfer in CA to download the result file (i.e. CSVFILE)
MORE INFORMATION ON THIS TOPIC
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
The Best Web Links: Tips, tutorials and more.
Check out this Search400.com Featured Topic: Networking and the iSeries
PC/Windows connectivity expert Shahar Mor is available to answer your toughest networking questions. Ask Shahar a question or read his previously answered questions here.
Dig Deeper on FTP
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.