Re: FTP - how get RDW and ASCII

[Shmuel Metz (Seymour J.)]

In <0fac01d0e4c7$1cbd7eb0$56387c10$@mcn.org>, on 09/01/2015
   at 08:01 AM, Charles Mills  said:

>I have a legacy dataset in VB format. I would like to FTP it to a PC
>(1) translating the record data to ASCII and (2) preserving the LLBB
>record control words.

Will RECFM=D work on DASD?
 
-- 
 Shmuel (Seymour J.) Metz, SysProg and JOAT
 ISO position; see  
We don't care. We don't have to care, we're Congress.
(S877: The Shut up and Eat Your spam act of 2003)

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Ed Finnell]

Which translate table does it use? Or can one specify them as a PARM?
 
 
In a message dated 9/1/2015 11:01:13 A.M. Central Daylight Time,  
charl...@mcn.org writes:

DFSORT  has the capability of converting from EBCDIC to ASCII and  
vice-versa


--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Sri h Kolusu]

> Which translate table does it use? 
Ed,

Here are the 2 tables that DFSORT uses to convert.(Table 39 and Table 40)

http://tinyurl.com/ntrbfrd

>>Or can one specify them as a PARM?

No you cannot, however you can use ALTSEQ parm to specify your own table.

Thanks,
Kolusu
DFSORT Development
IBM Corporation
IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 
09/01/2015 12:25:51 PM:

> From: Ed Finnell <000248cce9f3-dmarc-requ...@listserv.ua.edu>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 09/01/2015 12:26 PM
> Subject: Re: FTP - how get RDW and ASCII
> Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU>
> 
> Which translate table does it use? Or can one specify them as a PARM?
> 
> 
> In a message dated 9/1/2015 11:01:13 A.M. Central Daylight Time, 
> charl...@mcn.org writes:
> 
> DFSORT  has the capability of converting from EBCDIC to ASCII and 
> vice-versa
> 
> 
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> 



--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Barry Merrill]

