RE: CPYTOIMPF, CPYTOSTMF - create fixed length records with comma for EOR? -- MIDRANGE-L






Chris,

I have tried your suggestion previously. �I receive a �message CPF2845 ' The
copy did not complete for reason code 11.' �If I read the second level help text
properly it seems that if I reference a stream file as my target than *CR,
*CRLF, *LF, and *LFCR are my only options. �If I reference a UDB file than I can
choose a character value ( ',' in this case) or *EOR.

I have tried every combination I can think of without much success. �I have done
some testing with first attempting to copy this to the UDB and then to the STMF
but have not gotten the results I've expected. �I may end up programatically
adding the ',' to the UDB file and then creating the stream file.....

My biggest problem is that I need this to be automated on the AS/400. �I am
trying to avoid using any client software so that this can be controlled
centrally for many users. �I am going to place the data on our IFS for them to
use.

Michael Crump
Saint-Gobain Containers
1509 S. Macedonia Ave.
Muncie, IN �47302
(765)741-7696
(765)741-7012 f
(800)428-8642

|-------------------------+-------------------------+-------------------------|
|                         |   Chris Bipes           |                         |
|                         |   <chris.bipes@cross-che|   � � � � To:           |
|                         |   ck.com>               |   "'MIDRANGE-L@midrange.|
|                         |                         |   com'"                 |
|                         |   03/24/01 11:34 PM     |   <MIDRANGE-L@midrange.c|
|                         |   Please respond to     |   om>                   |
|                         |   MIDRANGE-L            |   � � � � cc:           |
|                         |                         |   (bcc: Mike            |
|                         |                         |   Crump/IT/SGContainers)|
|                         |                         |   � � � � Subject:      |
|                         |                         |   RE: CPYTOIMPF,        |
|                         |                         |   CPYTOSTMF - create    |
|                         |                         |   fixed length records  |
|                         |                         |   with comma � � � � for|
|                         |                         |   EOR?                  |
|-------------------------+-------------------------+-------------------------|






[IMAGE]
Try this and let us know if it works.

CPYTOIMPF FROMFILE(XYZZ)
� � � � �TOSTMF('\HOME\WEIRD.STRMF'),
� � � � �RCDDLM(',')
� � � � �DTAFMT(*FIXED)
� � � � �STRDLM(*NONE)
� � � � �FLDDLM('')

Original Message:

Essentially, the customer is looking for a file to look something like this:
Record1,Record2,Record3, Record4, Record5, Record6
So, 1.) am I correct in believing that fixed length and comma delimited are
almost contrary terms? and 2.) any ideas on how to accomplish this? �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
+---


(Embedded image moved to file: pic14671.pcx)
pic14671.pcx