Re: thoughts on z/OS ftp server enhancement.

On Sat, 25 Mar 2017 13:35:52 -0500, Bill Woodger wrote: > >I like pipes. I don't like that little caveat you made, except why would it be >relevant here? > It's probably not relevant, and you seem to understand. But others may need more. When the world was young and DDNAME support by FTP was

Re: thoughts on z/OS ftp server enhancement.

On Sat, 25 Mar 2017 11:38:50 -0500, Paul Gilmartin wrote: >On Sat, 25 Mar 2017 03:29:33 -0500, Bill Woodger wrote: > >>Micro Focus COBOL can read "Mainframe" and write ""PC", several ways. >>Enterprise COBOL can write the data as ASCII (that's just for information, as

Re: thoughts on z/OS ftp server enhancement.

On Sat, 25 Mar 2017 03:29:33 -0500, Bill Woodger wrote: >Micro Focus COBOL can read "Mainframe" and write ""PC", several ways. >Enterprise COBOL can write the data as ASCII (that's just for information, as >DASD-shortage rules that out for you). > Again, could POSIX pipe circumvent that

Re: thoughts on z/OS ftp server enhancement.

Micro Focus COBOL can read "Mainframe" and write ""PC", several ways. Enterprise COBOL can write the data as ASCII (that's just for information, as DASD-shortage rules that out for you). Find out what would be best, and other options, for the non-Mainframe people to receive. Other things than

Re: thoughts on z/OS ftp server enhancement.

On Fri, 24 Mar 2017 21:53:45 -0500, Mike Schwab wrote: >How about doing a portion of the dataset, FTP the result, delete the >intermediate file. Repeat for each segment. I. E. last 1 or 2 digits >of an account number, etc. Using the high order digits could lead to >some groups being pretty

Re: thoughts on z/OS ftp server enhancement.

How about doing a portion of the dataset, FTP the result, delete the intermediate file. Repeat for each segment. I. E. last 1 or 2 digits of an account number, etc. Using the high order digits could lead to some groups being pretty large, I.E. SS#s. Or X number of records. 2nd run skip X,

Re: thoughts on z/OS ftp server enhancement.

McKown <john.archie.mck...@gmail.com> Sent: Friday, March 24, 2017 2:10 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: thoughts on z/OS ftp server enhancement. On Fri, Mar 24, 2017 at 2:56 PM, Frank Swarbrick < frank.swarbr...@outlook.com> wrote: > Sad. > > > It's my observation

Re: thoughts on z/OS ftp server enhancement.

On Fri, Mar 24, 2017 at 2:56 PM, Frank Swarbrick < frank.swarbr...@outlook.com> wrote: > Sad. > > > It's my observation that the best person to create the PowerExchange maps > is someone who knows the mainframe data. But if they won't let you or > another mainframer do it, and they won't / can't

Re: thoughts on z/OS ftp server enhancement.

any mainframe developers left?) Frank From: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> on behalf of John McKown <john.archie.mck...@gmail.com> Sent: Friday, March 24, 2017 10:19 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: thoughts

Re: thoughts on z/OS ftp server enhancement.

On Fri, Mar 24, 2017 at 11:13 AM, Frank Swarbrick < frank.swarbr...@outlook.com> wrote: > There is a true ETL tool component, PowerExchange by Informatica that > allows the actual ETL Tool (PowerCenter) to read IMS and VSAM files as if > they were relational tables. In general I would recommend

Re: thoughts on z/OS ftp server enhancement.

, 2017 7:08 AM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: thoughts on z/OS ftp server enhancement. On Fri, Mar 24, 2017 at 6:41 AM, Steve Smith <sasd...@gmail.com> wrote: > I am over my self-imposed daily limit on IBM-MAIN replies and it's not even > 08:00 yet. However, I see no reason t

Re: thoughts on z/OS ftp server enhancement.

On Fri, Mar 24, 2017 at 8:42 AM, Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > On Fri, 24 Mar 2017 08:08:33 -0500, John McKown wrote: > >> > >> Do whatever it takes to create the actual data set you want to transmit, > >> *then* invoke ftp to transmit it. > >> > THis

Re: thoughts on z/OS ftp server enhancement.

On Fri, 24 Mar 2017 08:08:33 -0500, John McKown wrote: >> >> Do whatever it takes to create the actual data set you want to transmit, >> *then* invoke ftp to transmit it. >> THis may depend on the denizens' of the target system having the privilege and skill to do this. >​... We do have

Re: thoughts on z/OS ftp server enhancement.

