RE: CPYTOIMPF and CSV Format

["Art Tostaine, Jr." <artjr@xxxxxxxxxxx>]

We're at V5R1, never seen that before. Are on V4Rx?  Maybe a PTF?

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Ken.Slaugh@xxxxxxxxxx
Sent: Wednesday, August 13, 2003 7:11 PM
To: Midrange Systems Technical Discussion
Subject: CPYTOIMPF and CSV Format


Anyone know how to get the CPYTOIMPF command to output CSV? Here's the
command I ran...

 ===> CPYTOIMPF FROMFILE(DSPERS SQPERS)
TOSTMF('/home/cmi/tulare/SQPERS')
STMFCODPAG(*STDASCII) RCDDLM(*CRLF)

This is the first record in the file.

" ",8832       ,"BAN               ","TERRA       ","INC         ","
",0
,0       ,"          ","           ","         ","               ","
","               ","               ","               ","
","                    ","                  ","  ","          ",0    ,0
,"   "," "," "," "," ","  ",0   ,0    ,0    ,"   ","   ",0          ,"
","                              ",0    ,0        ,.00      ,"  ","  ","
","               ","  ",0   ,0   ," ","     "," ","            ",.00
,"  ",0   ,0   ,0   ,0   ,0    ,"CLW       ","          ",19  ,980508
,"
"," "," "," ","                              ","                    ","
","                  ","  ",0

As you can see the record contains LOTS OF SPACES. Can they be
eliminated
somehow to results in:

"",8832,"BAN","TERRA","INC","",0,0,"","","","","","","","","","","","","
",0,0,"","","","","","",0,0,0,"","",0,"","",0,0,.00,"","","","","",0,0,"
","","","",.00,"",0,0,0,0,0,"CLW","",19,980508,"","","","","","","","","
",0

I have tried STMFCODPAG(*PCASCII) and STMFCODPAG(1252)  as well without
success.

TIA,

Ken Slaugh (707) 795-1512 x118
Chouinard & Myhre, Inc.
CA/400 Certified Specialist
iSeries Network/MSE Administrator
http://www.cm-inc.com/


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