RE: csv output from cpytoimpf

Dale,

Sorry for being late to this party (and maybe you already posted that this
wasn't an option for you), but if you're downloading this into Access, I
would highly recommend using ODBC to do so.  You get the field names, and
you get the correct data attributes (case in point, if you've got a
3-character alphanumeric field that is filled with numerics, Access will
keep the field/column alphanumeric, whereas if you use a CSV to download
into Access, I'm pretty sure it'll come in as a numeric.)

Just my .02.

- Dan Bale

> -----Original Message-----
> From: Draper, Dale [SMTP:dale.draper@seu.sega.com]
> Sent: Monday, May 15, 2000 5:19 PM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      RE: csv output from cpytoimpf
> 
> 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
+---