RE: CPYTOIMPF to create a .CSV file..

["Bartell, Aaron L. (TC)" <ALBartell@xxxxxxxxxxxxxx>]

I know that there was a bug with CPYTOIMPF with the code page that was used
when it was created for the first time.

Try creating the ASCII file that you are copying to first with Windows
Explorer and then do your CPYTOIMPF.

Aaron Bartell

-----Original Message-----
From: dmosley@dancik.com [mailto:dmosley@dancik.com]
Sent: Thursday, December 06, 2001 12: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.