RE: AS400 File Import Issue

["Hendricks, Ted" <Ted.Hendricks@xxxxxxxxxxxxxxxxxxx>]

When you use Client access to download, you have to go to File, properties,
check box to convert CCSID 65535.

-----Original Message-----
From: Nandagopal Padmanabhan [mailto:npadmanabhan@xxxxxxxxxxxxxx] 
Sent: Tuesday, April 15, 2003 5:31 PM
To: MAPICS ERP System Discussion
Subject: AS400 File Import Issue


Hello Group,
I've written a query to get item numbers and their base prices and saved the
result to a database file on the AS400. The query works fine and returns
what I'm looking for. However, when I try to import data into a text file
from the database file using "Client Access Data Transfer from AS400", I see
some junk in place of item numbers. The following is a sample screenshot of
what I see: 

Item_Numbers                               Base_Price
F1F0F4F5F6F8404040404040404040     9.490
F1F0F4F5F7F6404040404040404040     33.000
F1F0F4F5F7F7404040404040404040     22.670

What am I doing wrong here? Do I have to change any settings in my query?
Any suggestions/comments will be appreciated. Please help me.

Thanks,
Nandu

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