Re: ASCII DELIMITED TEXT FILES

Well, my process is creating the files, where they don't already exist in
most cases. If you have an existing file, you might try leaving off the
STMFCCSID parameter. I have done that in one of my processes where the
file always exists.






From: Rick Mason <rmason62@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/10/2015 03:27 PM
Subject: Re: ASCII DELIMITED TEXT FILES
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Darren,
I keep getting the following error:
The copy did not complete for reason code 1.
Reason code 1 = the ccsid or code page value is not valid.

Any ideas?
Thanks
On Dec 10, 2015 2:58 PM, <darren@xxxxxxxxx> wrote:

The CL command, CPYTOIMPF

Example from an RPG program:

cmd= 'CPYTOIMPF FROMFILE(QTEMP/UR5006V) '
+ 'TOSTMF(''' + Stmf + ''') '
+ 'MBROPT(*REPLACE) '
+ 'STMFCCSID(*PCASCII) '
+ 'RCDDLM(*CRLF) '
+ 'RMVBLANK(*BOTH) '
+ 'ADDCOLNAM(*SQL) '



From: Rick Mason <rmason62@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 12/10/2015 02:47 PM
Subject: ASCII DELIMITED TEXT FILES
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Hi,
What would the most efficient way of downloading/exporting ibm i files
(large and small) to ascii delimited text files?
Thanks
Rick
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

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