Re: PC 2 AS/400 - don't bother!

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Used *LF instead of *CR and it works!

Steven Donnellan
AS/400 Systems Manager
IBM Certified Specialist - AS/400 Professional Operator
Simon Jersey Ltd

http://www.simonjersey.com




steven.donnellan@simonjersey.com
Sent by: midrange-l-admin@MIDRANGE.COM
03/04/02 15:41
Please respond to midrange-l


        To:     midrange-l@midrange.com
        cc:
        Subject:        PC 2 AS/400


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I am using the following command to get a tab delimited text file from the
IFS to an AS/400 physical file;
CPYFRMIMPF FROMSTMF('/market/Uk group orig.txt')
           TOFILE(JBADATA/QASSPD)
           MBROPT(*UPDADD)
           RCDDLM(*CR)
           FLDDLM(*TAB)
I run it and it copies the first record then reports back;
The copy did not complete for reason code 9.
1 records copied from member QACP461872.
I know you are all dying to know what reason code 9 is, and the suggested
help;
What;
   9 - The data for the field EMID is not valid for the data type of the
TOFILE.
How to fix it;
   9 - Change the data in the FROMFILE.
Helpful, what?
EMID is a numeric field, defined as being 16 digits long on the AS/400.


The file is a PC file of our mailing database.  If there is a better way
of getting the data on to the AS/400 (and bear in mind I'll have to roll
this task out for to a USER(!)) I'm open to suggestions.

Steven Donnellan
AS/400 Systems Manager
IBM Certified Specialist - AS/400 Professional Operator
Simon Jersey Ltd

http://www.simonjersey.com

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please delete
it immediately and notify the sender, do not discuss or disclose the
contents.
The views expressed in the e-mail are those of the author and not
necessarily
those of Simon Jersey Limited.
**********************************************************************
--



_______________________________________________
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.


--