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

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

Ted,  

There are special restrictions on the files you can target.

"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 temp 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: Ted Barry [mailto:tbarry@xxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, January 21, 2004 12:27 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data


Yes it is, but that doesn't seem to work either.  The messages don't give
much detail as to what the actual problem is.

>>> pclapham@xxxxxxxxxxxxx 01/21/04 09:52AM >>>
Try '/qsys.lib/tbarry.lib/contra.file', assuming that CONTRA is a physical
file in library TBARRY.

PC2

-----Original Message-----
From: Ted Barry [mailto:tbarry@xxxxxxxxxxxxxxxxxxxx] 
Sent: January 21, 2004 09:37
To: midrange-l@xxxxxxxxxxxx; rpg400-l@xxxxxxxxxxxx 
Subject: Problem with CPYFRMSTMF Using Pipe(|) Delimited Data


CPYFRMSTMF FROMSTMF('/qopt/030502_092250/CONTRA~1.TXT')
TOMBR('/qsys.lib/tbarry.lib/CONTRA') MBROPT(*REPLACE)

An error occurred while trying to resolve object name.                   
Stream file not copied.

Message ID . . . . . . :   CPFA0AE       Severity . . . . . . . :   40      
Message type . . . . . :   Diagnostic                                       
Date sent  . . . . . . :   01/21/04      Time sent  . . . . . . :   09:24:21
                                                                            
Message . . . . :   An error occurred while trying to resolve object name.  
Cause . . . . . :   The problem occurred with object                        
  /qsys.lib/tbarry.lib/CONTRA.                                              
Recovery  . . . :   Check the name to make sure it is correct.  See the job 
  log (DSPJOBLOG command) or press F10 (Display message job log) for        
  additional information.

Any ideas?                                                  
_______________________________________________
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.