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

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

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
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 2:08 PM
To: Midrange Systems Technical Discussion
Subject: Re: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data



Ted,

check the name (the tilda (~).

also, check your joblog, and the detailed message descriptions therein -
there will be more info on why the copy failed.

Rick

"Time is an illusion. Lunchtime doubly so."

----original message-----
This is what it returned:

CPYFRMIMPF FROMSTMF('/qopt/030502_092250/CONTRA~1.TXT')
       TOFILE(TBARRY/CONTRA) MBROPT(*REPLACE) RCDDLM(*CRLF)
              FLDDLM('|') RPLNULLVAL(*FLDDFT)
File QACP229950 in library QRECOVERY was created.
0 records copied from member QACP229950.

>>> rick.baird@xxxxxxxxxxxxxxx 01/21/04 10:50AM >>


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