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

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

Ted,

I'm not quite sure what you are trying to do, but if CONTRA is a physical
file with fields that need to be populated by your pipe delim file, you're
using the wrong command.

try this:

CPYFRMIMPF FROMSTMF('/qopt/030502_092250/CONTRA~1.TXT')
TOFILE(TBARRY/CONTRA) MBROPT(*REPLACE) RCDDLM(*CRLF)
FLDDLM('|') RPLNULLVAL(*FLDDFT)

this will use your pipes to delimit the fields into your externally defined
pf.

hth,

Rick

"I've been ordered to take you down to the bridge. Here I am, brain the
size of a planet and they ask me to take you down to the bridge. Call that
job satisfaction? 'Cos I don't." - Marvin the paranoid android

-------------original message------------
Now I'm getting:

Object is not a file or is a file with attributes not supported by this
  command.

I just created the file CONTRA based on the vendors record layout.


>>> klemscot@xxxxxxxxxxxx 01/21/04 09:45AM >>>

The TOMBR name should be something like:

   TOMBR('/qsys.lib/tbarry.lib/contra.file/contra.mbr')

When working with the QSYS.LIB filesystem, the objects are always
"objectname.objecttype" you can't have "CONTRA" because it doesn't contain
the object type.




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