RE: CPYTOIMPF to create a .CSV file..

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

i don't see the parm for 'STREAM FILE CODE PAGE'  lets you select *PCASCII,
*STMF or a number.

If you don't have this, then you need a PTF.  not sure what the number is,
but its in the archives. under CPYTOIMPF

-----Original Message-----
From: dmosley@dancik.com [mailto:dmosley@dancik.com]
Sent: Thursday, December 06, 2001 1:14 PM
To: rpg400-l@midrange.com
Subject: CPYTOIMPF to create a .CSV file..



I'm doing this command to create a .CSV file, but I am getting junk,  What
am I missing here?

>From file:
  File . . . . . . . . . . . . . > DM@TEST       Name
    Library  . . . . . . . . . . >   DOD@DTAEXT  Name, *LIBL, *CURLIB
  Member . . . . . . . . . . . .   *FIRST        Name, *FIRST
To data base file:
  File . . . . . . . . . . . . .                 Name
    Library  . . . . . . . . . .     *LIBL       Name, *LIBL, *CURLIB
  Member . . . . . . . . . . . .   *FIRST        Name, *FIRST
To stream file . . . . . . . . . > '/home/www/stdir/dm@test.csv'
Replace or add records . . . . . > *REPLACE      *ADD, *REPLACE
To CCSID . . . . . . . . . . . .   *FILE         1-65533, *FILE
Record delimiter . . . . . . . . > *CRLF         Character value, *EOR...
Record format of import file . . > *DLM          *DLM, *FIXED
String delimiter . . . . . . . .   '"'           Character value, *NONE
Field delimiter  . . . . . . . .   ','           Character value


David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513

_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.