Q
Problem solve Get help with specific problems with your technologies, process and projects.

Stop CA from enclosing character fields

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:
Thomas,Emanuele,100.00

With Client Access it looks like this:
"Thomas","Emanuele",100.00


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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close