RE: csv output from cpytoimpf

["Bale, Dan" <DBale@xxxxxxxx>]

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