John McKown wrote: >Steve Smith wrote: >> Do whatever it takes to create the actual data set you want to transmit, >> *then* invoke ftp to transmit it. >​As the OP for this thread, I would generally concur with the above. I stayed out of this thread to see what others said. I agree 100% with

Re: thoughts on z/OS ftp server enhancement.

On Fri, Mar 24, 2017 at 6:41 AM, Steve Smith wrote: > I am over my self-imposed daily limit on IBM-MAIN replies and it's not even > 08:00 yet. However, I see no reason to "enhance" ftp. In fact, I think > the capability to convert to/from ASCII is misguided (as it's used by

Re: thoughts on z/OS ftp server enhancement.

I am over my self-imposed daily limit on IBM-MAIN replies and it's not even 08:00 yet. However, I see no reason to "enhance" ftp. In fact, I think the capability to convert to/from ASCII is misguided (as it's used by mistake as often as on purpose - see above). Do whatever it takes to create

Re: thoughts on z/OS ftp server enhancement.

On Thu, 23 Mar 2017 18:42:04 -0500, Kirk Wolf wrote: >> >> One of my favorites is: >> ssh User@zOS "cd source & pax -wxpax ." | ( cd target >> & pax >> -rv ) >> >> ... where either "pax" or both could be *some-transfer-program*. XML? >> CSV? I expect Co:Z enhances this, at least by

Re: thoughts on z/OS ftp server enhancement.

On Thu, Mar 23, 2017 at 5:29 PM, Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu> wrote: > > One of my favorites is: > ssh User@zOS "cd source & pax -wxpax ." | ( cd target & pax > -rv ) > > ... where either "pax" or both could be *some-transfer-program*. XML? > CSV? I

Re: thoughts on z/OS ftp server enhancement.

On Thu, 23 Mar 2017 16:54:37 -0500, Kirk Wolf wrote: >You could use the Co:Z Launcher, which works over a secure SSH connection >to distribute work between z/OS batch jobs and processing on a remote >server to this kind of ETL work. > >For example: > >//COZCB2 JOB (),'COZ' >//STEP1 EXEC

Re: thoughts on z/OS ftp server enhancement.

You could use the Co:Z Launcher, which works over a secure SSH connection to distribute work between z/OS batch jobs and processing on a remote server to this kind of ETL work. For example: //COZCB2 JOB (),'COZ' //STEP1 EXEC PROC=COZPROC, //ARGS='my...@linux1.myco.com' //INPUT DD

Re: thoughts on z/OS ftp server enhancement.

351 1966 fax: 214 350 3694 -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Charles Mills Sent: Wednesday, March 22, 2017 3:47 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: thoughts on z/OS ftp server enhancement. I used

Re: thoughts on z/OS ftp server enhancement.

If I understand the use case(s) correctly, IBM already implemented this capability quite some time ago on z/OS. IBM Transformation Extender for z/OS (IBM Program No. 5655-R99) provides this capability, and others. Here's the link to the product page:

Re: thoughts on z/OS ftp server enhancement.

ETL is the TLA I was trying to think of.  CharlesSent from a mobile; please excuse the brevity. Original message From: Mike Bell <mbell1...@gmail.com> Date: 3/22/17 8:15 PM (GMT-08:00) To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: thoughts on z/OS ftp server enhan

Re: thoughts on z/OS ftp server enhancement.

the existing products that do this a generally classified as ETL - extract, transfer and load. most of them are data warehouse style products Mike On Wed, Mar 22, 2017 at 8:19 PM, Mike Schwab wrote: > What you have to do is take the file layout and code SORT or

Re: thoughts on z/OS ftp server enhancement.

What you have to do is take the file layout and code SORT or IEBGENER control cards. They will copy the EBCDIC text fields as is and expand the packed and binary numbers to EBCDIC digits. Then you can FTP the resulting EBCDIC text only file. In some cases you might want to put in quotes and

Re: thoughts on z/OS ftp server enhancement.

On Wed, 22 Mar 2017 15:15:21 -0500, John McKown wrote: > >... So, I was thinking that it might be nice to >have a FTP server command which would set up a "global" data transformation >program as in intermediary. That is, the client (on Windows) would do >something like: > >quote outxform somepgm

Re: thoughts on z/OS ftp server enhancement.

I used to be in the mainframe to ASCII platform file transfer software business. There's a name for what you propose -- some 3-letter acronym -- but I have forgotten. There is a T in it for Transform. We spent a lot of time looking at this, because a recurring customer complaint was "we