RE: CPYTOIMPF

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

Hmmm...

  

I'm assuming that by "pipe" you mean this character: '|'.  This seems to
work for me:

CPYTOIMPF FROMFILE(JEFFILES/TESTER) TOSTMF('/home/jef/tester.txt') RCDDLM 
(*CRLF) FLDDLM('|') STMFCODPAG(*PCASCII)

How are you calling the command?                                  

-----Original Message-----
From: saustad@deltadentalwi.com [mailto:saustad@deltadentalwi.com]
Sent: Thursday, July 19, 2001 5:56 PM
To: midrange-l@midrange.com
Cc: llandin@deltadentalwi.com; dkramer@deltadentalwi.com;
jcampbell@deltadentalwi.com
Subject: CPYTOIMPF


We have a data warehousing project we are working on.  We'd like to take a
physical file and copy it to the IFS as a pipe-delimited, variable-length
field, ASCII text file.  The alphanumeric fields should not contain the
trailing blanks.  The numeric fields should not contain the leading zeroes.
The CPYTOIMPF cmd seems to work, except the "pipes" are showing up fixed in
the same column on each record.  Is there a parameter we are missing, or
something?  Any help would be greatly appreciated.  Thanks.

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---