RE: csv output from cpytoimpf

["Draper, Dale" <dale.draper@xxxxxxxxxxxx>]

Wow, we finally have this working nicely, though using a different process
than in the message below. Even sucessfully FTP'd the results. Hell, all
I've ever used is WS_FTP before. (1st time using OS400's FTP). Thanks to
this list and good IBM docs.

But, the guy that needs to use these files in  M$  Access would love to be
able to have the field names in here. And CPYTOIMPF (to a SRCPF I create)
seems to strip these out. Is there a way to copy these or add the field
names? 

> -----Original Message-----
> From: David Morris [SMTP:dmorris@plumcreek.com]
> Sent: Monday, May 15, 2000 11:32 AM
> To:   MIDRANGE-L@midrange.com
> Subject:      RE: csv output from cpytoimpf
> 
> Lance,
> 
> You have to set the code page for the output file before you run your
> CPYTOIMPF.  Look 
> at the MOV and CPY commands.  I use a base file like ASCII.CHR which has a
> code page of 
> 367 and CPY this file to my CPYTOIMPF target.
> 
> David Morris
> 
> >>> Gwecnal@aol.com 05/15/00 10:19AM >>>
> > It's not a matter of life and death for me, but it's bizarre how
> cpytoimpf
> > seems to follow its own path for the comma delimited format.  I'm
> belaboring
> > the obvious here, but CSV is _supposed_ to be a standard for file
> exchange.
> 
> Amen, brother.  As long as we are on the topic - in order to get an
> exterally 
> described file into a comma delimited ASCII format that Excel can read, I 
> have to do a CPYTOIMPF followed by a CPYTOSTMF.  If I do the COPTOIMPF
> direct 
> to a stream file (which is an option) I get garbage because there is no
> place 
> for the CVTDTA table.  Am I the only one who has to do this?  TIA, Lance  
> 
> +---
> | 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
> +---
+---
| 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
+---