RE: csv output from cpytoimpf

I would use this option, but for the automation of the process. This
information is going to end up somehow to a webserver hosting the MS Access
application that will be refreshed once or twice a day with new data.
Automating a secure connection from a PC or NT server to the 400 is more
difficult than automating and scheduling on the AS400. Security wise, I feel
much more confortable pushing the data out also.
We do use ODBC with Access for internal "executive" informational tools that
work very well. The ODBC driver translates the physical files, so no
download is needed, they query directly against my custom report files.



> -----Original Message-----
> From: Bale, Dan [SMTP:DBale@lear.com]
> Sent: Tuesday, May 16, 2000 7:39 AM
> To:   'MIDRANGE-L@midrange.com'
> Subject:      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
> +---
+---
| 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
+---