RE: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data

Great!

First issue,  AS400 doesn't know that it shoud ignore the first row of data,
if it's all character.  Headings try to go in as records in the database.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: Ted Barry [mailto:tbarry@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 21, 2004 4:22 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data


Here's a sample of the data as it sits on OPT01:

Browse : /qopt/030502_0922/CONTRA~1.TXT

Record :       1   of  339049 by  14            Column :    1    621 by  79

Control :

 

...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+..
.. 
************Beginning of data**************

IPS|APN|HSENO|HSESUB|DIR|STR|SFX|UNITNO|CITY|ZIP|MAILADDR|M_HSENO|M_STR|M_CI
TY|
A013|001-011-005-4|10000|||ARMSTRONG|RD||BYRON||RT 1 BOX 4A HOT SPRINGS
RD;BYRO
A013|001-011-012-0|6320|||BYRON HOT PO BX 327||SP RD|BYRON||P O BOX
327;BYRON C
A013|001-011-013-8||||BYRON HOT SPRINGS|RD||BYRON||255 GLACIER DR;MARTINEZ
CA;%
A013|001-011-017-9|3790|||ARMSTRONG|RD||BYRON||3790 ARMSTRONG RD;BYRON
CA;|3790

Everything is separated by a pipe (|).                 
                                                             

>>> EDeLong@xxxxxxxxxxxxxxx 01/21/04 01:38PM >>>
Oh?  I see that in the subject line, but I guess I never saw that in his
question.  If that's the case, then you're right on target.  Sorry, bout
that....  

Ted, can you tell us about the data?  Are character fields surrounded by "?
If not, try the CPYFRMIMPF command again, with the STRDLM(*NONE) parm.

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: rick.baird@xxxxxxxxxxxxxxx [mailto:rick.baird@xxxxxxxxxxxxxxx] 
Sent: Wednesday, January 21, 2004 3:06 PM
To: Midrange Systems Technical Discussion
Subject: RE: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data



Eric,

I think he's trying to get a pipe delimited file into an externally
described pf, so if he does it with CPYFRMSTRF, the way you describe, he'll
have the pipes in his physical and his fields/attributes won't line up.

I'm not sure exactly what his problem is, but I think the solution involves
using cpyfrmimpf instead.

Rick

"Ford, you're turning into a penguin. Stop it." - Arthur Dent

-------Original message--------
Ok, I'll try again.

There are special restrictions on the files you can target.

>From help for TOFILE parm....
"The file may be either a source physical file or a
program-described physical file.  Source physical files
with multiple data fields are not supported.

If the database file is a source physical file, a sequence
number and a date stamp of zeros is added to each record
as it is copied to the database file member.               "


Try creating a flat file in QTEMP with the correct record length, then CPYF
*NOCHK into your database file.

Eric DeLong


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