i. ftp instructions for sending data to the MXG ftp site

   Using the IBM ftp program, you can ftp any MVS data file to the
   MXG ftp site with this syntax; do NOT change the DCB attributes
   of the //SMFFILE DD: even though it points to a VBS DSNAME, the
   RECFM=U,BLKSIZE=32760 must be used to include BDW and RDWs.

  //FTP  EXEC PGM=FTP,PARM='(EXIT=4'
  //SYSPRINT DD  SYSOUT=*
  //SMFFILE  DD DSN=YOUR.SMF.DATA,DCB=RECFM=U,BLKSIZE=32760,DISP=SHR
  //INPUT DD *
  ftp.mxg.com
  mxgtech mxgtech
  quote PASV
  bin
  put //DD:SMFFILE  yourname.smf
  close
  quit
  /*

  IMPORTANT:  userid/password may be mixed case
  do NOT change the DCB attributes of the //SMFFILE DD.

  IMPORTANT:  Some sites MUST use the "quote PASV" argument, so it
  is the default, but for some sites it can NOT be use
  and must be removed. Try both.

  IMPORTANT:  The ftp control statements MUST BE UNNUMBERED.

Barry


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Charles Mills
Sent: Tuesday, September 01, 2015 10:02 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: FTP - how get RDW and ASCII

I have a legacy dataset in VB format. I would like to FTP it to a PC (1)
translating the record data to ASCII and (2) preserving the LLBB record
control words. (Don't need the block control words.) I tried the obvious
ASCII and QUOTE SITE RDW but FTP has translated my RDWs to ASCII (rendering
them useless of course). Does anyone have a clever trick to translate the
"data" portion of the records to ASCII but preserve the LLBBs?

This is a one-time development chore, not a nightly production job. I'm not
fussy about code pages and so forth. The dataset is small: 30 records, 20K
total.

One of you UNIX experts: should I just translate it to ASCII on z/OS first
and then FTP it in binary with RDWs? Would someone be so kind as to share
the command to do the translate? Again, the existing dataset is legacy MVS,
and I need to preserve LLBBs.

Thanks,

Charles 

--
For IBM-MAIN subscribe / signoff / archive access instructions, send email
to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

FTP - how get RDW and ASCII

[Charles Mills]

I have a legacy dataset in VB format. I would like to FTP it to a PC (1)
translating the record data to ASCII and (2) preserving the LLBB record
control words. (Don't need the block control words.) I tried the obvious
ASCII and QUOTE SITE RDW but FTP has translated my RDWs to ASCII (rendering
them useless of course). Does anyone have a clever trick to translate the
"data" portion of the records to ASCII but preserve the LLBBs?

This is a one-time development chore, not a nightly production job. I'm not
fussy about code pages and so forth. The dataset is small: 30 records, 20K
total.

One of you UNIX experts: should I just translate it to ASCII on z/OS first
and then FTP it in binary with RDWs? Would someone be so kind as to share
the command to do the translate? Again, the existing dataset is legacy MVS,
and I need to preserve LLBBs.

Thanks,

Charles 

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Charles Mills]

Thanks Barry. I don't see any ASCII translation in there. Am I missing
something?

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Barry Merrill
Sent: Tuesday, September 01, 2015 8:04 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

i. ftp instructions for sending data to the MXG ftp site

   Using the IBM ftp program, you can ftp any MVS data file to the
   MXG ftp site with this syntax; do NOT change the DCB attributes
   of the //SMFFILE DD: even though it points to a VBS DSNAME, the
   RECFM=U,BLKSIZE=32760 must be used to include BDW and RDWs.

  //FTP  EXEC PGM=FTP,PARM='(EXIT=4'
  //SYSPRINT DD  SYSOUT=*
  //SMFFILE  DD DSN=YOUR.SMF.DATA,DCB=RECFM=U,BLKSIZE=32760,DISP=SHR
  //INPUT DD *
  ftp.mxg.com
  mxgtech mxgtech
  quote PASV
  bin
  put //DD:SMFFILE  yourname.smf
  close
  quit
  /*

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[John Abell]

We use locsite rdw when FTPing from the mainframe.

John T. Abell
Tel:800-295-7608Option 4
President 
International:  1-416-593-5578  Option 4
E-mail:  john.ab...@intnlsoftwareproducts.com
Fax:800-295-7609

International:  1-416-593-5579


International Software Products
www.ispinfo.com


This email may contain confidential and privileged material for the sole use
of the intended recipient(s). Any review, use, retention, distribution or
disclosure by others is strictly prohibited. If you are not the intended
recipient (or authorized to receive on behalf of the named recipient),
please contact the sender by reply email and delete all copies of this
message. Also,email is susceptible to data corruption, interception,
tampering, unauthorized amendment and viruses. We only send and receive
emails on the basis that we are not liable for any such corruption,
interception, tampering, amendment or viruses or any consequence thereof.


-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Charles Mills
Sent: Tuesday, September 01, 2015 11:15 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

Thanks Barry. I don't see any ASCII translation in there. Am I missing
something?

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Barry Merrill
Sent: Tuesday, September 01, 2015 8:04 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

i. ftp instructions for sending data to the MXG ftp site

   Using the IBM ftp program, you can ftp any MVS data file to the
   MXG ftp site with this syntax; do NOT change the DCB attributes
   of the //SMFFILE DD: even though it points to a VBS DSNAME, the
   RECFM=U,BLKSIZE=32760 must be used to include BDW and RDWs.

  //FTP  EXEC PGM=FTP,PARM='(EXIT=4'
  //SYSPRINT DD  SYSOUT=*
  //SMFFILE  DD DSN=YOUR.SMF.DATA,DCB=RECFM=U,BLKSIZE=32760,DISP=SHR
  //INPUT DD *
  ftp.mxg.com
  mxgtech mxgtech
  quote PASV
  bin
  put //DD:SMFFILE  yourname.smf
  close
  quit
  /*

--
For IBM-MAIN subscribe / signoff / archive access instructions, send email
to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Charles Mills]

Bingo! Perfect. Thanks.

Haven't done the download yet but that should be straightforward.

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Norbert Friemel
Sent: Tuesday, September 01, 2015 8:29 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

On Tue, 1 Sep 2015 08:01:42 -0700, Charles Mills wrote:

>I have a legacy dataset in VB format. I would like to FTP it to a PC 
>(1) translating the record data to ASCII and (2) preserving the LLBB 
>record control words. (Don't need the block control words.) I tried the 
>obvious ASCII and QUOTE SITE RDW but FTP has translated my RDWs to 
>ASCII (rendering them useless of course). Does anyone have a clever 
>trick to translate the "data" portion of the records to ASCII but preserve the 
>LLBBs?
>
>This is a one-time development chore, not a nightly production job. I'm 
>not fussy about code pages and so forth. The dataset is small: 30 
>records, 20K total.
>
>One of you UNIX experts: should I just translate it to ASCII on z/OS 
>first and then FTP it in binary with RDWs? Would someone be so kind as 
>to share the command to do the translate? Again, the existing dataset 
>is legacy MVS, and I need to preserve LLBBs.
>
>

Not Unix, but...

//*   
//STEP1   EXEC PGM=SORT   
//*   
//SYSOUTDD SYSOUT=*   
//SORTINDD DISP=OLD,DSN=VB-EBCDIC   
//SORTOUT   DD DISP=(,CATLG,DELETE),  
// SPACE=(TRK,(5,5),RLSE),
// DSN=VB-ASCII   
//SYSIN DD *  
  OUTFIL BUILD=(1,4,5,TRAN=ETOA)  
  OPTION COPY 
/*

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Norbert Friemel]

On Tue, 1 Sep 2015 08:01:42 -0700, Charles Mills wrote:

>I have a legacy dataset in VB format. I would like to FTP it to a PC (1)
>translating the record data to ASCII and (2) preserving the LLBB record
>control words. (Don't need the block control words.) I tried the obvious
>ASCII and QUOTE SITE RDW but FTP has translated my RDWs to ASCII (rendering
>them useless of course). Does anyone have a clever trick to translate the
>"data" portion of the records to ASCII but preserve the LLBBs?
>
>This is a one-time development chore, not a nightly production job. I'm not
>fussy about code pages and so forth. The dataset is small: 30 records, 20K
>total.
>
>One of you UNIX experts: should I just translate it to ASCII on z/OS first
>and then FTP it in binary with RDWs? Would someone be so kind as to share
>the command to do the translate? Again, the existing dataset is legacy MVS,
>and I need to preserve LLBBs.
>
>

Not Unix, but...

//*   
//STEP1   EXEC PGM=SORT   
//*   
//SYSOUTDD SYSOUT=*   
//SORTINDD DISP=OLD,DSN=VB-EBCDIC   
//SORTOUT   DD DISP=(,CATLG,DELETE),  
// SPACE=(TRK,(5,5),RLSE),
// DSN=VB-ASCII   
//SYSIN DD *  
  OUTFIL BUILD=(1,4,5,TRAN=ETOA)  
  OPTION COPY 
/*

... or use dataset pipes (fromdsn -l rdw -s IBM- -t IBM- ...) 
http://www.dovetail.com/docs/coz/dsp-ref_fromdsn.html


Norbert Friemel

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Barry Merrill]

I had not read your specification with enough care;  my ftp
example preserves the full binary VB record structure.
So, then, after the ftp download, your (SAS?) program on 
ASCII can INPUT just the data portion of each  record
as ASCII text:

  FILENAME ONASCII 'C:\yourdata\downloaded.vb' recfm=s370vbs lrecl=32760;
  DATA ASCIIDATA (KEEP=DATAPART LENGTH);
  INFILE ONASCII LENGTH=LEN;
  LENGTH=LEN;
  INPUT @;
  INPUT DATAPART $VARYING32760. LENGTH @;

Barry


Herbert W. "Barry" Merrill, PhD
President-Programmer
MXG Software
Merrill Consultants
10717 Cromwell Drive
Dallas, TX 75229-5112
ba...@mxg.com
Fax:  214 350 3694 - Still works, received as email
Tel:  214 351 1966 - Unreliable, please use email

www.mxg.comHomePage: FAQ answers most questions
ad...@mxg.com  License Forms, Invoice, Payment, ftp information
supp...@mxg.comTechnical Issues 
MXG-L FREE ListServer  http://www.mxg.com/mxg-l_listserver/


 

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Charles Mills
Sent: Tuesday, September 01, 2015 10:15 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

Thanks Barry. I don't see any ASCII translation in there. Am I missing
something?

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Barry Merrill
Sent: Tuesday, September 01, 2015 8:04 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

i. ftp instructions for sending data to the MXG ftp site

   Using the IBM ftp program, you can ftp any MVS data file to the
   MXG ftp site with this syntax; do NOT change the DCB attributes
   of the //SMFFILE DD: even though it points to a VBS DSNAME, the
   RECFM=U,BLKSIZE=32760 must be used to include BDW and RDWs.

  //FTP  EXEC PGM=FTP,PARM='(EXIT=4'
  //SYSPRINT DD  SYSOUT=*
  //SMFFILE  DD DSN=YOUR.SMF.DATA,DCB=RECFM=U,BLKSIZE=32760,DISP=SHR
  //INPUT DD *
  ftp.mxg.com
  mxgtech mxgtech
  quote PASV
  bin
  put //DD:SMFFILE  yourname.smf
  close
  quit
  /*

--
For IBM-MAIN subscribe / signoff / archive access instructions, send email
to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Don Williams]

Years ago I wanted the same and I never found one nor wrote one. FTP's
EBCDIC <-> ASCII translation is for the entire logical record. You would
need a "field" level translation to get no translation for the length
fields and EBCDIC <-> ASCII translation for the text fields.

On Tue, Sep 1, 2015 at 11:15 AM Charles Mills <charl...@mcn.org> wrote:

> Thanks Barry. I don't see any ASCII translation in there. Am I missing
> something?
>
> Charles
>
> -Original Message-
> From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
> Behalf Of Barry Merrill
> Sent: Tuesday, September 01, 2015 8:04 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: FTP - how get RDW and ASCII
>
> i. ftp instructions for sending data to the MXG ftp site
>
>Using the IBM ftp program, you can ftp any MVS data file to the
>MXG ftp site with this syntax; do NOT change the DCB attributes
>of the //SMFFILE DD: even though it points to a VBS DSNAME, the
>RECFM=U,BLKSIZE=32760 must be used to include BDW and RDWs.
>
>   //FTP  EXEC PGM=FTP,PARM='(EXIT=4'
>   //SYSPRINT DD  SYSOUT=*
>   //SMFFILE  DD DSN=YOUR.SMF.DATA,DCB=RECFM=U,BLKSIZE=32760,DISP=SHR
>   //INPUT DD *
>   ftp.mxg.com
>   mxgtech mxgtech
>   quote PASV
>   bin
>   put //DD:SMFFILE  yourname.smf
>   close
>   quit
>   /*
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

AW: Re: FTP - how get RDW and ASCII

[Peter Hunkeler]

> Not Unix, but...


Not UNIX either, but...

//ICONV EXEC PROC=EDCICONV,
// INFILE=?FRED.INFILE?,
// OUTFILE=?FRED.OUTFILE?,
// FROMC=?IBM-037?,
// TOC=?ISO8859-1?


--
Peter Hunkeler







--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Sri h Kolusu]

>>should I just translate it to ASCII on z/OS first and then FTP it in 
binary with RDWs? Would someone be so kind as to share the command to do 
the translate?
>>Years ago I wanted the same and I never found one nor wrote one. FTP's 
EBCDIC <-> ASCII translation is for the entire logical record. You would
need a "field" level translation to get no translation for the length 
fields and EBCDIC <-> ASCII translation for the text fields.

Charles/Don,

DFSORT has the capability of converting from EBCDIC to ASCII and 
vice-versa

TRAN=ETOA converts EBCDIC characters to ASCII characters 
TRAN=ATOE converts ASCII characters to EBCDIC characters

//STEP0100 EXEC PGM=SORT 
//SYSOUT   DD SYSOUT=* 
//SORTIN   DD DISP=SHR,DSN=Your.INPUT.VB.FILE 
//SORTOUT  DD SYSOUT=* 
//SYSINDD * 
  OPTION COPY 
  INREC BUILD=(1,4,5,TRAN=ETOA) 
//* 


Further if you have any questions please let me know

Thanks,
Kolusu
DFSORT Development
IBM Corporation

IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 
09/01/2015 08:01:42 AM:

> From: Charles Mills <charl...@mcn.org>
> To: IBM-MAIN@LISTSERV.UA.EDU
> Date: 09/01/2015 08:03 AM
> Subject: FTP - how get RDW and ASCII
> Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU>
> 
> I have a legacy dataset in VB format. I would like to FTP it to a PC (1)
> translating the record data to ASCII and (2) preserving the LLBB record
> control words. (Don't need the block control words.) I tried the obvious
> ASCII and QUOTE SITE RDW but FTP has translated my RDWs to ASCII 
(rendering
> them useless of course). Does anyone have a clever trick to translate 
the
> "data" portion of the records to ASCII but preserve the LLBBs?
> 
> This is a one-time development chore, not a nightly production job. I'm 
not
> fussy about code pages and so forth. The dataset is small: 30 records, 
20K
> total.
> 
> One of you UNIX experts: should I just translate it to ASCII on z/OS 
first
> and then FTP it in binary with RDWs? Would someone be so kind as to 
share
> the command to do the translate? Again, the existing dataset is legacy 
MVS,
> and I need to preserve LLBBs.
> 
> Thanks,
> 
> Charles 
> 
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> 



--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: FTP - how get RDW and ASCII

[Charles Mills]

I just learned that!

Charles

-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On
Behalf Of Sri h Kolusu
Sent: Tuesday, September 01, 2015 8:47 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: FTP - how get RDW and ASCII

>>should I just translate it to ASCII on z/OS first and then FTP it in
binary with RDWs? Would someone be so kind as to share the command to do the
translate?
>>Years ago I wanted the same and I never found one nor wrote one. FTP's
EBCDIC <-> ASCII translation is for the entire logical record. You would
need a "field" level translation to get no translation for the length fields
and EBCDIC <-> ASCII translation for the text fields.

Charles/Don,

DFSORT has the capability of converting from EBCDIC to ASCII and vice-versa

TRAN=ETOA converts EBCDIC characters to ASCII characters TRAN=ATOE converts
ASCII characters to EBCDIC characters

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN