Re: CPYTOIMPF, CPYTOSTMF - create fixed length records with comma for EOR?

[mcrump@xxxxxxxxxxxxxxxx]

This actually needs to be very automated.  I have end users who will be hitting
a customers web site and will be transferring this data as a file upload to the
customer's machine.  I want to automatically place this data in the IFS for our
customers to access.  Currently FTP is out of the question.

1.)  Am I correct in believing that this request is a little bit weird?  Fixed
length as well as comma delimiting for EOR.

2.)  I am looking at just placing the commas into the UDB file.  I was just
wondering if any of the CPYTO (PCD, STMF, IMPF) would do this.

Thanks for your input.

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

|-------------------------+-------------------------+-------------------------|
|                         |   "Jim Franz"           |                         |
|                         |   <franz400@triad.rr.com|           To:           |
|                         |   >                     |   MIDRANGE-L@midrange.co|
|                         |                         |   m                     |
|                         |   03/24/01 06:37 PM     |           cc:           |
|                         |   Please respond to     |   (bcc: Mike            |
|                         |   MIDRANGE-L            |   Crump/IT/SGContainers)|
|                         |                         |           Subject:      |
|                         |                         |   Re: CPYTOIMPF,        |
|                         |                         |   CPYTOSTMF - create    |
|                         |                         |   fixed length records  |
|                         |                         |   with comma for EOR?   |
|-------------------------+-------------------------+-------------------------|






[IMAGE]
how automated does this need to be? Client Access will
transfer a file to pc in a fixed length format. Also, since
cpytoimpf works well for comma delimited, you can use it,
then a pc pgm to convert to fixed length. I use a shareware
pc product from Bruce Guthrie, originally written for
Dept of Commerce. http://www.geocities.com/SiliconValley/Lakes/2414
Also, you might just output a db400 file, with the commas,  and ftp it?
hth
jim
----- Original Message -----
From: <mcrump@sgcontainers.com>
To: <midrange-l@midrange.com>
Sent: Saturday, March 24, 2001 10:20 PM
Subject: CPYTOIMPF, CPYTOSTMF - create fixed length records with comma for
EOR?


>
>
>
>
> I have a request to create an ascii file for a customer of ours. The
reqirement
> is for fixed length fields (therefore records) with comma delimeters for
(EOR).
> As far as I can tell this runs against the intent of any of the CPY to
commands.
> Am I correct here?
>
> 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.
>
> Michael Crump
> Saint-Gobain Containers
> 1509 S. Macedonia Ave.
> Muncie, IN 47302
> (765)741-7696
> (765)741-7012 f
> (800)428-8642
>
>
>
> +---
> | 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
+---


(Embedded image moved to file: pic06881.pcx)

pic06881.pcx