Re:AS400 File Import Issue

When you have the file transfer from AS/400 window open, go up to File,
properties, select conversions tab, chech option "convert CSID 65535"


Lloyd H. Degnon
I. S. Manager
Ampro Computers Inc.
5215 Hellyer Ave
San Jose, CA 95138
408.360.4365
Ldegnon@xxxxxxxxx
http://www.ampro.com


____________________Reply Separator____________________
Subject:    AS400 File Import Issue
Author: "Nandagopal Padmanabhan" <npadmanabhan@xxxxxxxxxxxxxx>
Date:       4/15/03 5:30 PM

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.

Received: from linux.midrange.com ([207.224.38.113]) by NIXON.AMPRO.COM with
SMTP
  (IMA Internet Exchange 3.14) id 000FB2EE; Tue, 15 Apr 2003 17:27:05 -0700
Received: from linux.midrange.com (localhost [127.0.0.1])
    by linux.midrange.com (8.12.8/8.12.8) with ESMTP id h3G0Usv4009349;
    Tue, 15 Apr 2003 19:30:58 -0500
Received: from vawt10.vestas-awt.com ([12.172.32.131])
    by linux.midrange.com (8.12.8/8.12.8) with ESMTP id h3G0Ugv2009336
    for <mapics-l@xxxxxxxxxxxx>; Tue, 15 Apr 2003 19:30:49 -0500
Received: from MAIL.vestas-awt.com ([10.20.6.10]) by vawt10.vestas-awt.com
    with Microsoft SMTPSVC(5.0.2195.5329);
    Tue, 15 Apr 2003 17:30:37 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
MIME-Version: 1.0
Content-Type: text/plain;
Date: Tue, 15 Apr 2003 17:30:37 -0700
Message-ID: <03508B39873D4F4390F598A2665E278C1BD9EB@xxxxxxxxxxxxxxxxxxx>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
From: "Nandagopal Padmanabhan" <npadmanabhan@xxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
X-OriginalArrivalTime: 16 Apr 2003 00:30:37.0812 (UTC)
    FILETIME=[66F6DB40:01C303AF]
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by linux.midrange.com id
    h3G0Ugv2009336
Subject: AS400 File Import Issue
X-BeenThere: mapics-l@xxxxxxxxxxxx
X-Mailman-Version: 2.1
Precedence: list
Reply-To: MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>
Sender: mapics-l-bounces@xxxxxxxxxxxx
X-Spamscreen: Protected by WatchGuard SpamScreen (TM)
    v6.1.B1000 Copyright (C) 1996-2002 WGTI WGTI