Re: SFTP question

[Paul Gilmartin]

On Thu, 1 Sep 2022 12:11:07 -0700, Tom Brennan wrote:
>
>...  But I tended to avoid using a 3270
>OMVS connection on USS ...
> 
So flattery gets me nowhere?

>I didn't know you could do that with streams across ssh - pretty
>interesting!
>
>On 9/1/2022 9:06 AM, Paul Gilmartin wrote:
>>>
>> How about:
>>  /bin/cp [options] "//'MVS.DATA.SET(MEMBER)'" | ssh -f Tom@Linux "cat 
>> >Linux.file"
>>
And I was wrong.  Perhaps:
/bin/cp [options] "//'MVS.DATA.SET(MEMBER)'" /dev/fd/1 |  # target for cp
iconv -f ISO8859-1 -t IBM-1047 |  # (optional) Undo EBCDIC->ASCII 
conversion.
sshTom@Linux "cat >Linux.file"  # "-f" is extraneous and harmful!

useful for copying directories and contents:
pax -w directory | ssh target "pax -r"  # or:
ssh source "pax -w" | pax -r

>> Or try  to get Purchasing to approve Co:Z.

-- 
gil

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

Re: SFTP question

[Kirk Wolf]

That works if the target server allows for ssh shell logins.   Many are 
restricted to only sftp, which means that neither ssh remote command or scp 
will work.

Kirk Wolf
Dovetailed Technologies, LLC
http://coztoolkit.com
Dovetailed Technologies: +1 636.300.0901

Note: Our website and domain name have changed from dovetail.com to 
coztoolkit.com


On Thu, Sep 1, 2022, at 11:06 AM, Paul Gilmartin wrote:
> On Thu, 1 Sep 2022 07:33:57 -0700, Tom Brennan wrote:
> >...
> >But like you say (and if nothing has changed over the years), you need
> >to setup keys.  
> >
> Ssh-keygen makes it easy.  The keys are stored as text files.  It ought
> to be possible to Copy from a Vista OMVS window and Paste to
> a Linux xterm ssh window.
> 
> >And sftp only worked with USS files so an OCOPY or
> >similar was needed for z/OS datasets, and some temp USS space.
> >
> How about:
> /bin/cp [options] "//'MVS.DATA.SET(MEMBER)'" | ssh -f Tom@Linux "cat 
> >Linux.file"
> 
> Unconditional IBM-1047 -> ISO8859-1 conversion.  If you want it not to do 
> that, insert
> an iconv filter on the z/OS end.
> 
> Or try  to get Purchasing to approve Co:Z.
> 
> -- 
> gil
> 
> --
> 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: SFTP question

[Tom Brennan]

Yes, it's easy to copy/paste a text key using a terminal emulator and 
then vi or whatever on the target.  But I tended to avoid using a 3270 
OMVS connection on USS and instead almost always connected to the 
mainframe using SSH.  So in my case that would have been a PuTTy to 
PuTTy copy/paste, using the vi editor.


More often I'd use scp because I was most likely creating a new 
authorized_keys file on the target machine anyway.  In addition, running 
scp from the mainframe would test the IP connection, test the target id, 
and also ask me if it's ok to copy the target's host key into the 
mainframe known_hosts file.  Skipping that last item can cause some head 
scratching when you try to run a batch sftp.


You're far more advanced than me when it comes to stringing unix 
commands together, so let me look closer:


cp - copy the z/OS member I want to transfer to the data stream.

ssh - receive that data stream and connect to Tom@Linux and then issue 
the cat command with > that will take that data stream and poke it in 
Linux.file.


I didn't know you could do that with streams across ssh - pretty 
interesting!


On 9/1/2022 9:06 AM, Paul Gilmartin wrote:

On Thu, 1 Sep 2022 07:33:57 -0700, Tom Brennan wrote:

...
But like you say (and if nothing has changed over the years), you need
to setup keys.


Ssh-keygen makes it easy.  The keys are stored as text files.  It ought
to be possible to Copy from a Vista OMVS window and Paste to
a Linux xterm ssh window.


And sftp only worked with USS files so an OCOPY or
similar was needed for z/OS datasets, and some temp USS space.


How about:
 /bin/cp [options] "//'MVS.DATA.SET(MEMBER)'" | ssh -f Tom@Linux "cat 
>Linux.file"

Unconditional IBM-1047 -> ISO8859-1 conversion.  If you want it not to do that, 
insert
an iconv filter on the z/OS end.

Or try  to get Purchasing to approve Co:Z.



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

Re: SFTP question

[Paul Gilmartin]

On Thu, 1 Sep 2022 07:33:57 -0700, Tom Brennan wrote:
>...
>But like you say (and if nothing has changed over the years), you need
>to setup keys.  
>
Ssh-keygen makes it easy.  The keys are stored as text files.  It ought
to be possible to Copy from a Vista OMVS window and Paste to
a Linux xterm ssh window.

>And sftp only worked with USS files so an OCOPY or
>similar was needed for z/OS datasets, and some temp USS space.
>
How about:
/bin/cp [options] "//'MVS.DATA.SET(MEMBER)'" | ssh -f Tom@Linux "cat 
>Linux.file"

Unconditional IBM-1047 -> ISO8859-1 conversion.  If you want it not to do that, 
insert
an iconv filter on the z/OS end.

Or try  to get Purchasing to approve Co:Z.

-- 
gil

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

Re: SFTP question

[Kirk Wolf]

Thanks for mentioning.
Here's an example:

//SFTPCONN EXEC PROC=SFTPPROC 
//SFTPIN DD *   
pwdsn="COZUSER.COZ.SAMPJCL(PW)" 
user=myuser
host=myhost 
lzopts="mode=text"
rdir="/app/data/"
rfile="remotefile.txt" 

. $script_dir/sftp_connect.sh  Nobody has mentioned Coz from https://coztoolkit.com
> 
> 
> 
> 
> Sent with Proton Mail secure email.
> 
> --- Original Message ---
> On Thursday, September 1st, 2022 at 10:33 AM, Tom Brennan 
>  wrote:
> 
> 
> > On 9/1/2022 12:05 AM, Paul Gilmartin wrote:
> > 
> > > Might be possible with either BPXPATCH or BPXWUNIX. Set up your
> > > public-private keypairs on z/OS with ssh-keygen and copy the
> > > public key to Linux.
> > 
> > 
> > Yes, that's what I used to do. Something like this:
> > 
> > //SFTP EXEC PGM=BPXBATCH,REGION=8M,
> > // PARM='SH sftp -b sftpcmds targetid@targetserver'
> > 
> > But like you say (and if nothing has changed over the years), you need
> > to setup keys. And sftp only worked with USS files so an OCOPY or
> > similar was needed for z/OS datasets, and some temp USS space.
> > 
> > And I used to use scp too, because it would do the EBCDIC/ASCII
> > conversion for me.
> > 
> > --
> > 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
> 

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

Re: SFTP question

[rpinion865]

Nobody has mentioned Coz from https://coztoolkit.com




Sent with Proton Mail secure email.

--- Original Message ---
On Thursday, September 1st, 2022 at 10:33 AM, Tom Brennan 
 wrote:


> On 9/1/2022 12:05 AM, Paul Gilmartin wrote:
> 
> > Might be possible with either BPXPATCH or BPXWUNIX. Set up your
> > public-private keypairs on z/OS with ssh-keygen and copy the
> > public key to Linux.
> 
> 
> Yes, that's what I used to do. Something like this:
> 
> //SFTP EXEC PGM=BPXBATCH,REGION=8M,
> // PARM='SH sftp -b sftpcmds targetid@targetserver'
> 
> But like you say (and if nothing has changed over the years), you need
> to setup keys. And sftp only worked with USS files so an OCOPY or
> similar was needed for z/OS datasets, and some temp USS space.
> 
> And I used to use scp too, because it would do the EBCDIC/ASCII
> conversion for me.
> 
> --
> 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: SFTP question

[Tom Brennan]

On 9/1/2022 12:05 AM, Paul Gilmartin wrote:


Might be possible with either BPXPATCH or BPXWUNIX.  Set up your
public-private keypairs on z/OS with ssh-keygen and copy the
public key to Linux.


Yes, that's what I used to do.  Something like this:

//SFTP EXEC PGM=BPXBATCH,REGION=8M,
// PARM='SH sftp -b sftpcmds targetid@targetserver'

But like you say (and if nothing has changed over the years), you need 
to setup keys.  And sftp only worked with USS files so an OCOPY or 
similar was needed for z/OS datasets, and some temp USS space.


And I used to use scp too, because it would do the EBCDIC/ASCII 
conversion for me.


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

Re: SFTP question

[kekronbekron]

Whoops, thanks for educating me.

- KB

--- Original Message ---
On Thursday, September 1st, 2022 at 6:25 PM, Paul Gilmartin 
<042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:


> On Thu, 1 Sep 2022 10:29:09 +, kekronbekron wrote:
> 
> > I recently came across zdsfs 
> > (https://www.ibm.com/docs/en/linux-on-systems?topic=c-zdsfs-2).
> 
> ITYM https://www.ibm.com/docs/en/linux-on-systems?topic=c-zdsfs-2.
> 
> > Just from a brief look, it appears to provide direct access to zOS disks.
> > Will help avoid transfers and duplicate data.
> > DSFS might well be the child of zdsfs, just from the name.
> 
> Doesn't appear that way from the restrictions:
> 
> Attention:
> To avoid data inconsistencies, set the DASDs offline in z/OS before you mount 
> them in Linux.
> Through the zdsfs file system, the whole DASDs are accessible to Linux, but 
> the access is not controlled by z/OS auditing mechanisms.
> To avoid security problems, you might want to dedicate the z/OS DASDs only 
> for providing data for Linux.
> 
> Also, consider NFS.
> 
> --
> gil
> 
> --
> 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: SFTP question

[Paul Gilmartin]

On Thu, 1 Sep 2022 10:29:09 +, kekronbekron wrote:
>
>I recently came across zdsfs 
>(https://www.ibm.com/docs/en/linux-on-systems?topic=c-zdsfs-2).
>
ITYM .

>Just from a brief look, it appears to provide direct access to zOS disks.
>Will help avoid transfers and duplicate data.
>DSFS might well be the child of zdsfs, just from the name.
>
Doesn't appear that way from the restrictions:

Attention:
To avoid data inconsistencies, set the DASDs offline in z/OS before you 
mount them in Linux.
Through the zdsfs file system, the whole DASDs are accessible to Linux, but 
the access is not controlled by z/OS auditing mechanisms.
To avoid security problems, you might want to dedicate the z/OS DASDs only 
for providing data for Linux.

Also, consider NFS.

-- 
gil

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

Re: SFTP question

[kekronbekron]

Hi,

I recently came across zdsfs 
(https://www.ibm.com/docs/en/linux-on-systems?topic=c-zdsfs-2).
Just from a brief look, it appears to provide direct access to zOS disks.
Will help avoid transfers and duplicate data.
DSFS might well be the child of zdsfs, just from the name.

- KB

--- Original Message ---
On Thursday, September 1st, 2022 at 12:35 PM, Paul Gilmartin 
<042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:


> On 8/31/22 23:45:20, Peter wrote:
> 
> > Cross posted
> 
> Which groups? IBM-MAIN and MVS-OE?
> 
> > I am trying to send dataset to a Linux server which has a SFTP running on
> > it. Is it possible to connect the Linux servers SFTP using mainframe JCL to
> > put or get the file from Linux ?
> 
> 
> Might be possible with either BPXPATCH or BPXWUNIX. Set up your
> public-private keypairs on z/OS with ssh-keygen and copy the
> public key to Linux.
> 
> Do you have ssh working? The protocols are similar.
> 
> EBCDIC intrudes. Use iconv on z/OS, not Linux.
> 
> --
> gil
> 
> --
> 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: SFTP question

[Paul Gilmartin]

On 8/31/22 23:45:20, Peter wrote:
> Cross posted
> 
Which groups?  IBM-MAIN and MVS-OE?

> I am trying to send dataset to a Linux server which has a SFTP running on
> it. Is it possible to connect the Linux servers SFTP using mainframe JCL to
> put or get the file from Linux ?

Might be possible with either BPXPATCH or BPXWUNIX.  Set up your
public-private keypairs on z/OS with ssh-keygen and copy the
public key to Linux.

Do you have ssh working?  The protocols are similar.

EBCDIC intrudes.  Use iconv on z/OS, not Linux.

-- 
gil

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

The fact that IBM bothered to do SysRexx suggests that they see value in it.

I've never found running ISPF in batch to be awkward.

Any large volume CPU-bound task is best implemented in a language that can be 
compiled to machine code; that includes languages with effective JIT 
compilation. So, yes, other languages are more suitable for that use case.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of Sri 
h Kolusu [skol...@us.ibm.com]
Sent: Wednesday, June 22, 2022 12:06 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

>> Mr. Natural says, Use the right tool for the job.

Gil,

I agree with the statement, however in this case rexx isn't the right tool.   
Here are a few reasons I can think off

1.  Most shops discourage the use of REXX in production jobs
2.  In this case the exec is simple , however if your exec needs ISPF services 
then running REXX in batch is a pain to set up.
3.  For smaller input rexx might be good, but it is a poor choice to process 
large volumes of data.


I for one prefer using the existing IBM utilities and there are utilities like 
DFSORT (of course I am biased towards it ) which does have plethora of Date 
arithmetic functions.

//STEP0100 EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD *
abc
//SORTOUT  DD SYSOUT=*
//SYSINDD *
  OPTION COPY
  INREC BUILD=(C'get NonMon_DailyExtract_KWT_',
   DATE1-1,
   C'.txt',
   80:X)
/*

Will produce  get NonMon_DailyExtract_KWT_20220621.txt

If you want the date with separators it is quite simple. Use DATE1(.)-1, and it 
will produce get NonMon_DailyExtract_KWT_2022.06.21.txt


Thanks,
Kolusu


--
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: SFTP JOB Data parameter

[Michael Oujesky]

One way, presuming the job runs once per day:
//SFTPB24E JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=,USER=STCSYS
//GETYEST  EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC
//OUTPUT   DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD DISP=OLD,DSN=MYHLQ.YESTFILE.CMD
//*/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\*
//BLDGET   IF RC=0 THEN
//BYEBYE   EXEC PGM=IEFBR14
//YESTFILE DD   DISP=(MOD,DELETE),DSN=MYHKQ.YESTFILE.CMD,
// UNIT=SYSALLDA,SPACE=(TRK,(0))
//**
//STEP0EXEC PGM=EZACFSM1
//SYSOUT   DD DSN=MYHLQ.YESTFILE.CMD,DISP=(NEW,CATLG),
// SPACE=(TRK,(1,0)),UNIT=SYSALLDA
//SYSINDD DATA,DLM=@@
OSHELL { echo 'lcd /u/op117/';  +
 echo 'cd /XX/Output/TMP';  +
 echo 'ASCII';  +
 echo 'get MDS_'; } |   +
 sftp -P  eftmfge...@10.222.xx.yy
 oget '/u/op117/MDS_' -
  'MCCP.DATA.XX.MDS.SFTP'
@@
//BLDGET ENDIF
Seed it by running the BLDGET steps the day before regular runs begin.

Michael



At 01:58 AM 6/23/2022, saurabh khandelwal wrote:


Dear Team,



Thanks for reply and helping me to resolve this issue.



1)  Mainframe is getting file from windows. So, few of the files in
windows having today’s date and few of them having yesterday’s date( today
-1) .

2)  For today’s date below code is the solution you all suggested and
worked out.



//SFTPB24E JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=,USER=STCSYS
//STEP0EXEC PGM=EZACFSM1
//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0)),UNIT=VIO
//SYSINDD DATA,DLM=@@
OSHELL { echo 'lcd /u/op117/';  +
 echo 'cd /XX/Output/TMP';  +
 echo 'ASCII';  +
 echo 'get MDS_'; } |   +
 sftp -P  eftmfge...@10.222.xx.yy
 oget '/u/op117/MDS_' -
  'MCCP.DATA.XX.MDS.SFTP'
@@
//STEP1EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC
//OUTPUT   DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD DISP=(OLD,PASS),DSN=&

3)  Now, to get the file into Mainframe using SFTP and oshell with
yesterday’s date is the step we failing. So, can you please help me to
change this code mentioned above to get yesterday’s file.

Thank you so much once again for help.


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

Re: SFTP JOB Data parameter

[saurabh khandelwal]

Hello, Paul,

I, could not get you . Can you please help us to understand what exactly
you are looking

On Thu, Jun 23, 2022, 13:33 Paul Gilmartin <
042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:

> On Thu, 23 Jun 2022 09:58:30 +0300, saurabh khandelwal  wrote:
> >
> >1)  Mainframe is getting file from windows. So, few of the files in
> >windows having today’s date and few of them having yesterday’s date(
> today-1) .
> >
> So there are multiple files ("few").  Do you know a priori which have
> today's
> date and which have yesterday’s date?
>
> -- gil
>
> --
> 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: SFTP JOB Data parameter

[Paul Gilmartin]

On Thu, 23 Jun 2022 09:58:30 +0300, saurabh khandelwal  wrote:
>
>1)  Mainframe is getting file from windows. So, few of the files in
>windows having today’s date and few of them having yesterday’s date( today-1) .
> 
So there are multiple files ("few").  Do you know a priori which have today's
date and which have yesterday’s date?

-- gil

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

Re: SFTP JOB Data parameter

[saurabh khandelwal]

Dear Team,



Thanks for reply and helping me to resolve this issue.



1)  Mainframe is getting file from windows. So, few of the files in
windows having today’s date and few of them having yesterday’s date( today
-1) .

2)  For today’s date below code is the solution you all suggested and
worked out.



//SFTPB24E JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=,USER=STCSYS

//STEP0EXEC PGM=EZACFSM1

//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0)),UNIT=VIO

//SYSINDD DATA,DLM=@@

OSHELL { echo 'lcd /u/op117/';  +

 echo 'cd /XX/Output/TMP';  +

 echo 'ASCII';  +

 echo 'get MDS_'; } |   +

 sftp -P  eftmfge...@10.222.xx.yy

 oget '/u/op117/MDS_' -

  'MCCP.DATA.XX.MDS.SFTP'

@@

//STEP1EXEC PGM=IKJEFT01,REGION=0M

//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC

//OUTPUT   DD SYSOUT=*

//SYSTSPRT DD SYSOUT=*

//SYSTSIN  DD DISP=(OLD,PASS),DSN=&



3)  Now, to get the file into Mainframe using SFTP and oshell with
yesterday’s date is the step we failing. So, can you please help me to
change this code mentioned above to get yesterday’s file.



Thank you so much once again for help.

On Thu, Jun 23, 2022, 01:25 Farley, Peter x23353 <
031df298a9da-dmarc-requ...@listserv.ua.edu> wrote:

> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Paul Gilmartin
> Sent: Wednesday, June 22, 2022 12:29 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: SFTP JOB Data parameter
>
> On Wed, 22 Jun 2022 16:06:06 +, Sri h Kolusu wrote:
>
> 
> > > I for one prefer using the existing IBM utilities and there are
> utilities like DFSORT (of course I am biased towards it ) which does have
> plethora of Date arithmetic functions.
> >  I never mastered the syntax of DFSORT commands.
>
> IMHO SORT control syntax and usage are valuable and useful skills for any
> mainframe programmer to have.  One should make the effort to learn them if
> one can find the time; they make seemingly hard jobs far easier.  Start
> with small jobs and work your way up.
>
> I am still learning about SORT capabilities, though I have at least
> partially mastered using JOINKEYS (with the kind help of the esteemed Mr.
> Kolusu) to perform large matching and selecting operations I could not have
> easily solved otherwise.
>
> Not a master of that universe yet, only a journeyman at most.
>
> I'll match my awk skills against anyone's, but even there I am sure I have
> things to learn.
>
> The fun of learning new things is what makes each day easier to get
> through.
>
> Peter
> --
>
>
> This message and any attachments are intended only for the use of the
> addressee and may contain information that is privileged and confidential.
> If the reader of the message is not the intended recipient or an authorized
> representative of the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by
> e-mail and delete the message and any attachments from your system.
>
>
> --
> 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: SFTP JOB Data parameter

[Farley, Peter x23353]

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Paul Gilmartin
Sent: Wednesday, June 22, 2022 12:29 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

On Wed, 22 Jun 2022 16:06:06 +, Sri h Kolusu wrote:


> > I for one prefer using the existing IBM utilities and there are utilities 
> > like DFSORT (of course I am biased towards it ) which does have plethora of 
> > Date arithmetic functions.
>  I never mastered the syntax of DFSORT commands.

IMHO SORT control syntax and usage are valuable and useful skills for any 
mainframe programmer to have.  One should make the effort to learn them if one 
can find the time; they make seemingly hard jobs far easier.  Start with small 
jobs and work your way up.

I am still learning about SORT capabilities, though I have at least partially 
mastered using JOINKEYS (with the kind help of the esteemed Mr. Kolusu) to 
perform large matching and selecting operations I could not have easily solved 
otherwise.

Not a master of that universe yet, only a journeyman at most.

I'll match my awk skills against anyone's, but even there I am sure I have 
things to learn.

The fun of learning new things is what makes each day easier to get through.

Peter
--


This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.


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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 22 Jun 2022 12:45:56 -0500, Michael Oujesky wrote:

>Might you have the job log from one that had yesterday's data?
>  
And that requires a couple more steps:

One to access that log.

A second to convert it to SFTP and OGET commands  This might bee:
o "sed" which I know fairly well.
o ISPF (which is a pain to use in batch) plus a macro, written perhaps in
  COBOL since most shops discourage use of Rexx in production.
o Pure Rexx (but see above).
o I suspect DFSORT could do it.  I'm DFSORT-naive, but I understand it
  has a wide repertoire of facilities.

>In processes I have built, I did the job build  "today", but
>submitted the job stream "tomorrow" or used a timer facility to delay
>start of execution until "tomorrow" (or days/weeks later).


>At 08:00 AM 6/22/2022, saurabh khandelwal wrote:
>>...
>>echo 'get NonMon_DailyExtract_KWT_'; } | +
>>  sftp -P  eftm...@10.222.xx.xx
>>oget '/u/op117/NonMon_DailyExtract_KWT_'-
>>  'NBFDP.XX.SECURE.DOBMOB.XX.SFTP'

-- 
gil

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

Re: SFTP JOB Data parameter

[Michael Oujesky]

Might you have the job log from one that had yesterday's data?

In processes I have built, I did the job build  "today", but 
submitted the job stream "tomorrow" or used a timer facility to delay 
start of execution until "tomorrow" (or days/weeks later).


Michael

At 08:00 AM 6/22/2022, saurabh khandelwal wrote:


Dear All,

Thanks you so much. Finally below code worked. But in this, we are getting
current (today's date) but in some of the files, we are getting yesterday's
date (today's -1) .

How can we make this process work for yesterday's date.

But in this, we are able to retrieve

//SFTPDOBM JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=,USER=STCSYS
//STEP0EXEC PGM=EZACFSM1
//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0)),UNIT=VIO
//SYSINDD DATA,DLM=@@
OSHELL { echo 'lcd /u/op117/';  +
  echo 'cd /3DSecure/KWT/TMP';  +
 echo 'ASCII';  +
echo 'get NonMon_DailyExtract_KWT_'; } | +
 sftp -P  eftm...@10.222.xx.xx
oget '/u/op117/NonMon_DailyExtract_KWT_'-
 'NBFDP.XX.SECURE.DOBMOB.XX.SFTP'
@@
//STEP1EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC
//OUTPUT   DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD DISP=(OLD,PASS),DSN=&


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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 22 Jun 2022 16:06:06 +, Sri h Kolusu wrote:

>>> Mr. Natural says, Use the right tool for the job.
>
>Gil,
>
>I agree with the statement, however in this case rexx isn't the right tool.   
>Here are a few reasons I can think off
>
>1.  Most shops discourage the use of REXX in production jobs
>
Cite.  Does IBM itself not distribute production utilities in Rexx?  Do those
same shops encourage the use of TSO in production jobs?
There's probably a COBOL solution.

>2.  In this case the exec is simple , however if your exec needs ISPF services 
>then running REXX in batch is a pain to set up.
>
But "this case" is the OP's requirement.  I've run ISPF in batch.  Most of the 
pain
was eased by copying and modifying a PROCLIB member.

>3.  For smaller input rexx might be good, but it is a poor choice to process 
>large volumes of data.
>
Irrelevant for the OP's dozen or so records.  This is reminiscent of the recent 
dispute here
about optimizing storatge for a small data set.

>I for one prefer using the existing IBM utilities and there are utilities like 
>DFSORT (of course I am biased towards it ) which does have plethora of Date 
>arithmetic functions.
> 
I never mastered the syntax of DFSORT commands.

-- 
gil

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

Re: SFTP JOB Data parameter

[Sri h Kolusu]

>> Mr. Natural says, Use the right tool for the job.

Gil,

I agree with the statement, however in this case rexx isn't the right tool.   
Here are a few reasons I can think off

1.  Most shops discourage the use of REXX in production jobs
2.  In this case the exec is simple , however if your exec needs ISPF services 
then running REXX in batch is a pain to set up.
3.  For smaller input rexx might be good, but it is a poor choice to process 
large volumes of data.


I for one prefer using the existing IBM utilities and there are utilities like 
DFSORT (of course I am biased towards it ) which does have plethora of Date 
arithmetic functions.

//STEP0100 EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD *
abc
//SORTOUT  DD SYSOUT=*
//SYSINDD *
  OPTION COPY
  INREC BUILD=(C'get NonMon_DailyExtract_KWT_',
   DATE1-1,
   C'.txt',
   80:X)
/*

Will produce  get NonMon_DailyExtract_KWT_20220621.txt

If you want the date with separators it is quite simple. Use DATE1(.)-1, and it 
will produce get NonMon_DailyExtract_KWT_2022.06.21.txt


Thanks,
Kolusu


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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 22 Jun 2022 16:00:38 +0300, saurabh khandelwal wrote:
>
>Thanks you so much. Finally below code worked. But in this, we are getting
>current (today’s date) but in some of the files, we are getting yesterday’s
>date (today’s -1) .
>
>How can we make this process work for yesterday’s date.
> 
A Rexx approach for "yesterday’s date":
12 *-* B = date( 'Base' )
   >=>   "738327"
13 *-* B = date( 'Standard', B-1, 'Base' )
   >V>   "738327"
   >=>   "20220621"
14 *-* B = translate( 'cd.ef.gh', B, 'abcdefgh' )
   >V>   "20220621"
   >=>   "22.06.21"
15 *-* call lineout , 'get NonMon_DailyExtract_KWT_'||B'.txt'
   >V>   "22.06.21"
get NonMon_DailyExtract_KWT_22.06.21.txt

-- 
Mr. Natural says, Use the right tool for the job.
gil

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 22 Jun 2022 14:53:22 +, Sri h Kolusu wrote:

>>> Thanks you so much. Finally below code worked. But in this, we are getting 
>>> current (today’s date) but in some of the files, we are getting yesterday’s 
>>> date (today’s -1) .
>
>Saurabh,
>
>The date and time are extracted from the system where the job runs.  Are you 
>telling that 2 jobs running on the SAME system are getting different dates ? 
>One job getting current date and other getting yesterday's date?  That is 
>nearly impossible unless 1 job ran after midnight and the other ran on 
>previous day.
> 
At the beginning of this long thread, he said the file is created by Windows
and fetched by TSO.

>Do you need Current date or yesterday's date?
>
"some of the files" needs to be clarified.

-- 
gil

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

Re: SFTP JOB Data parameter

[Sri h Kolusu]

>> Thanks you so much. Finally below code worked. But in this, we are getting 
>> current (today’s date) but in some of the files, we are getting yesterday’s 
>> date (today’s -1) .

Saurabh,

The date and time are extracted from the system where the job runs.  Are you 
telling that 2 jobs running on the SAME system are getting different dates ? 
One job getting current date and other getting yesterday's date?  That is 
nearly impossible unless 1 job ran after midnight and the other ran on previous 
day.

Do you need Current date or yesterday's date?

Thanks,
Kolusu

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 22 Jun 2022 16:00:38 +0300, saurabh khandelwal  wrote:
>
>... in some of the files, we are getting yesterday’s date (today’s -1) .
>
Is that because the Windows files are generated before midnight but
the TSO job runs after midnight?

That's a process problem; it can't be fixed in code.

You might be able to fudge the timezone:

533 $ TZ=XyZ11  date '+get NonMon_DailyExtract_KWT_%Y.%m.%d.txt'
get NonMon_DailyExtract_KWT_2022.06.22.txt

534 $ TZ=XyZ-13 date '+get NonMon_DailyExtract_KWT_%Y.%m.%d.txt'
get NonMon_DailyExtract_KWT_2022.06.23.txt

... But it's better to fix the process.

-- 
gil

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

Re: SFTP JOB Data parameter

[saurabh khandelwal]

Dear All,



Thanks you so much. Finally below code worked. But in this, we are getting
current (today’s date) but in some of the files, we are getting yesterday’s
date (today’s -1) .



How can we make this process work for yesterday’s date.







But in this, we are able to retrieve

//SFTPDOBM JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=,USER=STCSYS

//STEP0EXEC PGM=EZACFSM1

//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0)),UNIT=VIO

//SYSINDD DATA,DLM=@@

OSHELL { echo 'lcd /u/op117/';  +

  echo 'cd /3DSecure/KWT/TMP';  +

 echo 'ASCII';  +

echo 'get NonMon_DailyExtract_KWT_'; } | +

 sftp -P  eftm...@10.222.xx.xx

oget '/u/op117/NonMon_DailyExtract_KWT_'-

 'NBFDP.XX.SECURE.DOBMOB.XX.SFTP'

@@

//STEP1EXEC PGM=IKJEFT01,REGION=0M

//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC

//OUTPUT   DD SYSOUT=*

//SYSTSPRT DD SYSOUT=*

//SYSTSIN  DD DISP=(OLD,PASS),DSN=&

On Fri, Jun 17, 2022, 17:56 Bill Godfrey  wrote:

> The OP's input to sftp has "lcd /u/op117/"
> and later "get EBC-GOV-mmdd.txt".
> If the "get" command had slashes inside mmdd
> then it would look like this: "get EBC-GOV-/mm/dd.txt"
> and sftp would write a file named "/u/op117/dd.txt" if it found the file,
> and the OGET '/u/op117/EBC-GOV-mmdd.txt' command would not find the
> file that sftp wrote.
>
> I cannot read his mind, but I think the OP did not mean the slashes
> literally when he said
> "in this mmdd should be replace with year/month/date".
> The logic makes more sense if slashes are left out when the date is
> substituted.
>
> On Fri, 17 Jun 2022 07:14:16 -0500, John S. Giltner, Jr. wrote:
>
> >>Not quite, but:
> >>date '+get EBC-GOV-%Y/%m/%d.txt'
> >>
> >> o Why bother with "echo" of a command substitution?
> >> o IIRC, the OP specified slashes. (?!)
> >>Ex : EBC-GOV-mmdd.txt'   in this mmdd should be
> >>replace with
> >> year/month/date.
> >
> >My fault, did not read the whole thing.  I just saw mmdd as went with
> that, missed that it needed the "/" in there.
>
> --
> 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: SFTP JOB Data parameter

[Bill Godfrey]

The OP's input to sftp has "lcd /u/op117/"
and later "get EBC-GOV-mmdd.txt".
If the "get" command had slashes inside mmdd
then it would look like this: "get EBC-GOV-/mm/dd.txt"
and sftp would write a file named "/u/op117/dd.txt" if it found the file,
and the OGET '/u/op117/EBC-GOV-mmdd.txt' command would not find the file 
that sftp wrote.

I cannot read his mind, but I think the OP did not mean the slashes literally 
when he said
"in this mmdd should be replace with year/month/date".
The logic makes more sense if slashes are left out when the date is substituted.

On Fri, 17 Jun 2022 07:14:16 -0500, John S. Giltner, Jr. wrote:

>>Not quite, but:
>>date '+get EBC-GOV-%Y/%m/%d.txt'
>>
>> o Why bother with "echo" of a command substitution?
>> o IIRC, the OP specified slashes. (?!)
>>Ex : EBC-GOV-mmdd.txt'   in this mmdd should be
>>replace with
>> year/month/date.
>
>My fault, did not read the whole thing.  I just saw mmdd as went with 
>that, missed that it needed the "/" in there.

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

Re: SFTP JOB Data parameter

[John S. Giltner, Jr.]

>Not quite, but:
>date '+get EBC-GOV-%Y/%m/%d.txt'
>
> o Why bother with "echo" of a command substitution?
> o IIRC, the OP specified slashes. (?!)
>Ex : EBC-GOV-mmdd.txt'   in this mmdd should be
>replace with
> year/month/date.

My fault, did not read the whole thing.  I just saw mmdd as went with that, 
missed that it needed the "/" in there.

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Fri, 17 Jun 2022 06:35:27 -0500, John S. Giltner, Jr.  wrote:

>Actually I think he needs:
>
>  echo `date '+get EBC-GOV-%Y%m%d.txt'`
>
>To get the format of the date he needs.
>
Not quite, but:
date '+get EBC-GOV-%Y/%m/%d.txt'

o Why bother with "echo" of a command substitution?
o IIRC, the OP specified slashes. (?!)
Ex : EBC-GOV-mmdd.txt'   in this mmdd should be
replace with
year/month/date.

-- 
gil

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

Re: SFTP JOB Data parameter

[John S. Giltner, Jr.]

Actually I think he needs:

  echo `date '+get EBC-GOV-%Y%m%d.txt'`

To get the format of the date he needs.

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

It's the installation management that sets and enforces policy. The rules of 
the installation trump the desires of the submitter, and IBM provides tools to 
enforce those rules. If the installation wishes to delegate the decision to the 
submitter, that is easy to do.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Paul Gilmartin [042bfe9c879d-dmarc-requ...@listserv.ua.edu]
Sent: Thursday, June 16, 2022 12:10 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

On Thu, 16 Jun 2022 14:50:18 +, Seymour J Metz  wrote:

>Only from the perspective of the submitter, not from the perspective of the 
>installation.
>
Which of my two paragraphs are you addrressinig?

In either case, the submitter is the one who cares.

Since (I believe) the system symbol facility antedates the
JCL SET statement, the rule should have been that system
symbols be honored unconditionally in SET with no
compatibility impact.  The programmer could then have used:
// SET jcl-symbol=''
and used  freely subsequently.

>From: Paul Gilmartin
>Sent: Thursday, June 16, 2022 9:27 AM
>
>Doesn't SYMBOLS=({JCLONLY|EXECSYS|CNVTSYS} suffice to resolve that?
>
>There remains the phobia concerning the antiquated use of "&" in temp DSNs.

--
gil

--
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: SFTP JOB Data parameter

[Paul Gilmartin]

On Thu, 16 Jun 2022 14:47:00 +, Seymour J Metz wrote:

>Read up on syscalls('ON'), address syscall and address sh.
>
syscalls('ON') can be used in any environment; address sh
requires that the Rexx script have been started from shell amd
is not enabled by syscalls('ON').

I suspect the rationale is that sh requires descriptors 0, 1, and 2.

-- 
gil

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Thu, 16 Jun 2022 14:50:18 +, Seymour J Metz  wrote:

>Only from the perspective of the submitter, not from the perspective of the 
>installation.
> 
Which of my two paragraphs are you addrressinig?

In either case, the submitter is the one who cares.

Since (I believe) the system symbol facility antedates the
JCL SET statement, the rule should have been that system
symbols be honored unconditionally in SET with no
compatibility impact.  The programmer could then have used:
// SET jcl-symbol=''
and used  freely subsequently.

>From: Paul Gilmartin
>Sent: Thursday, June 16, 2022 9:27 AM
>
>Doesn't SYMBOLS=({JCLONLY|EXECSYS|CNVTSYS} suffice to resolve that?
>
>There remains the phobia concerning the antiquated use of "&" in temp DSNs.

-- 
gil

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

Not at all; it's more a case of each poster offering the first solution they 
thought of, which IMHO is appropriate. It's up to the OP to decide which best 
suits his needs.

TMTOWTDI.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Kirk Wolf [k...@dovetail.com]
Sent: Thursday, June 16, 2022 11:13 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

IMO, the contortions in this thread seem to be in search of the most 
complicated solution.
By just using the z/OS UNIX shell in batch, the OP's requirement can be solved 
in a straightforward way.

FWIW, here's how you would do this with Co:Z SFTP and Co:Z Batch, along with 
our sample proc and scripts:

//SFTP EXEC PROC=SFTPPROC  Co:Z SFTP sample proc
//SFTPIN DD *
# This is a z/OS UNIX shell script
# See: 
https://secure-web.cisco.com/1e6tC2pGX9jdX0qpKt1U23CTm05DB7zgn0yrIv3eLICZnPeDHU6w2OfcTld3dgibijWObPkUK_aDzwMTi6GBGtGCvBhkLUIFo_6igWx6NnrGfCHzZKmSFqorjXQeYkJfeFPd3debyxFL-YqlI-iCvXjw7NZUWphRl8vjxQ8GZM3hw70HgtDwSE-Szh3KuTmJ12lmy5adS7H8m6O5ZOtmbt-ukQIPfzfKwbfnAE3iwdNxE8r6WQ0Dr8RklgsmGbdSW27QVHRj412EdXFEMwqzkK9xyNaL6nfGU3gIZIbX-ABgFNW5NkrX0rUPtzelwnBw2CX0zYbxYsD8URhVIhYyKw3B-Cy22l2BhzSLAoPt2wWQzZ1pNq7-qGPgl1wtBV0yQgs5njH8MNN22dNEjXdUWJnSWfQCKfie-BAVE8RFSGBnPUv4R76_GbvEfzawH1ZXw/https%3A%2F%2Fdovetail.com%2Fdocs%2Fsftp%2Fclient.html%23client-batch
#
user=EFTMFGET01
host=10.222.xx.xx
port=
rfile="EBC-GOV-$(sysvar LYYMMDD).txt"

. $script_dir/sftp_connect.sh <http://secure-web.cisco.com/1J3oUu7eT-I8RDyzyGqWhD8Ld7K_gqC5-wv-3NUeJZIzyltFG8AGC6lz6EnA70nmFVCXL0q70QMm3wIEqRUgoiHtk-kFfAaKZ-5yDcam2mrgdw8O1cDCMxUN2fQunj2gh6s8FujHxr_3LfmVngSrr6qQwV3citD8ARj511_3Gx8bj6rL5EaLKUEHGBfOfEjdAVCn3qnBe3u5G1kESm87ZUH3eHv3d_4r_wi_Uvc7mJiX71MZeShkSxeLJ0WQVfp4w-fGTM8_Io4jIcSsQ6DkUdpPMZ9nvvM4vA7W9tSj-sA-bwK5m1mXtCOV1JTnweEPuaoYxIXYGG95eNq--EyDjc4Pn-my9rAFPmY4dw_d3dw2qWW7vbGYedP5J8zFgo6gbMHtIQTqUw6FHZegw65tPEJaMyjZma6a1P3muVI3A8UH1F7Edf-5zd3fpZ-tsbJCE/http%3A%2F%2Fdovetail.com

Co:Z is free to use under the terms of our Community License
http://secure-web.cisco.com/14bwzQ0IYJjdkPGw3LKoFgBWJEmim7drcU4VSzSYaX6mJQ1vV7IHAZdYr6GfCIsoy665KyZXr-dXfRbBCo1-L0I3D-DQO4EjLOc2CbQQtZekIWsmXK-JIIhNm8FTrpO9GWL9ildJTrxcuve0Txvs4sz-96OeSfy_ikTKoba4dXndjqAqBPiEnXczqN_ddWlbmN4ToWE2u7fx06sux80uU8w-wmV1RU_NJoaRtEcImH5Yd-IrL3xK7qyew6le2Xqh5ttelvGpQxu2yboNrh1VUxJir8hhsQh8DE970Ie4QSy1aK3H5iAnk35TtESgItTFnuTfNthNeJBT9fUKu6d6lXbyBTNDMtdzC54V__eYKzt9wiYRvAEu1MHkLYRUpFl3kVKoeecdznuIIurwHll972ZU-YSlsEgBTHrJ1-H5wgtf7q8hfi5I9XAchmIkYBcge/http%3A%2F%2Fdovetail.com%2Fsupport.html



--
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: SFTP JOB Data parameter

[Kirk Wolf]

IMO, the contortions in this thread seem to be in search of the most 
complicated solution.
By just using the z/OS UNIX shell in batch, the OP's requirement can be solved 
in a straightforward way.

FWIW, here's how you would do this with Co:Z SFTP and Co:Z Batch, along with 
our sample proc and scripts:

//SFTP EXEC PROC=SFTPPROC  Co:Z SFTP sample proc
//SFTPIN DD *
# This is a z/OS UNIX shell script
# See: https://dovetail.com/docs/sftp/client.html#client-batch
#
user=EFTMFGET01
host=10.222.xx.xx
port=
rfile="EBC-GOV-$(sysvar LYYMMDD).txt"
   
. $script_dir/sftp_connect.sh 

Re: SFTP JOB Data parameter

[Seymour J Metz]

Only from the perspective of the submitter, not from the perspective of the 
installation.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Paul Gilmartin [042bfe9c879d-dmarc-requ...@listserv.ua.edu]
Sent: Thursday, June 16, 2022 9:27 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

On Thu, 16 Jun 2022 13:09:53 +, Seymour J Metz wrote:

>This has been discussed here many times. The issue is that the results vary 
>depending on ehrn and where you evaluate them.
>
Doesn't SYMBOLS=({JCLONLY|EXECSYS|CNVTSYS} suffice to resolve that?

There remains the phobia concerning the antiquated use of "&" in temp DSNs.

--
gil

--
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: SFTP JOB Data parameter

[Seymour J Metz]

Read up on syscalls('ON'), address syscall and address sh.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
saurabh khandelwal [sourabhkhandelwal...@gmail.com]
Sent: Wednesday, June 15, 2022 11:31 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

Hello Paul,

If I use rexx then how will I be able to use shell command in same job

On Wed, Jun 15, 2022, 17:08 Paul Gilmartin <
042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:

> On Wed, 15 Jun 2022 13:11:05 +, Seymour J Metz  wrote:
>
> >Write a REXX script to do the file transfer. You can use the date('S')
> function to generate the date in the format mmdd, then parse out the
> component to build your dsn.
> >
> I would have done something similar.  But the OP was on a promising track,
> however circuitous, even reporting a partial success.  Let's not deflect
> him.
>
> --
> gil
>
> --
> 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

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

The issue is when and where to evaluate.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Farley, Peter x23353 [031df298a9da-dmarc-requ...@listserv.ua.edu]
Sent: Wednesday, June 15, 2022 1:26 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

Thanks Sri, I did not know about SYSSYM=ALLOW.  But that raises the question 
why NOT always allow system symbols in every batch initiator?  Allowing them 
just seems like a no-brainer to me, but then I'm just an application programmer 
who expects to be able to use all of the available tools to get the job done.

Peter

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Sri 
h Kolusu
Sent: Wednesday, June 15, 2022 1:15 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

>> Why is EZACFSM1 required to use  in an instream DD?  Couldn't the OP 
>> just use:

Peter,

Not all shops SYSSYM=ALLOW defined. So if your jobclass is NOT defined to allow 
symbols, the symbols will not be translated.  However with program EZACFSM1 
will translate all the symbols defined to the system.


Thanks,
Kolusu
--

This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.

--
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: SFTP JOB Data parameter

[Steve Smith]

I wish that IBM had (or would) support the SYMBOLS= keyword on JOB
statements to allow system symbols in the JCL.  The current jobclass spec
would still be the default; and SYMBOLS=JCLONLY would still be the default
default.

sas

On Thu, Jun 16, 2022 at 9:27 AM Paul Gilmartin <
042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:

> On Thu, 16 Jun 2022 13:09:53 +, Seymour J Metz wrote:
>
> >This has been discussed here many times. The issue is that the results
> vary depending on ehrn and where you evaluate them.
> >
> Doesn't SYMBOLS=({JCLONLY|EXECSYS|CNVTSYS} suffice to resolve that?
>
> There remains the phobia concerning the antiquated use of "&" in temp DSNs.
>
> --
> gil
>
>

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Thu, 16 Jun 2022 13:09:53 +, Seymour J Metz wrote:

>This has been discussed here many times. The issue is that the results vary 
>depending on ehrn and where you evaluate them.
> 
Doesn't SYMBOLS=({JCLONLY|EXECSYS|CNVTSYS} suffice to resolve that?

There remains the phobia concerning the antiquated use of "&" in temp DSNs.

-- 
gil

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

This has been discussed here many times. The issue is that the results vary 
depending on ehrn and where you evaluate them.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Paul Gilmartin [042bfe9c879d-dmarc-requ...@listserv.ua.edu]
Sent: Thursday, June 16, 2022 8:27 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

On Wed, 15 Jun 2022 17:26:32 +, Farley, Peter x23353  wrote:

>Thanks Sri, I did not know about SYSSYM=ALLOW.  But that raises the question 
>why NOT always allow system symbols in every batch initiator?  Allowing them 
>just seems like a no-brainer to me, but then I'm just an application 
>programmer who expects to be able to use all of the available tools to get the 
>job done.
>
Do thoughtless admins keep sensitive information such as
passwords in system symbols?

Is there a performance concern?

--
gil

--
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: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 15 Jun 2022 18:31:04 +0300, saurabh khandelwal  wrote:
>
>If I use rexx then how will I be able to use shell command in same job
> 
In this thread, everyone seems to be advocating his favorite utility.
I'll add mine: .
BPXWUNIX is a very flexible tool for issuing UNIX commands from
Rexx in any environment, TSO, IRXJCLL, or OMVS.

You can use the Rexx date() to build the "get" command.

You can then copy the retrieved file elsewhere in the same script.

I never mastered OGET.  IEBGENER suffices for me and does not
impose a requirement of TSO.

One word of caution:  Be sure that your Windows and z/OS are
set to the same timezone (both Windows and z/OS are notoriously
bad at handling timezones), and that your batch job runs on the
same day the file was created.

-- 
gil

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 15 Jun 2022 17:26:32 +, Farley, Peter x23353  wrote:

>Thanks Sri, I did not know about SYSSYM=ALLOW.  But that raises the question 
>why NOT always allow system symbols in every batch initiator?  Allowing them 
>just seems like a no-brainer to me, but then I'm just an application 
>programmer who expects to be able to use all of the available tools to get the 
>job done.
> 
Do thoughtless admins keep sensitive information such as
passwords in system symbols?

Is there a performance concern?

-- 
gil

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

Re: SFTP JOB Data parameter

[Bill Godfrey]

My mistake about OGET, it does have the "-".

On Thu, 16 Jun 2022 00:15:23 -0500, Bill Godfrey wrote:

>Your first "echo" doesn't have a "+" at the end like your original did.
>
>Your "OGET" doesn't have a "-" at the end like your original did.
>
>The  symbol generates a 2-digit year, but your filenames use a 4-digit 
>year.
>Instead of  use 
>
>On Thu, 16 Jun 2022 07:45:53 +0300, saurabh khandelwal wrote:
>
>>
>>Now I am getting below error, while running this JCL code.
>>
>>
>>
>>JCL
>>
>>
>>
>>//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
>>
>>//TAILOR  EXEC PGM=PGM=EZACFSM1
>>
>>//SYSOUT   DD   DISP=(NEW,PASS,DELETE),DSN=,
>>
>>// UNIT=VIO,SPACE=(TRK,(1))
>>
>>//SYSINDD *
>>
>>OSHELL { echo 'lcd /u/op117/';
>>
>>  echo 'cd /FRB/EBCClearing/Staging/tmp';+
>>
>>  echo 'ASCII'; +
>>
>>  echo 'get EBC-GOV-'; } | +
>>
>>sftp -P  eftmfge...@10.222.xx.xx
>>
>>OGET '/u/op117/EBC-GOV-'  -
>>
>>  'NBFDP.DATA.XX.XX.SFTP'
>>
>>//STEP1   EXEC PGM=IKJEFT01,REGION=0M
>>
>>//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
>>
>>//SYSTSIN   DD DSN=,DISP=(OLD,DELETE)
>>
>>//OUTPUT DD SYSOUT=*
>>
>>//SYSTSPRT DD SYSOUT=*
>>
>>/*
>>
>>
>>
>>Output below :
>>
>>
>>
>>READY
>>
>>OSHELL { echo 'lcd
>>/u/op117/';
>>
>> OSHELL RC =  256
>>
>>
>>
>>
>> OSHELL Exit Status =
>>1
>>
>>
>>
>>READY
>>
>>  echo 'cd /FRB/EBCClearing/Staging/tmp';  echo 'ASCII'; echo 'get
>>EBC
>>
>>.22.10
>>
>>COMMAND ECHO NOT
>>FOUND
>>
>>READY
>>
>>OGET '/u/op117/EBC-GOV-220616.txt'
>>'NBFDP.DATA.XX.
>>
>>RETURN CODE 0081, REASON CODE 05620062.  AN ERROR OCCURRED DURING THE
>>OPENIN
>>
>>READY
>>
>>END
>>
>>
>>
>>
>>
>>FSUM7332 syntax error: got EOF, expecting }
>>
>>On Wed, Jun 15, 2022, 21:45 Farley, Peter x23353 <
>>031df298a9da-dmarc-requ...@listserv.ua.edu> wrote:
>>
>>> Thanks again Sri.  After reading those posts, I do see the issue.  That
>>> would be the "Don't break existing jobs" mantra.
>>>
>>> I would instead have said "Go ahead and break them in QA so we can fix the
>>> broken ones", but I don't pay the bills and "breaking them in QA" AssUMes
>>> that QA batch initiator classes are distinct from Production batch
>>> initiator classes, which isn't true at any large shop where I have worked.
>>>
>>> But I agree with Gil's final post in that thread - it should have been
>>> implemented as a new JCL option (similar to EXPORT SYMLIST) rather than an
>>> initiator class parameter.  Positive opt-in for jobs that want to use it,
>>> leave the others alone.  Perhaps a global parameter for the JCL interpreter
>>> to allow or disallow the new JCL option during the initial transition so
>>> shops could choose to allow or disallow use of the new JCL option to
>>> prevent accidental breakage by too-eager programmers until automated SDLC
>>> rules for JCL are updated and enforced.
>>>
>>> Water under the proverbial bridge now.  At least we have EZACFSM1 as an
>>> alternative, so that's good.
>>>
>>> Peter
>>>
>>> -Original Message-
>>> From: IBM Mainframe Discussion List  On Behalf
>>> Of Sri h Kolusu
>>> Sent: Wednesday, June 15, 2022 1:32 PM
>>> To: IBM-MAIN@LISTSERV.UA.EDU
>>> Subject: Re: SFTP JOB Data parameter
>>>
>>> >>> But that raises the question why NOT always allow system symbols in
>>> >>> every batch initiator?  Allowing them just seems like a no-brainer
>>> >>> to me
>>>
>>> Peter,
>>>
>>> There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and
>>> here is a post which explains one of the reason.
>>>
>>> https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html
>>>
>>> Thanks,
>>> Kolusu
>>> --
>>>
>>> This message and any attachments are intended only for the use of the
>>> addressee and may contain information that is privileged and confidential.
>>> If the reader of the message is not the intended recipient or an authorized
>>> representative of the intended recipient, you are hereby notified that any
>>> dissemination of this communication is strictly prohibited. If you have
>>> received this communication in error, please notify us immediately by
>>> e-mail and delete the message and any attachments from your system.
>>>

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

Re: SFTP JOB Data parameter

[Bill Godfrey]

Your first "echo" doesn't have a "+" at the end like your original did.

Your "OGET" doesn't have a "-" at the end like your original did.

The  symbol generates a 2-digit year, but your filenames use a 4-digit 
year.
Instead of  use 

On Thu, 16 Jun 2022 07:45:53 +0300, saurabh khandelwal wrote:

>
>Now I am getting below error, while running this JCL code.
>
>
>
>JCL
>
>
>
>//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
>
>//TAILOR  EXEC PGM=PGM=EZACFSM1
>
>//SYSOUT   DD   DISP=(NEW,PASS,DELETE),DSN=,
>
>// UNIT=VIO,SPACE=(TRK,(1))
>
>//SYSINDD *
>
>OSHELL { echo 'lcd /u/op117/';
>
>  echo 'cd /FRB/EBCClearing/Staging/tmp';+
>
>  echo 'ASCII'; +
>
>  echo 'get EBC-GOV-'; } | +
>
>sftp -P  eftmfge...@10.222.xx.xx
>
>OGET '/u/op117/EBC-GOV-'  -
>
>  'NBFDP.DATA.XX.XX.SFTP'
>
>//STEP1   EXEC PGM=IKJEFT01,REGION=0M
>
>//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
>
>//SYSTSIN   DD DSN=,DISP=(OLD,DELETE)
>
>//OUTPUT DD SYSOUT=*
>
>//SYSTSPRT DD SYSOUT=*
>
>/*
>
>
>
>Output below :
>
>
>
>READY
>
>OSHELL { echo 'lcd
>/u/op117/';
>
> OSHELL RC =  256
>
>
>
>
> OSHELL Exit Status =
>1
>
>
>
>READY
>
>  echo 'cd /FRB/EBCClearing/Staging/tmp';  echo 'ASCII'; echo 'get
>EBC
>
>.22.10
>
>COMMAND ECHO NOT
>FOUND
>
>READY
>
>OGET '/u/op117/EBC-GOV-220616.txt'
>'NBFDP.DATA.XX.
>
>RETURN CODE 0081, REASON CODE 05620062.  AN ERROR OCCURRED DURING THE
>OPENIN
>
>READY
>
>END
>
>
>
>
>
>FSUM7332 syntax error: got EOF, expecting }
>
>On Wed, Jun 15, 2022, 21:45 Farley, Peter x23353 <
>031df298a9da-dmarc-requ...@listserv.ua.edu> wrote:
>
>> Thanks again Sri.  After reading those posts, I do see the issue.  That
>> would be the "Don't break existing jobs" mantra.
>>
>> I would instead have said "Go ahead and break them in QA so we can fix the
>> broken ones", but I don't pay the bills and "breaking them in QA" AssUMes
>> that QA batch initiator classes are distinct from Production batch
>> initiator classes, which isn't true at any large shop where I have worked.
>>
>> But I agree with Gil's final post in that thread - it should have been
>> implemented as a new JCL option (similar to EXPORT SYMLIST) rather than an
>> initiator class parameter.  Positive opt-in for jobs that want to use it,
>> leave the others alone.  Perhaps a global parameter for the JCL interpreter
>> to allow or disallow the new JCL option during the initial transition so
>> shops could choose to allow or disallow use of the new JCL option to
>> prevent accidental breakage by too-eager programmers until automated SDLC
>> rules for JCL are updated and enforced.
>>
>> Water under the proverbial bridge now.  At least we have EZACFSM1 as an
>> alternative, so that's good.
>>
>> Peter
>>
>> -Original Message-
>> From: IBM Mainframe Discussion List  On Behalf
>> Of Sri h Kolusu
>> Sent: Wednesday, June 15, 2022 1:32 PM
>> To: IBM-MAIN@LISTSERV.UA.EDU
>> Subject: Re: SFTP JOB Data parameter
>>
>> >>> But that raises the question why NOT always allow system symbols in
>> >>> every batch initiator?  Allowing them just seems like a no-brainer
>> >>> to me
>>
>> Peter,
>>
>> There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and
>> here is a post which explains one of the reason.
>>
>> https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html
>>
>> Thanks,
>> Kolusu
>> --
>>
>> This message and any attachments are intended only for the use of the
>> addressee and may contain information that is privileged and confidential.
>> If the reader of the message is not the intended recipient or an authorized
>> representative of the intended recipient, you are hereby notified that any
>> dissemination of this communication is strictly prohibited. If you have
>> received this communication in error, please notify us immediately by
>> e-mail and delete the message and any attachments from your system.
>>

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

Re: SFTP JOB Data parameter

[saurabh khandelwal]

Dear,



Now I am getting below error, while running this JCL code.



JCL



//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=

//TAILOR  EXEC PGM=PGM=EZACFSM1

//SYSOUT   DD   DISP=(NEW,PASS,DELETE),DSN=,

// UNIT=VIO,SPACE=(TRK,(1))

//SYSINDD *

OSHELL { echo 'lcd /u/op117/';

  echo 'cd /FRB/EBCClearing/Staging/tmp';+

  echo 'ASCII'; +

  echo 'get EBC-GOV-'; } | +

sftp -P  eftmfge...@10.222.xx.xx

OGET '/u/op117/EBC-GOV-'  -

  'NBFDP.DATA.XX.XX.SFTP'

//STEP1   EXEC PGM=IKJEFT01,REGION=0M

//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC

//SYSTSIN   DD DSN=,DISP=(OLD,DELETE)

//OUTPUT DD SYSOUT=*

//SYSTSPRT DD SYSOUT=*

/*



Output below :



READY

OSHELL { echo 'lcd
/u/op117/';

 OSHELL RC =  256




 OSHELL Exit Status =
1



READY

  echo 'cd /FRB/EBCClearing/Staging/tmp';  echo 'ASCII'; echo 'get
EBC

.22.10

COMMAND ECHO NOT
FOUND

READY

OGET '/u/op117/EBC-GOV-220616.txt'
'NBFDP.DATA.XX.

RETURN CODE 0081, REASON CODE 05620062.  AN ERROR OCCURRED DURING THE
OPENIN

READY

END





FSUM7332 syntax error: got EOF, expecting }

On Wed, Jun 15, 2022, 21:45 Farley, Peter x23353 <
031df298a9da-dmarc-requ...@listserv.ua.edu> wrote:

> Thanks again Sri.  After reading those posts, I do see the issue.  That
> would be the "Don't break existing jobs" mantra.
>
> I would instead have said "Go ahead and break them in QA so we can fix the
> broken ones", but I don't pay the bills and "breaking them in QA" AssUMes
> that QA batch initiator classes are distinct from Production batch
> initiator classes, which isn't true at any large shop where I have worked.
>
> But I agree with Gil's final post in that thread - it should have been
> implemented as a new JCL option (similar to EXPORT SYMLIST) rather than an
> initiator class parameter.  Positive opt-in for jobs that want to use it,
> leave the others alone.  Perhaps a global parameter for the JCL interpreter
> to allow or disallow the new JCL option during the initial transition so
> shops could choose to allow or disallow use of the new JCL option to
> prevent accidental breakage by too-eager programmers until automated SDLC
> rules for JCL are updated and enforced.
>
> Water under the proverbial bridge now.  At least we have EZACFSM1 as an
> alternative, so that's good.
>
> Peter
>
> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Sri h Kolusu
> Sent: Wednesday, June 15, 2022 1:32 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: SFTP JOB Data parameter
>
> >>> But that raises the question why NOT always allow system symbols in
> >>> every batch initiator?  Allowing them just seems like a no-brainer
> >>> to me
>
> Peter,
>
> There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and
> here is a post which explains one of the reason.
>
> https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html
>
> Thanks,
> Kolusu
> --
>
> This message and any attachments are intended only for the use of the
> addressee and may contain information that is privileged and confidential.
> If the reader of the message is not the intended recipient or an authorized
> representative of the intended recipient, you are hereby notified that any
> dissemination of this communication is strictly prohibited. If you have
> received this communication in error, please notify us immediately by
> e-mail and delete the message and any attachments from your system.
>
> --
> 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: SFTP JOB Data parameter

[Farley, Peter x23353]

Thanks again Sri.  After reading those posts, I do see the issue.  That would 
be the "Don't break existing jobs" mantra.

I would instead have said "Go ahead and break them in QA so we can fix the 
broken ones", but I don't pay the bills and "breaking them in QA" AssUMes that 
QA batch initiator classes are distinct from Production batch initiator 
classes, which isn't true at any large shop where I have worked.

But I agree with Gil's final post in that thread - it should have been 
implemented as a new JCL option (similar to EXPORT SYMLIST) rather than an 
initiator class parameter.  Positive opt-in for jobs that want to use it, leave 
the others alone.  Perhaps a global parameter for the JCL interpreter to allow 
or disallow the new JCL option during the initial transition so shops could 
choose to allow or disallow use of the new JCL option to prevent accidental 
breakage by too-eager programmers until automated SDLC rules for JCL are 
updated and enforced.

Water under the proverbial bridge now.  At least we have EZACFSM1 as an 
alternative, so that's good.

Peter

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Sri 
h Kolusu
Sent: Wednesday, June 15, 2022 1:32 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

>>> But that raises the question why NOT always allow system symbols in 
>>> every batch initiator?  Allowing them just seems like a no-brainer 
>>> to me

Peter,

There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and here is 
a post which explains one of the reason.

https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html 

Thanks,
Kolusu
--

This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.

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

Re: SFTP JOB Data parameter

[Carmen Vitullo]

reading the post sited, at least at my site no user would be allowed by 
security to create a dataset with the SYSTEM NAME as a HLQ or the entire 
dataset name, a discrete or generic TSS or RACF rule would need to be 
defined in a protect all environment - in my site


at my site all job classes are set to syssym allow and we have not seen 
any issues


so use at your own risk I suppose


Carmen

On 6/15/2022 12:31 PM, Sri h Kolusu wrote:

But that raises the question why NOT always allow system symbols in every batch 
initiator?  Allowing them just seems like a no-brainer to me

Peter,

There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and here is 
a post which explains one of the reason.

https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html


Thanks,
Kolusu

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



--
/I am not bound to win, but I am bound to be true. I am not bound to 
succeed, but I am bound to live by the light that I have. I must stand 
with anybody that stands right, and stand with him while he is right, 
and part with him when he goes wrong. *Abraham Lincoln*/


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

Re: SFTP JOB Data parameter

[Michael Oujesky]

My guess is that resolution of dynamic symbols can differ each time 
they are interpreted,  In my JCL coding, I use refer-backs so that 
that any dataset is evaluated only once in the JCL.  Further 
references to that dataset do not use the dynamic symbol.


Michael

At 12:26 PM 6/15/2022, Farley, Peter x23353 wrote:
Thanks Sri, I did not know about SYSSYM=ALLOW.  But that raises the 
question why NOT always allow system symbols in every batch 
initiator?  Allowing them just seems like a no-brainer to me, but 
then I'm just an application programmer who expects to be able to 
use all of the available tools to get the job done.


Peter

-Original Message-
From: IBM Mainframe Discussion List  On 
Behalf Of Sri h Kolusu

Sent: Wednesday, June 15, 2022 1:15 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

>> Why is EZACFSM1 required to use  in an instream 
DD?  Couldn't the OP just use:


Peter,

Not all shops SYSSYM=ALLOW defined. So if your jobclass is NOT 
defined to allow symbols, the symbols will not be 
translated.  However with program EZACFSM1 will translate all the 
symbols defined to the system.



Thanks,
Kolusu
--

This message and any attachments are intended only for the use of 
the addressee and may contain information that is privileged and 
confidential. If the reader of the message is not the intended 
recipient or an authorized representative of the intended recipient, 
you are hereby notified that any dissemination of this communication 
is strictly prohibited. If you have received this communication in 
error, please notify us immediately by e-mail and delete the message 
and any attachments from your system.


--
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: SFTP JOB Data parameter

[Sri h Kolusu]

>>> But that raises the question why NOT always allow system symbols in every 
>>> batch initiator?  Allowing them just seems like a no-brainer to me

Peter,

There have been several discussions on IBM-MAIN about SYSSYM=ALLOW and here is 
a post which explains one of the reason.

https://www.mail-archive.com/ibm-main@listserv.ua.edu/msg62638.html


Thanks,
Kolusu

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

Re: SFTP JOB Data parameter

[Farley, Peter x23353]

Thanks Sri, I did not know about SYSSYM=ALLOW.  But that raises the question 
why NOT always allow system symbols in every batch initiator?  Allowing them 
just seems like a no-brainer to me, but then I'm just an application programmer 
who expects to be able to use all of the available tools to get the job done.

Peter

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Sri 
h Kolusu
Sent: Wednesday, June 15, 2022 1:15 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

>> Why is EZACFSM1 required to use  in an instream DD?  Couldn't the OP 
>> just use:

Peter,

Not all shops SYSSYM=ALLOW defined. So if your jobclass is NOT defined to allow 
symbols, the symbols will not be translated.  However with program EZACFSM1 
will translate all the symbols defined to the system.


Thanks,
Kolusu
--

This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.

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

Re: SFTP JOB Data parameter

[Sri h Kolusu]

>> Why is EZACFSM1 required to use  in an instream DD?  Couldn't the OP 
>> just use:

Peter,

Not all shops SYSSYM=ALLOW defined. So if your jobclass is NOT defined to allow 
symbols, the symbols will not be translated.  However with program EZACFSM1 
will translate all the symbols defined to the system.


Thanks,
Kolusu

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

Re: SFTP JOB Data parameter

[Bonnie Barthel]

Yes, it does not do the FTP, it only creates control cards to allow the use of 
system symbols.
https://www.ibm.com/docs/en/zos/2.4.0?topic=considerations-mvs-system-symbols

Bonnie Barthel
Senior IT Specialist
719.649.7888 Mobile
bonnie.bart...@kyndryl.com


-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of Sri 
h Kolusu
Sent: Wednesday, June 15, 2022 10:59 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] Re: SFTP JOB Data parameter

>> Can we use PGM=EZACFSM1 with sftp also . I am not sure

Saurabh,

Bonnie meant provide the control cards to symbol translator program EZACFSM1 
and use those translated cards to perform the SFTP.  You use the dynamic system 
symbols for current date.  Here is the link to the symbols 
https://www.ibm.com/docs/en/zos/2.4.0?topic=symbols-dynamic-system 

Something like this

//STEP0EXEC PGM=EZACFSM1
//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0))
//SYSINDD DATA,DLM=@@
OSHELL { ECHO 'LCD /U/OP117/';  +
 ECHO 'CD /FRB/EBCCLEARING/STAGING/TMP';+
 ECHO 'ASCII';  +
 ECHO 'GET EBC-GOV-MMDD.TXT'; } |   +
 SFTP -P  eftmfge...@10.222.xx.xx<mailto:eftmfge...@10.222.xx.xx>
 OGET '/U/OP117/EBC-GOV-' -
  'NBFDP.DATA.XX.XX.SFTP'
@@
//STEP1EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC
//OUTPUT   DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD DISP=(OLD,PASS),DSN=&


Thanks,
Kolusu


--
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: SFTP JOB Data parameter

[Farley, Peter x23353]

Why is EZACFSM1 required to use  in an instream DD?  Couldn't the OP 
just use:

//TSOUSERX JOB . . . 
// EXPORT SYMLIST=*
// SET MYDATE=
//SYSTSIN DD *,SYMBOLS=JCLONLY
CONTROL CARD UISNG 
/*

to substitute that value? (tested using IEBGENER with a SYSUT1 instream and 
SYSUT2 DD SYSOUT=*)

Using symbols in a regular file (Unix or MVS) of course requires EZACFSM1, but 
for an instream control card file it is not required.

Peter

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Michael Oujesky
Sent: Wednesday, June 15, 2022 11:42 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP JOB Data parameter

As a starting point:
//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
//TAILOR  EXEC PGM=PGM=EZACFSM1
//SYSOUT   DD   DISP=(NEW,PASS,DELETE),DSN=,
// UNIT=VIO,SPACE=(TRK,(1)),
// RECFM=FB,LRECL=80,BLKSZE=800
//SYSINDD *
OSHELL { echo 'lcd /u/op117/';
  echo 'cd /FRB/EBCClearing/Staging/tmp';+
  echo 'ASCII'; +
  echo 'get EBC-GOV-'; } | +
sftp -P  eftmfge...@10.222.xx.xx
OGET '/u/op117/EBC-GOV-'  -
  'NBFDP.DATA.XX.XX.SFTP'
//STEP1   EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
//SYSTSIN   DD DSN=,DISP=(OLD,DELETE)
//OUTPUT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
/*

At 05:44 AM 6/15/2022, saurabh khandelwal wrote:
>--
>
>Dear All,
>
>I am am running below Job in TSO env and getting to get file file from 
>windows to Mainframe env.
>
>Initially file was static and all worked well. But now, requirement is 
>to get the file, which has current time stamp on daily basis.
>
>Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with 
>year/month/date.
>
>But I am unable to find way to achieve this goal. Can you please help 
>on this issue.
>//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
>//STEP1   EXEC PGM=IKJEFT01,REGION=0M
>//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
>//SYSTSIN   DD DSN=NP.LIB.CLIST(SFTPSEBC),DISP=SHR
>//OUTPUT DD SYSOUT=*
>//SYSTSPRT DD SYSOUT=*
>/*
>EDIT  NP.LIB.CLIST(SFTPSEBB) - 01.01Columns 1 00072
>Command ===>  Scroll ===> CSR
>07 OSHELL { echo 'lcd /u/op117/';
>08  echo 'cd /FRB/EBCClearing/Staging/tmp';+
>09  echo 'ASCII'; +
>10  echo 'get EBC-GOV-mmdd.txt'; } | +
>11sftp -P  eftmfge...@10.222.xx.xx
>12 OGET '/u/op117/EBC-GOV-mmdd.txt'  -
>13  'NBFDP.DATA.XX.XX.SFTP'
>
>**  Bottom of Data
>
--

This message and any attachments are intended only for the use of the addressee 
and may contain information that is privileged and confidential. If the reader 
of the message is not the intended recipient or an authorized representative of 
the intended recipient, you are hereby notified that any dissemination of this 
communication is strictly prohibited. If you have received this communication 
in error, please notify us immediately by e-mail and delete the message and any 
attachments from your system.

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

Re: SFTP JOB Data parameter

[Sri h Kolusu]

>> Can we use PGM=EZACFSM1 with sftp also . I am not sure

Saurabh,

Bonnie meant provide the control cards to symbol translator program EZACFSM1 
and use those translated cards to perform the SFTP.  You use the dynamic system 
symbols for current date.  Here is the link to the symbols 
https://www.ibm.com/docs/en/zos/2.4.0?topic=symbols-dynamic-system

Something like this

//STEP0EXEC PGM=EZACFSM1
//SYSOUT   DD DSN=&,DISP=(,PASS),SPACE=(TRK,(1,0))
//SYSINDD DATA,DLM=@@
OSHELL { ECHO 'LCD /U/OP117/';  +
 ECHO 'CD /FRB/EBCCLEARING/STAGING/TMP';+
 ECHO 'ASCII';  +
 ECHO 'GET EBC-GOV-MMDD.TXT'; } |   +
 SFTP -P  eftmfge...@10.222.xx.xx
 OGET '/U/OP117/EBC-GOV-' -
  'NBFDP.DATA.XX.XX.SFTP'
@@
//STEP1EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD DISP=SHR,DSN=SYS1.SBPXEXEC
//OUTPUT   DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN  DD DISP=(OLD,PASS),DSN=&


Thanks,
Kolusu


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

Re: SFTP JOB Data parameter

[Michael Oujesky]

As a starting point:
//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
//TAILOR  EXEC PGM=PGM=EZACFSM1
//SYSOUT   DD   DISP=(NEW,PASS,DELETE),DSN=,
// UNIT=VIO,SPACE=(TRK,(1)),
// RECFM=FB,LRECL=80,BLKSZE=800
//SYSINDD *
OSHELL { echo 'lcd /u/op117/';
 echo 'cd /FRB/EBCClearing/Staging/tmp';+
 echo 'ASCII'; +
 echo 'get EBC-GOV-'; } | +
   sftp -P  eftmfge...@10.222.xx.xx
OGET '/u/op117/EBC-GOV-'  -
 'NBFDP.DATA.XX.XX.SFTP'
//STEP1   EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
//SYSTSIN   DD DSN=,DISP=(OLD,DELETE)
//OUTPUT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
/*

At 05:44 AM 6/15/2022, saurabh khandelwal wrote:

--

Dear All,

I am am running below Job in TSO env and getting to get file file 
from windows to Mainframe env.


Initially file was static and all worked well. But now, requirement 
is to get the file, which has current time stamp on daily basis.


Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with 
year/month/date.


But I am unable to find way to achieve this goal. Can you please 
help on this issue.

//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
//STEP1   EXEC PGM=IKJEFT01,REGION=0M
//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
//SYSTSIN   DD DSN=NP.LIB.CLIST(SFTPSEBC),DISP=SHR
//OUTPUT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
/*
EDIT  NP.LIB.CLIST(SFTPSEBB) - 01.01Columns 1 00072
Command ===>  Scroll ===> CSR
07 OSHELL { echo 'lcd /u/op117/';
08  echo 'cd /FRB/EBCClearing/Staging/tmp';+
09  echo 'ASCII'; +
10  echo 'get EBC-GOV-mmdd.txt'; } | +
11sftp -P  eftmfge...@10.222.xx.xx
12 OGET '/u/op117/EBC-GOV-mmdd.txt'  -
13  'NBFDP.DATA.XX.XX.SFTP'

**  Bottom of Data 



--
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: SFTP JOB Data parameter

[saurabh khandelwal]

Dear Bonnie,

Can we use PGM=EZACFSM1 with sftp also . I am not sure

On Wed, Jun 15, 2022, 17:37 Bonnie Barthel 
wrote:

> Look up PGM=EZACFSM1... it may be what you are looking for.
>
> Bonnie Barthel
> Senior IT Specialist
> 719.649.7888 Mobile
> bonnie.bart...@kyndryl.com
>
>
> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Paul Gilmartin
> Sent: Wednesday, June 15, 2022 8:08 AM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: [EXTERNAL] Re: SFTP JOB Data parameter
>
> On Wed, 15 Jun 2022 13:11:05 +, Seymour J Metz  wrote:
>
> >Write a REXX script to do the file transfer. You can use the date('S')
> function to generate the date in the format mmdd, then parse out the
> component to build your dsn.
> >
> I would have done something similar.  But the OP was on a promising track,
> however circuitous, even reporting a partial success.  Let's not deflect
> him.
>
> --
> gil
>
> --
> 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
>

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

Re: SFTP JOB Data parameter

[saurabh khandelwal]

Hello Paul,

If I use rexx then how will I be able to use shell command in same job

On Wed, Jun 15, 2022, 17:08 Paul Gilmartin <
042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:

> On Wed, 15 Jun 2022 13:11:05 +, Seymour J Metz  wrote:
>
> >Write a REXX script to do the file transfer. You can use the date('S')
> function to generate the date in the format mmdd, then parse out the
> component to build your dsn.
> >
> I would have done something similar.  But the OP was on a promising track,
> however circuitous, even reporting a partial success.  Let's not deflect
> him.
>
> --
> gil
>
> --
> 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: SFTP JOB Data parameter

[Bonnie Barthel]

Look up PGM=EZACFSM1... it may be what you are looking for.

Bonnie Barthel
Senior IT Specialist
719.649.7888 Mobile
bonnie.bart...@kyndryl.com


-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Paul Gilmartin
Sent: Wednesday, June 15, 2022 8:08 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: [EXTERNAL] Re: SFTP JOB Data parameter

On Wed, 15 Jun 2022 13:11:05 +, Seymour J Metz  wrote:

>Write a REXX script to do the file transfer. You can use the date('S') 
>function to generate the date in the format mmdd, then parse out the 
>component to build your dsn.
>
I would have done something similar.  But the OP was on a promising track, 
however circuitous, even reporting a partial success.  Let's not deflect him.

--
gil

--
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: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 15 Jun 2022 13:11:05 +, Seymour J Metz  wrote:

>Write a REXX script to do the file transfer. You can use the date('S') 
>function to generate the date in the format mmdd, then parse out the 
>component to build your dsn.
>
I would have done something similar.  But the OP was on a promising track,
however circuitous, even reporting a partial success.  Let's not deflect him.

-- 
gil

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

Re: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 15 Jun 2022 15:58:57 +0300, saurabh khandelwal wrote:
>
>Thank for reply but system doesn't take %D as date variable.  It taking as
>file name. So variable in file mmdd not getting replaced with actual
>date
>
%D is not a "date variable".  It is a substitution element in the argument
to the "date" command.

Did you try my suggestion:
date '+get EBC-GOV-%D.txt'
???

>On Wed, Jun 15, 2022, 15:54 Paul Gilmartin wrote:
>> >
>> >I am am running below Job in TSO env and getting to get file file from
>> >windows to Mainframe env.
>> >
>> >Initially file was static and all worked well. But now, requirement is to
>> >get the file, which has current time stamp on daily basis.
>> >
>> >Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with
>> >year/month/date.
>> >
>> # Change:
>> echo 'get EBC-GOV-mmdd.txt'
>>
>> # to
>> date '+get EBC-GOV-%D.txt'

-- 
gil

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

Re: SFTP JOB Data parameter

[Seymour J Metz]

Write a REXX script to do the file transfer. You can use the date('S') function 
to generate the date in the format mmdd, then parse out the component to 
build your dsn.


See Chapter 12. FTP Client Application Programming Interface (API), p. 307, in 
z/OS Communications Server 2.5 IP Programmer's Guide and Reference, 
SC27-3659-50.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
saurabh khandelwal [sourabhkhandelwal...@gmail.com]
Sent: Wednesday, June 15, 2022 6:44 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: SFTP JOB Data parameter

--


Dear All,



I am am running below Job in TSO env and getting to get file file from
windows to Mainframe env.



Initially file was static and all worked well. But now, requirement is to
get the file, which has current time stamp on daily basis.



Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with
year/month/date.



But I am unable to find way to achieve this goal. Can you please help on
this issue.





//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=

//STEP1   EXEC PGM=IKJEFT01,REGION=0M

//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC

//SYSTSIN   DD DSN=NP.LIB.CLIST(SFTPSEBC),DISP=SHR

//OUTPUT DD SYSOUT=*

//SYSTSPRT DD SYSOUT=*

/*







EDIT   NP.LIB.CLIST(SFTPSEBB) - 01.01Columns 1
00072

Command ===>  Scroll ===>
CSR

07  OSHELL { echo 'lcd /u/op117/';
+

08   echo 'cd /FRB/EBCClearing/Staging/tmp';
+

09   echo 'ASCII';
+

10   echo 'get EBC-GOV-mmdd.txt'; } | +

11 sftp -P  eftmfge...@10.222.xx.xx


12 OGET '/u/op117/EBC-GOV-mmdd.txt'  -

13   'NBFDP.DATA.XX.XX.SFTP'

**  Bottom of Data


--
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: SFTP JOB Data parameter

[saurabh khandelwal]

Hello Paul,

Thank for reply but system doesn't take %D as date variable.  It taking as
file name. So variable in file mmdd not getting replaced with actual
date

On Wed, Jun 15, 2022, 15:54 Paul Gilmartin <
042bfe9c879d-dmarc-requ...@listserv.ua.edu> wrote:

> On Wed, 15 Jun 2022 13:44:43 +0300, saurabh khandelwal  wrote:
> >
> >I am am running below Job in TSO env and getting to get file file from
> >windows to Mainframe env.
> >
> >Initially file was static and all worked well. But now, requirement is to
> >get the file, which has current time stamp on daily basis.
> >
> >Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with
> >year/month/date.
> >
> # Change:
> echo 'get EBC-GOV-mmdd.txt'
>
> # to
> date '+get EBC-GOV-%D.txt'
>
> >
> >But I am unable to find way to achieve this goal. Can you please help on
> >this issue.
> >
> >//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
> >//STEP1   EXEC PGM=IKJEFT01,REGION=0M
> >//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
> >//SYSTSIN   DD DSN=NP.LIB.CLIST(SFTPSEBC),DISP=SHR
> >//OUTPUT DD SYSOUT=*
> >//SYSTSPRT DD SYSOUT=*
> >/*
> >
> >EDIT   NP.LIB.CLIST(SFTPSEBB) - 01.01Columns 1
> >00072
> >
> >Command ===>  Scroll ===>
> >CSR
> >
> >07  OSHELL { echo 'lcd /u/op117/';
> >+
> >
> >08   echo 'cd /FRB/EBCClearing/Staging/tmp';
> >+
> >
> >09   echo 'ASCII';
> >+
> >
> >10   echo 'get EBC-GOV-mmdd.txt'; } | +
> >
> >11 sftp -P  eftmfge...@10.222.xx.xx
> >
> >
> >12 OGET '/u/op117/EBC-GOV-mmdd.txt'  -
> >
> >13   'NBFDP.DATA.XX.XX.SFTP'
> >
> >**  Bottom of Data
> >
>
> --
> gil
>
> --
> 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: SFTP JOB Data parameter

[Paul Gilmartin]

On Wed, 15 Jun 2022 13:44:43 +0300, saurabh khandelwal  wrote:
>
>I am am running below Job in TSO env and getting to get file file from
>windows to Mainframe env.
>
>Initially file was static and all worked well. But now, requirement is to
>get the file, which has current time stamp on daily basis.
>
>Ex : EBC-GOV-mmdd.txt'   in this mmdd should be replace with
>year/month/date.
>
# Change:
echo 'get EBC-GOV-mmdd.txt'

# to
date '+get EBC-GOV-%D.txt'

>
>But I am unable to find way to achieve this goal. Can you please help on
>this issue.
>
>//SFTPSEBC JOB (7330),MSGCLASS=X,CLASS=P,NOTIFY=
>//STEP1   EXEC PGM=IKJEFT01,REGION=0M
>//SYSEXEC  DD   DISP=SHR,DSN=SYS1.SBPXEXEC
>//SYSTSIN   DD DSN=NP.LIB.CLIST(SFTPSEBC),DISP=SHR
>//OUTPUT DD SYSOUT=*
>//SYSTSPRT DD SYSOUT=*
>/*
>
>EDIT   NP.LIB.CLIST(SFTPSEBB) - 01.01Columns 1
>00072
>
>Command ===>  Scroll ===>
>CSR
>
>07  OSHELL { echo 'lcd /u/op117/';
>+
>
>08   echo 'cd /FRB/EBCClearing/Staging/tmp';
>+
>
>09   echo 'ASCII';
>+
>
>10   echo 'get EBC-GOV-mmdd.txt'; } | +
>
>11 sftp -P  eftmfge...@10.222.xx.xx
>
>
>12 OGET '/u/op117/EBC-GOV-mmdd.txt'  -
>
>13   'NBFDP.DATA.XX.XX.SFTP'
>
>**  Bottom of Data
>

-- 
gil

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

Re: Sftp Vs connect direct

[Kirk Wolf]

I agree - compatibility with partners is key, which is why standardized 
protocols are often chosen over proprietary.  This may not be a consideration 
for all.

As others kindly mentioned, Co:Z SFTP includes support for z/OS data sets, 
codepage and line terminator conversions etc, etc.  It also supports automation 
on z/OS in the form of customizable notification WTOs, and IBM FTP-compatible 
user exits.   
https://dovetail.com/products/sftp.html

It is true that restart (of z/OS data set transfers) is not supported, but this 
turns out not to be as important a requirement as it was years ago when 
networks were much less reliable.   

Co:Z is available free under our Community License, Enterprise License and 
Support agreements are also available.
https://dovetail.com/support.html

Kirk Wolf
http://dovetail.com


On Sat, Apr 16, 2022, at 3:45 PM, Steve Beaver wrote:
> The whole discussion distills down to.  What does your partner site have 
> including their scheduling system. Unless they have a way that can signal the 
> file is there to the partner
> 
> Sent from my iPhone
> 
> No one said I could type with one thumb 
> 
> > On Apr 16, 2022, at 14:39, Michael Oujesky  wrote:
> > 
> > Due to the capabilities for check-pointing and automatic recovery, I would 
> > suggest C:D for large file transfers.
> > 
> > Though the transferred file has to be fully landed before processing of the 
> > data can begin, whereas FTP protocols do allow processing of the data as it 
> > is received.
> > 
> > If you are doing other transfers via C:D, then licensing cost is not an 
> > issue.  But if C:D is only used for these transfers, then a cost/benefit 
> > evaluation has to be made versus the cost/impact of error recovery time and 
> > effort needed to cope with FTP failures.  Note that C:D does allow for 
> > alternate nodes to receive a given transmission.
> > 
> > With both FTP and C:D transfers, I would suggest sending a zero length file 
> > to signal successful completion.
> > 
> > C:D can spawn a C:D process on the receiving end when transfer has been 
> > successfully completed or it could spawn task on sending or receiving 
> > systems to handle an unrecoverable transmission failure.  Then there are 
> > the capabilities of the C:D FileAgent component for additional automation 
> > options.
> > 
> > Michael
> > 
> > At 09:36 AM 4/16/2022, saurabh khandelwal wrote:
> > 
> >> Hello Group,
> >> 
> >> Currently we are using connect direct in our environment for file 
> >> transfer.  But now, our team like to migrate file transfer from connect 
> >> direct to sftp.
> >> 
> >> I think, sftp doesn't have any mechanism to find that file has been 
> >> transferred successfully or not . If we are transferring any big file 
> >> using sftp and Network connection broken then how it's going to impact the 
> >> file transfer or sender should again initiate file transfer.
> >> 
> >> In connect direct case we get return code on sender and receiver side 
> >> which confirm if file transfer is perfectly sent to destination without 
> >> any issue.
> >> 
> >> Can anybody guide me on this , which facility is best to use sftp or 
> >> connect direct
> >> 
> >> --
> >> 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
> 
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> 

Kirk Wolf
Dovetailed Technologies
http://dovetail.com

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

Re: Sftp Vs connect direct

[Steve Beaver]

The whole discussion distills down to.  What does your partner site have 
including their scheduling system. Unless they have a way that can signal the 
file is there to the partner

Sent from my iPhone

No one said I could type with one thumb 

> On Apr 16, 2022, at 14:39, Michael Oujesky  wrote:
> 
> Due to the capabilities for check-pointing and automatic recovery, I would 
> suggest C:D for large file transfers.
> 
> Though the transferred file has to be fully landed before processing of the 
> data can begin, whereas FTP protocols do allow processing of the data as it 
> is received.
> 
> If you are doing other transfers via C:D, then licensing cost is not an 
> issue.  But if C:D is only used for these transfers, then a cost/benefit 
> evaluation has to be made versus the cost/impact of error recovery time and 
> effort needed to cope with FTP failures.  Note that C:D does allow for 
> alternate nodes to receive a given transmission.
> 
> With both FTP and C:D transfers, I would suggest sending a zero length file 
> to signal successful completion.
> 
> C:D can spawn a C:D process on the receiving end when transfer has been 
> successfully completed or it could spawn task on sending or receiving systems 
> to handle an unrecoverable transmission failure.  Then there are the 
> capabilities of the C:D FileAgent component for additional automation options.
> 
> Michael
> 
> At 09:36 AM 4/16/2022, saurabh khandelwal wrote:
> 
>> Hello Group,
>> 
>> Currently we are using connect direct in our environment for file transfer.  
>> But now, our team like to migrate file transfer from connect direct to sftp.
>> 
>> I think, sftp doesn't have any mechanism to find that file has been 
>> transferred successfully or not . If we are transferring any big file using 
>> sftp and Network connection broken then how it's going to impact the file 
>> transfer or sender should again initiate file transfer.
>> 
>> In connect direct case we get return code on sender and receiver side which 
>> confirm if file transfer is perfectly sent to destination without any issue.
>> 
>> Can anybody guide me on this , which facility is best to use sftp or connect 
>> direct
>> 
>> --
>> 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

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

Re: Sftp Vs connect direct

[Michael Oujesky]

Due to the capabilities for check-pointing and automatic recovery, I 
would suggest C:D for large file transfers.


Though the transferred file has to be fully landed before processing 
of the data can begin, whereas FTP protocols do allow processing of 
the data as it is received.


If you are doing other transfers via C:D, then licensing cost is not 
an issue.  But if C:D is only used for these transfers, then a 
cost/benefit evaluation has to be made versus the cost/impact of 
error recovery time and effort needed to cope with FTP 
failures.  Note that C:D does allow for alternate nodes to receive a 
given transmission.


With both FTP and C:D transfers, I would suggest sending a zero 
length file to signal successful completion.


C:D can spawn a C:D process on the receiving end when transfer has 
been successfully completed or it could spawn task on sending or 
receiving systems to handle an unrecoverable transmission 
failure.  Then there are the capabilities of the C:D FileAgent 
component for additional automation options.


Michael

At 09:36 AM 4/16/2022, saurabh khandelwal wrote:


Hello Group,

Currently we are using connect direct in our environment for file 
transfer.  But now, our team like to migrate file transfer from 
connect direct to sftp.


I think, sftp doesn't have any mechanism to find that file has been 
transferred successfully or not . If we are transferring any big 
file using sftp and Network connection broken then how it's going to 
impact the file transfer or sender should again initiate file transfer.


In connect direct case we get return code on sender and receiver 
side which confirm if file transfer is perfectly sent to destination 
without any issue.


Can anybody guide me on this , which facility is best to use sftp or 
connect direct


--
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: Sftp Vs connect direct

[Lionel B. Dyck]

You will also want to checkout Co:Z from Dovetail as their enhanced sftp 
supports z/OS datasets. 

Lionel B Dyck <
Sent from my iPad Pro 10.5
Website: www.lbdsoftware.com

"Worry more about your character than your reputation.  Character is what you 
are, reputation merely what others think you are." - John Wooden

> On Apr 16, 2022, at 12:16 PM, Grant Taylor 
> <023065957af1-dmarc-requ...@listserv.ua.edu> wrote:
> 
> On 4/16/22 8:36 AM, saurabh khandelwal wrote:
>> Hello Group,
> 
> Hi,
> 
>> I think, sftp doesn't have any mechanism to find that file has been
>> transferred successfully or not.
>> In connect direct case we get return code on sender ...
> 
> sftp should give you a return code too.
> 
>> ... and receiver side which confirm if file transfer is perfectly sent to 
>> destination without any issue.
> 
> If you want belt and suspenders certainty, calculate a checksum on both sides 
> and compare them.
> 
> Optionally, use something like rsync which has more options than sftp.
> 
> 
> 
> -- 
> Grant. . . .
> unix || die
> 
> --
> 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: Sftp Vs connect direct

[Grant Taylor]

On 4/16/22 8:36 AM, saurabh khandelwal wrote:

Hello Group,


Hi,


I think, sftp doesn't have any mechanism to find that file has been
transferred successfully or not.

In connect direct case we get return code on sender ...


sftp should give you a return code too.

... and receiver side which confirm if file transfer is perfectly sent 
to destination without any issue.


If you want belt and suspenders certainty, calculate a checksum on both 
sides and compare them.


Optionally, use something like rsync which has more options than sftp.



--
Grant. . . .
unix || die

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

Re: Sftp Vs connect direct

[Paul Gilmartin]

On Sat, 16 Apr 2022 17:36:17 +0300, saurabh khandelwal wrote:
> If we are transferring any big file using
>sftp and Network connection broken then how it's going to impact the file
>transfer or sender should again initiate file transfer.
>
sftp is largely a front-end to ssh.  You might try using ssh directly
in a script and getting status:
ssh  host "set -x
cd /tmp/Linux-4.19.0-20-amd64-paulgilm/RO &
pwd &
cat >\"$2\"
" <"$1" ||
echo Failure! >&2

-- 
gil

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

Re: Sftp Vs connect direct

[Steve Beaver]

C:D is the best productive 

Sent from my iPhone

No one said I could type with one thumb 

> On Apr 16, 2022, at 09:42, saurabh khandelwal 
>  wrote:
> 
> Hello Group,
> 
> Currently we are using connect direct in our environment for file transfer.
> But now, our team like to migrate file transfer from connect direct to sftp.
> 
> I think, sftp doesn't have any mechanism to find that file has been
> transferred successfully or not . If we are transferring any big file using
> sftp and Network connection broken then how it's going to impact the file
> transfer or sender should again initiate file transfer.
> 
> In connect direct case we get return code on sender and receiver side which
> confirm if file transfer is perfectly sent to destination without any issue.
> 
> Can anybody guide me on this , which facility is best to use sftp or
> connect direct
> 
> --
> 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: SFTP jcl with proxy server

[Kirk Wolf]

Take a look at the z/OS OpenSSH User's Guide documentation for:

ssh options:
- ProxyCommand
- ProxyUseFdPass

command:
- ssh-proxyc   (in z/OS V2R4, if you have a prior release you can get it 
from https://dovetail.com/community.html )


I don't know what kind of proxy you are referring to, but the ssh-proxyc 
command provides for navigation of a simple SOCKS5 proxy.


For example:

//SFTPCONN EXEC PROC=SFTPPROC
//SFTPIN DD *
user=myuser
host=myhost.myco.com
lzopts="mode=text"
rfile="/app/data/remotefile.txt"

sftp_opts="$sftp_opts -oProxyUseFDpass=yes"
sftp_opts="$sftp_opts -oProxyCommand='ssh-proxyc 192.168.0.50:1080 %h %p' "

. $script_dir/sftp_connect.sh 

Re: SFTP jcl with proxy server

[william giannelli]

I am using ProxyCommand. but where do I specify the password?

On Fri, Apr 30, 2021 at 8:58 AM william giannelli 
wrote:

> ok "-oProxyCommand" then?
>
> On Fri, Apr 30, 2021 at 8:51 AM Kurt Quackenbush  wrote:
>
>> On 4/28/2021 6:25 PM, Bill Giannelli wrote:
>> > How do specify a proxy server in JCL for SFTP executing BPXBATCH?
>> I have no experience using it, but have you considered the
>> -oProxyCommand option of sftp?
>>
>> Kurt Quackenbush -- IBM, SMP/E Development
>> Chuck Norris never uses CHECK when he applies PTFs.
>>
>> --
>> 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: SFTP jcl with proxy server

[william giannelli]

ok "-oProxyCommand" then?

On Fri, Apr 30, 2021 at 8:51 AM Kurt Quackenbush  wrote:

> On 4/28/2021 6:25 PM, Bill Giannelli wrote:
> > How do specify a proxy server in JCL for SFTP executing BPXBATCH?
> I have no experience using it, but have you considered the
> -oProxyCommand option of sftp?
>
> Kurt Quackenbush -- IBM, SMP/E Development
> Chuck Norris never uses CHECK when he applies PTFs.
>
> --
> 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: SFTP jcl with proxy server

[Kurt Quackenbush]

On 4/28/2021 6:25 PM, Bill Giannelli wrote:

How do specify a proxy server in JCL for SFTP executing BPXBATCH?
I have no experience using it, but have you considered the 
-oProxyCommand option of sftp?


Kurt Quackenbush -- IBM, SMP/E Development
Chuck Norris never uses CHECK when he applies PTFs.

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

Re: SFTP jcl with proxy server

[Bill Giannelli]

so how do I code it? ProxyCommand? ProxyJump? -X connect -x?

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

Re: SFTP jcl with proxy server

[Grant Taylor]

On 4/28/21 4:58 PM, Paul Gilmartin wrote:

set ssh proxy environment variables


The "ssh proxy environment variables" causes me to wince.  Yes, they are 
environment variables which used in conjunction with SSH.  But, the 
environment variables aren't used by or referenced by the SSH client 
binary program in any way.  This is in stark contrast with the other 
*_PROXY environment variables listed on the page, which are referenced 
by the various client binary programs.


My experience has been that trying to keep the syntax, escaping, et al. 
correct for -- what is ultimately -- a long / complex command line is 
problematic.


I would *HIGHLY* advocate for putting the necessary configuration 
options in a configuration file and pointing the SSH client at said 
config file with a simple "-F /path/to/file".  --  Even pointing to the 
config file might not be necessary if you use one of the default 
locations that the SSH client binary will automatically look at.


I now turn the soapbox over to the next person with a grievance to air.



--
Grant. . . .
unix || die

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

Re: SFTP jcl with proxy server

[Paul Gilmartin]

On Wed, 28 Apr 2021 17:24:56 -0500, Bill Giannelli  wrote:

>How do specify a proxy server in JCL for SFTP executing BPXBATCH?
>
From: https://gist.github.com/yougg/5d2b3353fc5e197a0917aae0b3287d64

set ssh proxy environment variables
https://gist.github.com/yougg/5d2b3353fc5e197a0917aae0b3287d64#set-ssh-proxy-environment-variables

Perhaps in //STDENV

-- gil

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

Re: SFTP Sortcard creating using DFSORT

[Ron Thomas]

Thanks a lot Kolusu ..

Regards
Ron

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

Re: SFTP Sortcard creating using DFSORT

[Sri h Kolusu]

> Could you please help me to understand the below card as to how it
> is picking the store_nbr and create

Ron,

The job is parsing the input for the delimiter "}". Since we don't care
about the first 2 fields, they can be ignored.  REPEAT=v can be used with %
to specify v identically defined consecutive parsed fields to be ignored. v
can be 2 to 1000. For example, to ignore five consecutive comma delimited
fields, you
can use:

%=(ENDBEFR=C',',REPEAT=5),

which is equivalent to using:

%=(ENDBEFR=C','),
%=(ENDBEFR=C','),
%=(ENDBEFR=C','),
%=(ENDBEFR=C','),
%=(ENDBEFR=C','),

and then we parsed the store number with %01 and then used Justify (JFY) to
the parsed store number to add _ at the beginning using LEAD and the .CSV
at the end using TRAIL keywords.


If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest
reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial,
with lots of examples, that will show you how to use DFSORT, DFSORT's
ICETOOL and DFSORT Symbols. You can access it online, along with all of the
other DFSORT books, from:

http://www.ibm.com/support/docview.wss?rs=114=isg3T780

In your case look up for PARSE= and JFY=


Thanks,
Kolusu
DFSORT Development
IBM Corporation

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

Re: SFTP Sortcard creating using DFSORT

[Ron Thomas]

Thanks a lot Kolusu.. it worked like a charm !

Could you please help me to understand the below card as to how it is picking 
the store_nbr and create 


NREC PARSE=(%=(REPEAT=2,ENDAT=C'}'),
   %01=(ENDBEFR=C'{',
ENDBEFR=C' ',
FIXLEN=8)),
BUILD=(C' SPUT  ''',
   C'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01''',
   C' FUTRETAIL_',
   DATE1(-)-1,
   %01,JFY=(SHIFT=LEFT,
 LEAD=C'_',
TRAIL=C'.CSV',
LENGTH=16))


Regards
Ron T

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

Re: SFTP Sortcard creating using DFSORT

[Sri h Kolusu]

> but the issue is the store_nbrs are of different length, the .csv is
> not getting created correctly . Could some one let me know how we
> can append the .csv also when the store is of variable length
>

Ron,

Try this DFSORT JCL

//STEP0100 EXEC PGM=SORT
//SYSOUT   DD SYSOUT=*
//SORTIN   DD *
 ITEM_NBR   }  ITEM_DESC1  }  STORE_NBR   }
+1+2+3+4+5+-
 500849599 }ENT MASSA TORTA 2 KG }33
 500878286 }CAST DE CAJU TS 120G }331
 500862526 }MTR MASS LASANH SECA }3
 500877131 }PERU INTEIR C MIUDOS }3323
 500034169 }ACUC FIT UNIAO   }3311
 500832360 }AMPOLA PANTENE UNIDA }33
//SORTOUT  DD SYSOUT=*
//SYSINDD *
  OPTION COPY,SKIPREC=1
  INREC PARSE=(%=(REPEAT=2,ENDAT=C'}'),
   %01=(ENDBEFR=C'{',
ENDBEFR=C' ',
FIXLEN=8)),
BUILD=(C' SPUT  ''',
   C'K01.BB.RST.PTEM.FUTR.RTLDTA.REPT01''',
   C' FUTRETAIL_',
   DATE1(-)-1,
   %01,JFY=(SHIFT=LEFT,
 LEAD=C'_',
TRAIL=C'.CSV',
LENGTH=16))

/*


Thanks,
Kolusu
DFSORT Development
IBM Corporation


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

Re: SFTP and z/OS Migration

[Paul Gilmartin]

On Thu, 23 Jul 2020 17:57:20 +, Seymour J Metz wrote:

>Neither LCD nor LPWD is part of RFC 959. ...
>
Agreed.  Generally the RFCs impose only weak requirements on
client UIs, easily satisfied by both linemode and GUI clients.
Stronger requirements on both client and server network
interfaces.

>In an ideal world the MVS-OE developers would have looked at what Eunix 
>programmers in the wild actually used and not just what was needed to get 
>certification, but that has not always been what they did.
> 
Yes, remembering all the while that both MVS client and server
antedate OMVS and their subsequent extension to HFS was an
ad-hoc overlay.

-- gil

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

Re: SFTP and z/OS Migration

[Seymour J Metz]

Neither LCD nor LPWD is part of RFC 959. In an ideal world the MVS-OE 
developers would have looked at what Eunix programmers in the wild actually 
used and not just what was needed to get certification, but that has not always 
been what they did.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3


From: IBM Mainframe Discussion List [IBM-MAIN@LISTSERV.UA.EDU] on behalf of 
Paul Gilmartin [000433f07816-dmarc-requ...@listserv.ua.edu]
Sent: Thursday, July 23, 2020 1:27 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP and z/OS Migration

On Wed, 22 Jul 2020 16:07:54 -0500, Kirk Wolf wrote:
>...
>WinSCP has unique problems: it starts one SFTP connection for directory
>displays, and one or more for file transfers.   This is a little silly
>since you can do multiple things at a time on one connection.   This means
>that you can't change a /+ setting in the GUI and have it apply to file
>transfers.
>
This is reminiscent of an oddity in MVS plain old linemode ftp.  Like:

cd /here
ftp localhost
LPWD
/here
LCD /there
LPWD
/there
! pwd
/here

... apparently the MVS FTP client process does not issue a chdir(); as
I'm accustomed to on other systems.

-- gil

--
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: SFTP and z/OS Migration

[Paul Gilmartin]

On Wed, 22 Jul 2020 16:07:54 -0500, Kirk Wolf wrote:
>...
>WinSCP has unique problems: it starts one SFTP connection for directory
>displays, and one or more for file transfers.   This is a little silly
>since you can do multiple things at a time on one connection.   This means
>that you can't change a /+ setting in the GUI and have it apply to file
>transfers.
>
This is reminiscent of an oddity in MVS plain old linemode ftp.  Like:

cd /here
ftp localhost
LPWD
/here
LCD /there
LPWD
/there
! pwd
/here

... apparently the MVS FTP client process does not issue a chdir(); as
I'm accustomed to on other systems.

-- gil

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

Re: SFTP and z/OS Migration

[Lionel B Dyck]

I just tried Bitvise and have deleted WinSCP and FileZilla - Thank you Kirk...


Lionel B. Dyck <
Website: https://www.lbdsoftware.com

"Worry more about your character than your reputation.  Character is what you 
are, reputation merely what others think you are." - John Wooden

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Kirk Wolf
Sent: Thursday, July 23, 2020 11:14 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP and z/OS Migration

On Wed, Jul 22, 2020 at 4:07 PM Kirk Wolf  wrote:

>
> You *can* change settings interactively from most SFTP GUIs like 
> FileZilla
> -
> -  change directories to the "/+" directory (you will see your current
> settings)
> -  rename  the ".newoption" pretend file in that directory to the 
> option that you want to set
>
> WinSCP has unique problems: it starts one SFTP connection for directory
> displays, and one or more for file transfers.   This is a little silly
> since you can do multiple things at a time on one connection.   This means
> that you can't change a /+ setting in the GUI and have it apply to 
> file transfers.
>
> I don't use Windows much, but my favorite SFTP GUI is "BitVise", which 
> includes an SSH emulator and SFTP client.
>
>
>
Note:  I just tried the latest version of FileZilla, and it also now starts a 
new SFTP connection for transfers, separate from the one used for the UI
display.So changing settings interactively won't work there either.
 Try BitVise, which is better anyway IMO.

Kirk Wolf

--
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: SFTP and z/OS Migration

[Kirk Wolf]

On Wed, Jul 22, 2020 at 4:07 PM Kirk Wolf  wrote:

>
> You *can* change settings interactively from most SFTP GUIs like FileZilla
> -
> -  change directories to the "/+" directory (you will see your current
> settings)
> -  rename  the ".newoption" pretend file in that directory to the option
> that you want to set
>
> WinSCP has unique problems: it starts one SFTP connection for directory
> displays, and one or more for file transfers.   This is a little silly
> since you can do multiple things at a time on one connection.   This means
> that you can't change a /+ setting in the GUI and have it apply to file
> transfers.
>
> I don't use Windows much, but my favorite SFTP GUI is "BitVise", which
> includes an SSH emulator and SFTP client.
>
>
>
Note:  I just tried the latest version of FileZilla, and it also now starts
a new SFTP connection for transfers, separate from the one used for the UI
display.So changing settings interactively won't work there either.
 Try BitVise, which is better anyway IMO.

Kirk Wolf

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

Re: SFTP and z/OS Migration

[kekronbekron]

If you want to work with datasets (as opposed to files in USS), Co:Z SFTP is a 
no-brainer.
Believe me, it takes ages to OCOPY files from MVS to USS, especially if they're 
big files.

Alternatively, do you really need SFTP?
How about something like Luminex MDI SecureTransfer.
Their products' core principle is to use tape emulation to convert the TCP 
traffic to FICON, so you don't have TCP-related overhead.
But then once the data is on a Luminex back-end (needn't be their storage, 
could be any existing NAS etc.), you can then SFTP all you want without 
worrying about burning up CP time on the Z.


- KB

‐‐‐ Original Message ‐‐‐
On Thursday, July 23, 2020 3:00 AM, Roberto Halais  
wrote:

> "Political issues"
>
> Already ran into that.
> Thank you.
>
> On Wed, Jul 22, 2020 at 5:29 PM Seymour J Metz sme...@gmu.edu wrote:
>
> > Technically it's a no-brainer, but there may be political issues at some
> > sites.
> > --
> > Shmuel (Seymour J.) Metz
> > http://mason.gmu.edu/~smetz3
> >
> > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU on behalf
> > of Lionel B Dyck lbd...@gmail.com
> > Sent: Wednesday, July 22, 2020 4:54 PM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Re: SFTP and z/OS Migration
> > Kirk's wisdom and the doc he references are OUTSTANDING. Co:Z SFTP is
> > something you absolutely need if you want to use SFTP to access z/OS
> > datasets.
> > Be aware you will have to learn a few new tricks with the Co:Z SFTP server
> > from the client side unless you are happy with only binary transfers. And
> > neither FileZilla or WinSCP provide an escape value to issue the necessary
> > commands to switch from binary to text.
> > Lionel B. Dyck <
> > Website:
> > https://secure-web.cisco.com/1su7YLWql3q2JuCMbZqQtVaZfGTPi-2EGzr-2AmEck-H5XxLTMuTJSOnguJ4AyTa34QEsDvYmW9aIH8zJLvc6VBWRTRda-EGyb3EK1kVLyZ7nMqmPWOtogV2pNSILxVz_JRyM3ngUeaeYMXlJkfFPZKtpNKvd4gFKLDXG4jCu-YsTZwYJKp8ehdX_jsl1_oyRckWxK0L0o7EJpctlKbx1MxUQ4UQPAx9UIHOWdRP7ZbkHdL9LF49SOFCGliQYJ9EAYGho8yV53tgjUfSt-zC0rPxjj7ZRTKuF_6ldUvREMO2Koq368kW8WD-UMhlayr4Xrek9eMg1GwXLnXF9LpT16VMO6pJoiBzyL1uHHi6hZq97lQz5E_V3T93mvRqJEJXnnN9GMH5yYL9J-yZAcSkW5Fpkj3WGb1Uc57BB88Z44wlC_ToH2QaVUl8p5hy4ucDv/https%3A%2F%2Fwww.lbdsoftware.com
> > "Worry more about your character than your reputation. Character is what
> > you are, reputation merely what others think you are." - John Wooden
> > -Original Message-----
> > From: IBM Mainframe Discussion List IBM-MAIN@LISTSERV.UA.EDU On Behalf
> > Of Kirk Wolf
> > Sent: Wednesday, July 22, 2020 3:43 PM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: Re: SFTP and z/OS Migration
> > IBM z/OS OpenSSH is a base feature of z/OS since V2R2.
> > When you install a new version of z/OS you will get a new version.
> > There are often migration actions from IBM having to do with /etc/ssh
> > configuration settings. When moving releases you would at minimum want to
> > review any changes that you made from the IBM /samples and the new /samples
> > and merge those as appropriate.
> > BTW: Here's a quick start guide that we have on customizing IBM z/OS
> > OpenSSH:
> > https://secure-web.cisco.com/1kFuBUxMakNRAVJFVOewMH9LIIP2OTRg8SiVu_htNZD41RJZyNLVKsNTa6WEXeylcK5ZM1xGILiIhefULXta7xUZO9eRKq2GjKMg0pgAvGVH1qdk-StxkJSNB24ZHOnDublItI2dRxbaJ254YKnVJTU_VmE-PMaUftkzyJ6rWLuauYdSHsrPqQl-dwxGVdiMFNsSTRjVQgzNzjrgz3d4856xYoF81vYte0_nTV3vl-gpIjzpHXyYjcuRCdk5gZOGG7-PQZg0oTM2Z3vI1iJxE2KZi3kIz2fFx4sOqRzOT7_YszuYo-bWH9Iz3sdQ0n4DU9PaRRqNsWhr3jLFqVcxRx_fOsyfGGr8Am5A8IvVZh4mLtqr-J2XleXAq27Mo64WAJOPaU-33FfQqj9kBSZAwxoobYF5OZxeMLwIyHhw3MdvpKQKTsF1jztmSX6q1w8xU/https%3A%2F%2Fdovetail.com%2Fdocs%2Fpt-quick-inst%2Findex.html
> > Kirk Wolf
> > http://secure-web.cisco.com/1LetkAqmxb2mHTXoe2e35AwFZw4UYoiIeNOVgzH1Qms1MrKHD86XVzieGSUFJhCv8GbwqPhbow7NeP6IFvYjdUaYvXCjG1h6SrOBbM8Z0aY8BiznIGgTNB4MPWoeBlq9VHezSBTeajQgpsTv0DPS-EifgMxmQFHgIus0aNKsd5nTCtMZzPO8VXQvVZof7BN4s37wtsPa1FwHPZmQNrHC9UWaYP1qtW_icPDBb4QWZTKGEJSI8GAVlPMwcSsAIltqZQ1TmOecMdwTSTRMHrqTAnLc5aGT1gPLzOeLc0169dZ4oC3ssIozLNEJgKLuWvckDXYAFuLobcIX610AC0y6G-sC_6hLz315OjtuS0YSt7pnhtWMl3kxjYJlrYXapj4I9tcRYY4itCI6S1y8ogZ1et3UM9LLlvN2MBLb1nqyn11lSJBiuel8cV-T1Yk2HrnH2/http%3A%2F%2Fdovetail.com
> > On Wed, Jul 22, 2020 at 2:14 PM Roberto Halais roberto.hal...@gmail.com
> > wrote:
> >
> > > Listers:
> > > My company has decided to forego FTP and go the SFTP way.
> > > I have installed OPENSSH and have SFTP working.
> > > I installed using the IBM user's guide and everything installed in the
> > > default libraries.
> > > My concern is, when we migrate to a new z/OS release do I have to do
> > > the whole install again?
> > > Can I, from t

Re: SFTP and z/OS Migration

[Roberto Halais]

"Political issues"

Already ran into that.
Thank you.

On Wed, Jul 22, 2020 at 5:29 PM Seymour J Metz  wrote:

> Technically it's a no-brainer, but there may be political issues at some
> sites.
>
>
> --
> Shmuel (Seymour J.) Metz
> http://mason.gmu.edu/~smetz3
>
>
> 
> From: IBM Mainframe Discussion List  on behalf
> of Lionel B Dyck 
> Sent: Wednesday, July 22, 2020 4:54 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: SFTP and z/OS Migration
>
> Kirk's wisdom and the doc he references are OUTSTANDING.  Co:Z SFTP is
> something you absolutely need if you want to use SFTP to access z/OS
> datasets.
>
> Be aware you will have to learn a few new tricks with the Co:Z SFTP server
> from the client side unless you are happy with only binary transfers. And
> neither FileZilla or WinSCP provide an escape value to issue the necessary
> commands to switch from binary to text.
>
>
> Lionel B. Dyck <
> Website:
> https://secure-web.cisco.com/1su7YLWql3q2JuCMbZqQtVaZfGTPi-2EGzr-2AmEck-H5XxLTMuTJSOnguJ4AyTa34QEsDvYmW9aIH8zJLvc6VBWRTRda-EGyb3EK1kVLyZ7nMqmPWOtogV2pNSILxVz_JRyM3ngUeaeYMXlJkfFPZKtpNKvd4gFKLDXG4jCu-YsTZwYJKp8ehdX_jsl1_oyRckWxK0L0o7EJpctlKbx1MxUQ4UQPAx9UIHOWdRP7ZbkHdL9LF49SOFCGliQYJ9EAYGho8yV53tgjUfSt-zC0rPxjj7ZRTKuF_6ldUvREMO2Koq368kW8WD-UMhlayr4Xrek9eMg1GwXLnXF9LpT16VMO6pJoiBzyL1uHHi6hZq97lQz5E_V3T93mvRqJEJXnnN9GMH5yYL9J-yZAcSkW5Fpkj3WGb1Uc57BB88Z44wlC_ToH2QaVUl8p5hy4ucDv/https%3A%2F%2Fwww.lbdsoftware.com
>
> "Worry more about your character than your reputation.  Character is what
> you are, reputation merely what others think you are." - John Wooden
>
> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Kirk Wolf
> Sent: Wednesday, July 22, 2020 3:43 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: Re: SFTP and z/OS Migration
>
> IBM z/OS OpenSSH is a base feature of z/OS since V2R2.
> When you install a new version of z/OS you will get a new version.
> There are often migration actions from IBM having to do with /etc/ssh
> configuration settings.  When moving releases you would at minimum want to
> review any changes that you made from the IBM /samples and the new /samples
> and merge those as appropriate.
>
> BTW: Here's a quick start guide that we have on customizing IBM z/OS
> OpenSSH:
>
> https://secure-web.cisco.com/1kFuBUxMakNRAVJFVOewMH9LIIP2OTRg8SiVu_htNZD41RJZyNLVKsNTa6WEXeylcK5ZM1xGILiIhefULXta7xUZO9eRKq2GjKMg0pgAvGVH1qdk-StxkJSNB24ZHOnDublItI2dRxbaJ254YKnVJTU_VmE-PMaUftkzyJ6rWLuauYdSHsrPqQl-dwxGVdiMFNsSTRjVQgzNzjrgz3d4856xYoF81vYte0_nTV3vl-gpIjzpHXyYjcuRCdk5gZOGG7-PQZg0oTM2Z3vI1iJxE2KZi3kIz2fFx4sOqRzOT7_YszuYo-bWH9Iz3sdQ0n4DU9PaRRqNsWhr3jLFqVcxRx_fOsyfGGr8Am5A8IvVZh4mLtqr-J2XleXAq27Mo64WAJOPaU-33FfQqj9kBSZAwxoobYF5OZxeMLwIyHhw3MdvpKQKTsF1jztmSX6q1w8xU/https%3A%2F%2Fdovetail.com%2Fdocs%2Fpt-quick-inst%2Findex.html
>
> Kirk Wolf
>
> http://secure-web.cisco.com/1LetkAqmxb2mHTXoe2e35AwFZw4UYoiIeNOVgzH1Qms1MrKHD86XVzieGSUFJhCv8GbwqPhbow7NeP6IFvYjdUaYvXCjG1h6SrOBbM8Z0aY8BiznIGgTNB4MPWoeBlq9VHezSBTeajQgpsTv0DPS-EifgMxmQFHgIus0aNKsd5nTCtMZzPO8VXQvVZof7BN4s37wtsPa1FwHPZmQNrHC9UWaYP1qtW_icPDBb4QWZTKGEJSI8GAVlPMwcSsAIltqZQ1TmOecMdwTSTRMHrqTAnLc5aGT1gPLzOeLc0169dZ4oC3ssIozLNEJgKLuWvckDXYAFuLobcIX610AC0y6G-sC_6hLz315OjtuS0YSt7pnhtWMl3kxjYJlrYXapj4I9tcRYY4itCI6S1y8ogZ1et3UM9LLlvN2MBLb1nqyn11lSJBiuel8cV-T1Yk2HrnH2/http%3A%2F%2Fdovetail.com
>
> On Wed, Jul 22, 2020 at 2:14 PM Roberto Halais 
> wrote:
>
> > Listers:
> >
> > My company has decided to forego FTP and go the SFTP way.
> >
> > I have installed OPENSSH and have SFTP working.
> >
> > I installed using the IBM user's guide and everything installed in the
> > default libraries.
> >
> > My concern is, when we migrate to a new z/OS release do I have to do
> > the whole install again?
> >
> > Can I, from the beginning, install all the SSH libraries in a
> > different filesystem so that when I migrate I can just mount the
> > filesystem and execute.
> > And later on install the new version Openssh.
> >
> > Don't know if I am clear in what I am asking.
> >
> > Just some tips on facilitating installing under a new release.
> >
> > Thank you.
> >
> > --
> > 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: SFTP and z/OS Migration

[Roberto Halais]

Thank you all.
Got a lot of good information.

On Wed, Jul 22, 2020 at 5:08 PM Kirk Wolf  wrote:

> On Wed, Jul 22, 2020 at 3:54 PM Lionel B Dyck  wrote:
>
> >
> > Be aware you will have to learn a few new tricks with the Co:Z SFTP
> server
> > from the client side unless you are happy with only binary transfers. And
> > neither FileZilla or WinSCP provide an escape value to issue the
> necessary
> > commands to switch from binary to text.
> >
> >
> >
> Thanks Lionel,
>
> If you use GUIs much, it is often convenient to set up file name pattern
> specific settings in your $HOME/.ssh//etc/ssh/cozsftp_server_config  file.
>   See:  https://dovetail.com/docs/sftp/session-config.html
>
> For example:
>
> pattern: //*.JCL(*)
> mode=text
>
>
> You could also make "mode=text" the default for your userid in this file,
> but then you would need to change it when doing binary.
>
> You *can* change settings interactively from most SFTP GUIs like FileZilla
> -
> -  change directories to the "/+" directory (you will see your current
> settings)
> -  rename  the ".newoption" pretend file in that directory to the option
> that you want to set
>
> WinSCP has unique problems: it starts one SFTP connection for directory
> displays, and one or more for file transfers.   This is a little silly
> since you can do multiple things at a time on one connection.   This means
> that you can't change a /+ setting in the GUI and have it apply to file
> transfers.
>
> I don't use Windows much, but my favorite SFTP GUI is "BitVise", which
> includes an SSH emulator and SFTP client.
>
> Kirk Wolf
> http://dovetail.com
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Politics: Poli (many) - tics (blood sucking parasites)

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

Re: SFTP and z/OS Migration

[Seymour J Metz]

Technically it's a no-brainer, but there may be political issues at some sites.


--
Shmuel (Seymour J.) Metz
http://mason.gmu.edu/~smetz3



From: IBM Mainframe Discussion List  on behalf of 
Lionel B Dyck 
Sent: Wednesday, July 22, 2020 4:54 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP and z/OS Migration

Kirk's wisdom and the doc he references are OUTSTANDING.  Co:Z SFTP is 
something you absolutely need if you want to use SFTP to access z/OS datasets.

Be aware you will have to learn a few new tricks with the Co:Z SFTP server from 
the client side unless you are happy with only binary transfers. And neither 
FileZilla or WinSCP provide an escape value to issue the necessary commands to 
switch from binary to text.


Lionel B. Dyck <
Website: 
https://secure-web.cisco.com/1su7YLWql3q2JuCMbZqQtVaZfGTPi-2EGzr-2AmEck-H5XxLTMuTJSOnguJ4AyTa34QEsDvYmW9aIH8zJLvc6VBWRTRda-EGyb3EK1kVLyZ7nMqmPWOtogV2pNSILxVz_JRyM3ngUeaeYMXlJkfFPZKtpNKvd4gFKLDXG4jCu-YsTZwYJKp8ehdX_jsl1_oyRckWxK0L0o7EJpctlKbx1MxUQ4UQPAx9UIHOWdRP7ZbkHdL9LF49SOFCGliQYJ9EAYGho8yV53tgjUfSt-zC0rPxjj7ZRTKuF_6ldUvREMO2Koq368kW8WD-UMhlayr4Xrek9eMg1GwXLnXF9LpT16VMO6pJoiBzyL1uHHi6hZq97lQz5E_V3T93mvRqJEJXnnN9GMH5yYL9J-yZAcSkW5Fpkj3WGb1Uc57BB88Z44wlC_ToH2QaVUl8p5hy4ucDv/https%3A%2F%2Fwww.lbdsoftware.com

"Worry more about your character than your reputation.  Character is what you 
are, reputation merely what others think you are." - John Wooden

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Kirk Wolf
Sent: Wednesday, July 22, 2020 3:43 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP and z/OS Migration

IBM z/OS OpenSSH is a base feature of z/OS since V2R2.
When you install a new version of z/OS you will get a new version.
There are often migration actions from IBM having to do with /etc/ssh 
configuration settings.  When moving releases you would at minimum want to 
review any changes that you made from the IBM /samples and the new /samples and 
merge those as appropriate.

BTW: Here's a quick start guide that we have on customizing IBM z/OS
OpenSSH:
https://secure-web.cisco.com/1kFuBUxMakNRAVJFVOewMH9LIIP2OTRg8SiVu_htNZD41RJZyNLVKsNTa6WEXeylcK5ZM1xGILiIhefULXta7xUZO9eRKq2GjKMg0pgAvGVH1qdk-StxkJSNB24ZHOnDublItI2dRxbaJ254YKnVJTU_VmE-PMaUftkzyJ6rWLuauYdSHsrPqQl-dwxGVdiMFNsSTRjVQgzNzjrgz3d4856xYoF81vYte0_nTV3vl-gpIjzpHXyYjcuRCdk5gZOGG7-PQZg0oTM2Z3vI1iJxE2KZi3kIz2fFx4sOqRzOT7_YszuYo-bWH9Iz3sdQ0n4DU9PaRRqNsWhr3jLFqVcxRx_fOsyfGGr8Am5A8IvVZh4mLtqr-J2XleXAq27Mo64WAJOPaU-33FfQqj9kBSZAwxoobYF5OZxeMLwIyHhw3MdvpKQKTsF1jztmSX6q1w8xU/https%3A%2F%2Fdovetail.com%2Fdocs%2Fpt-quick-inst%2Findex.html

Kirk Wolf
http://secure-web.cisco.com/1LetkAqmxb2mHTXoe2e35AwFZw4UYoiIeNOVgzH1Qms1MrKHD86XVzieGSUFJhCv8GbwqPhbow7NeP6IFvYjdUaYvXCjG1h6SrOBbM8Z0aY8BiznIGgTNB4MPWoeBlq9VHezSBTeajQgpsTv0DPS-EifgMxmQFHgIus0aNKsd5nTCtMZzPO8VXQvVZof7BN4s37wtsPa1FwHPZmQNrHC9UWaYP1qtW_icPDBb4QWZTKGEJSI8GAVlPMwcSsAIltqZQ1TmOecMdwTSTRMHrqTAnLc5aGT1gPLzOeLc0169dZ4oC3ssIozLNEJgKLuWvckDXYAFuLobcIX610AC0y6G-sC_6hLz315OjtuS0YSt7pnhtWMl3kxjYJlrYXapj4I9tcRYY4itCI6S1y8ogZ1et3UM9LLlvN2MBLb1nqyn11lSJBiuel8cV-T1Yk2HrnH2/http%3A%2F%2Fdovetail.com

On Wed, Jul 22, 2020 at 2:14 PM Roberto Halais 
wrote:

> Listers:
>
> My company has decided to forego FTP and go the SFTP way.
>
> I have installed OPENSSH and have SFTP working.
>
> I installed using the IBM user's guide and everything installed in the
> default libraries.
>
> My concern is, when we migrate to a new z/OS release do I have to do
> the whole install again?
>
> Can I, from the beginning, install all the SSH libraries in a
> different filesystem so that when I migrate I can just mount the
> filesystem and execute.
> And later on install the new version Openssh.
>
> Don't know if I am clear in what I am asking.
>
> Just some tips on facilitating installing under a new release.
>
> Thank you.
>
> --
> 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

--
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: SFTP and z/OS Migration

[Kirk Wolf]

On Wed, Jul 22, 2020 at 3:54 PM Lionel B Dyck  wrote:

>
> Be aware you will have to learn a few new tricks with the Co:Z SFTP server
> from the client side unless you are happy with only binary transfers. And
> neither FileZilla or WinSCP provide an escape value to issue the necessary
> commands to switch from binary to text.
>
>
>
Thanks Lionel,

If you use GUIs much, it is often convenient to set up file name pattern
specific settings in your $HOME/.ssh//etc/ssh/cozsftp_server_config  file.
  See:  https://dovetail.com/docs/sftp/session-config.html

For example:

pattern: //*.JCL(*)
mode=text


You could also make "mode=text" the default for your userid in this file,
but then you would need to change it when doing binary.

You *can* change settings interactively from most SFTP GUIs like FileZilla -
-  change directories to the "/+" directory (you will see your current
settings)
-  rename  the ".newoption" pretend file in that directory to the option
that you want to set

WinSCP has unique problems: it starts one SFTP connection for directory
displays, and one or more for file transfers.   This is a little silly
since you can do multiple things at a time on one connection.   This means
that you can't change a /+ setting in the GUI and have it apply to file
transfers.

I don't use Windows much, but my favorite SFTP GUI is "BitVise", which
includes an SSH emulator and SFTP client.

Kirk Wolf
http://dovetail.com

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

Re: SFTP and z/OS Migration

[Lionel B Dyck]

Kirk's wisdom and the doc he references are OUTSTANDING.  Co:Z SFTP is 
something you absolutely need if you want to use SFTP to access z/OS datasets.

Be aware you will have to learn a few new tricks with the Co:Z SFTP server from 
the client side unless you are happy with only binary transfers. And neither 
FileZilla or WinSCP provide an escape value to issue the necessary commands to 
switch from binary to text.


Lionel B. Dyck <
Website: https://www.lbdsoftware.com

"Worry more about your character than your reputation.  Character is what you 
are, reputation merely what others think you are." - John Wooden

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Kirk Wolf
Sent: Wednesday, July 22, 2020 3:43 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: SFTP and z/OS Migration

IBM z/OS OpenSSH is a base feature of z/OS since V2R2.
When you install a new version of z/OS you will get a new version.
There are often migration actions from IBM having to do with /etc/ssh 
configuration settings.  When moving releases you would at minimum want to 
review any changes that you made from the IBM /samples and the new /samples and 
merge those as appropriate.

BTW: Here's a quick start guide that we have on customizing IBM z/OS
OpenSSH:
https://dovetail.com/docs/pt-quick-inst/index.html

Kirk Wolf
http://dovetail.com

On Wed, Jul 22, 2020 at 2:14 PM Roberto Halais 
wrote:

> Listers:
>
> My company has decided to forego FTP and go the SFTP way.
>
> I have installed OPENSSH and have SFTP working.
>
> I installed using the IBM user's guide and everything installed in the 
> default libraries.
>
> My concern is, when we migrate to a new z/OS release do I have to do 
> the whole install again?
>
> Can I, from the beginning, install all the SSH libraries in a 
> different filesystem so that when I migrate I can just mount the 
> filesystem and execute.
> And later on install the new version Openssh.
>
> Don't know if I am clear in what I am asking.
>
> Just some tips on facilitating installing under a new release.
>
> Thank you.
>
> --
> 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

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

Re: SFTP and z/OS Migration

[Kirk Wolf]

IBM z/OS OpenSSH is a base feature of z/OS since V2R2.
When you install a new version of z/OS you will get a new version.
There are often migration actions from IBM having to do with /etc/ssh
configuration settings.  When moving releases you would at minimum want to
review any changes that you made from the IBM /samples and the new /samples
and merge those as appropriate.

BTW: Here's a quick start guide that we have on customizing IBM z/OS
OpenSSH:
https://dovetail.com/docs/pt-quick-inst/index.html

Kirk Wolf
http://dovetail.com

On Wed, Jul 22, 2020 at 2:14 PM Roberto Halais 
wrote:

> Listers:
>
> My company has decided to forego FTP and go the SFTP way.
>
> I have installed OPENSSH and have SFTP working.
>
> I installed using the IBM user's guide and everything installed in the
> default libraries.
>
> My concern is, when we migrate to a new z/OS release do I have to do
> the whole install again?
>
> Can I, from the beginning, install all the SSH libraries in a different
> filesystem so that when I migrate I can just mount the filesystem and
> execute.
> And later on install the new version Openssh.
>
> Don't know if I am clear in what I am asking.
>
> Just some tips on facilitating installing under a new release.
>
> Thank you.
>
> --
> 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: SFTP and z/OS Migration

[Shawn Prenevost]

Might be a good idea to have a unique file mount for OPENSSH itself so
could easily do a mount swap to test a new version of OPENSSH without any
zOS implications.

On Wed, Jul 22, 2020 at 1:30 PM Roberto Halais 
wrote:

> Thank you, Allan.
>
> On Wed, Jul 22, 2020 at 3:25 PM Allan Staller 
> wrote:
>
> > OPENSSH is pretty tightly integrated into the /etc file system (separate
> > from the root file system). I have not head of IBM any maint touching
> /etc
> > in a long time.
> >
> > As long as you don’t replace the /etc physical file , you should be fine.
> >
> > HTH,
> >
> > -Original Message-
> > From: IBM Mainframe Discussion List  On Behalf
> > Of Roberto Halais
> > Sent: Wednesday, July 22, 2020 2:14 PM
> > To: IBM-MAIN@LISTSERV.UA.EDU
> > Subject: SFTP and z/OS Migration
> >
> > [CAUTION: This Email is from outside the Organization. Unless you trust
> > the sender, Don’t click links or open attachments as it may be a Phishing
> > email, which can steal your Information and compromise your Computer.]
> >
> > Listers:
> >
> > My company has decided to forego FTP and go the SFTP way.
> >
> > I have installed OPENSSH and have SFTP working.
> >
> > I installed using the IBM user's guide and everything installed in the
> > default libraries.
> >
> > My concern is, when we migrate to a new z/OS release do I have to do the
> > whole install again?
> >
> > Can I, from the beginning, install all the SSH libraries in a different
> > filesystem so that when I migrate I can just mount the filesystem and
> > execute.
> > And later on install the new version Openssh.
> >
> > Don't know if I am clear in what I am asking.
> >
> > Just some tips on facilitating installing under a new release.
> >
> > Thank you.
> >
> > --
> > For IBM-MAIN subscribe / signoff / archive access instructions, send
> email
> > to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> > ::DISCLAIMER::
> > 
> > The contents of this e-mail and any attachment(s) are confidential and
> > intended for the named recipient(s) only. E-mail transmission is not
> > guaranteed to be secure or error-free as information could be
> intercepted,
> > corrupted, lost, destroyed, arrive late or incomplete, or may contain
> > viruses in transmission. The e mail and its contents (with or without
> > referred errors) shall therefore not attach any liability on the
> originator
> > or HCL or its affiliates. Views or opinions, if any, presented in this
> > email are solely those of the author and may not necessarily reflect the
> > views or opinions of HCL or its affiliates. Any form of reproduction,
> > dissemination, copying, disclosure, modification, distribution and / or
> > publication of this message without the prior written consent of
> authorized
> > representative of HCL is strictly prohibited. If you have received this
> > email in error please delete it and notify the sender immediately. Before
> > opening any email and/or attachments, please check them for viruses and
> > other defects.
> > 
> >
> > --
> > For IBM-MAIN subscribe / signoff / archive access instructions,
> > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> >
>
>
> --
> Politics: Poli (many) - tics (blood sucking parasites)
>
> --
> 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: SFTP and z/OS Migration

[Roberto Halais]

Thank you, Allan.

On Wed, Jul 22, 2020 at 3:25 PM Allan Staller  wrote:

> OPENSSH is pretty tightly integrated into the /etc file system (separate
> from the root file system). I have not head of IBM any maint touching /etc
> in a long time.
>
> As long as you don’t replace the /etc physical file , you should be fine.
>
> HTH,
>
> -Original Message-
> From: IBM Mainframe Discussion List  On Behalf
> Of Roberto Halais
> Sent: Wednesday, July 22, 2020 2:14 PM
> To: IBM-MAIN@LISTSERV.UA.EDU
> Subject: SFTP and z/OS Migration
>
> [CAUTION: This Email is from outside the Organization. Unless you trust
> the sender, Don’t click links or open attachments as it may be a Phishing
> email, which can steal your Information and compromise your Computer.]
>
> Listers:
>
> My company has decided to forego FTP and go the SFTP way.
>
> I have installed OPENSSH and have SFTP working.
>
> I installed using the IBM user's guide and everything installed in the
> default libraries.
>
> My concern is, when we migrate to a new z/OS release do I have to do the
> whole install again?
>
> Can I, from the beginning, install all the SSH libraries in a different
> filesystem so that when I migrate I can just mount the filesystem and
> execute.
> And later on install the new version Openssh.
>
> Don't know if I am clear in what I am asking.
>
> Just some tips on facilitating installing under a new release.
>
> Thank you.
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions, send email
> to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
> ::DISCLAIMER::
> 
> The contents of this e-mail and any attachment(s) are confidential and
> intended for the named recipient(s) only. E-mail transmission is not
> guaranteed to be secure or error-free as information could be intercepted,
> corrupted, lost, destroyed, arrive late or incomplete, or may contain
> viruses in transmission. The e mail and its contents (with or without
> referred errors) shall therefore not attach any liability on the originator
> or HCL or its affiliates. Views or opinions, if any, presented in this
> email are solely those of the author and may not necessarily reflect the
> views or opinions of HCL or its affiliates. Any form of reproduction,
> dissemination, copying, disclosure, modification, distribution and / or
> publication of this message without the prior written consent of authorized
> representative of HCL is strictly prohibited. If you have received this
> email in error please delete it and notify the sender immediately. Before
> opening any email and/or attachments, please check them for viruses and
> other defects.
> 
>
> --
> For IBM-MAIN subscribe / signoff / archive access instructions,
> send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
>


-- 
Politics: Poli (many) - tics (blood sucking parasites)

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

Re: SFTP and z/OS Migration

[Allan Staller]

OPENSSH is pretty tightly integrated into the /etc file system (separate from 
the root file system). I have not head of IBM any maint touching /etc in a long 
time.

As long as you don’t replace the /etc physical file , you should be fine.

HTH,

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Roberto Halais
Sent: Wednesday, July 22, 2020 2:14 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: SFTP and z/OS Migration

[CAUTION: This Email is from outside the Organization. Unless you trust the 
sender, Don’t click links or open attachments as it may be a Phishing email, 
which can steal your Information and compromise your Computer.]

Listers:

My company has decided to forego FTP and go the SFTP way.

I have installed OPENSSH and have SFTP working.

I installed using the IBM user's guide and everything installed in the default 
libraries.

My concern is, when we migrate to a new z/OS release do I have to do the whole 
install again?

Can I, from the beginning, install all the SSH libraries in a different 
filesystem so that when I migrate I can just mount the filesystem and execute.
And later on install the new version Openssh.

Don't know if I am clear in what I am asking.

Just some tips on facilitating installing under a new release.

Thank you.

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

The contents of this e-mail and any attachment(s) are confidential and intended 
for the named recipient(s) only. E-mail transmission is not guaranteed to be 
secure or error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or may contain viruses in transmission. 
The e mail and its contents (with or without referred errors) shall therefore 
not attach any liability on the originator or HCL or its affiliates. Views or 
opinions, if any, presented in this email are solely those of the author and 
may not necessarily reflect the views or opinions of HCL or its affiliates. Any 
form of reproduction, dissemination, copying, disclosure, modification, 
distribution and / or publication of this message without the prior written 
consent of authorized representative of HCL is strictly prohibited. If you have 
received this email in error please delete it and notify the sender 
immediately. Before opening any email and/or attachments, please check them for 
viruses and other defects.


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

Re: SFTP and z/OS Migration

[PINION, RICHARD W.]

As others of this list will chime in, please look at www.dovetail.com
for their CoZ product line.  There's the free, with no formal support,
and the chargeable, with formal support.

-Original Message-
From: IBM Mainframe Discussion List  On Behalf Of 
Roberto Halais
Sent: Wednesday, July 22, 2020 3:14 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: SFTP and z/OS Migration

[External Email. Exercise caution when clicking links or opening attachments.]

Listers:

My company has decided to forego FTP and go the SFTP way.

I have installed OPENSSH and have SFTP working.

I installed using the IBM user's guide and everything installed in the default 
libraries.

My concern is, when we migrate to a new z/OS release do I have to do the whole 
install again?

Can I, from the beginning, install all the SSH libraries in a different 
filesystem so that when I migrate I can just mount the filesystem and execute.
And later on install the new version Openssh.

Don't know if I am clear in what I am asking.

Just some tips on facilitating installing under a new release.

Thank you.

--
For IBM-MAIN subscribe / signoff / archive access instructions, send email to 
lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Confidentiality notice: 
This e-mail message, including any attachments, may contain legally privileged 
and/or confidential information. If you are not the intended recipient(s), or 
the employee or agent responsible for delivery of this message to the intended 
recipient(s), you are hereby notified that any dissemination, distribution, or 
copying of this e-mail message is strictly prohibited. If you have received 
this message in error, please immediately notify the sender and delete this 
e-mail message from your computer.


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

Re: SFTP Get

[Rob Schramm]

I wrote a script for a client.. short.. that would source a file to set
variables for sleep time number of tries file it was getting and data said
it was going to eventually end up in.

It worked pretty well.

Rob Schramm

On Thu, Feb 6, 2020, 13:22 Paul Gilmartin <
000433f07816-dmarc-requ...@listserv.ua.edu> wrote:

> On Thu, 6 Feb 2020 09:39:20 -0600, Ron Thomas wrote:
>
> >this is what we use here ,so how is this we need to handle ?
> >
> >//STEP02   EXEC PGM=BPXBATSL,REGION=0M,
> >// PARM='PGM /usr/lpp/ssh2/bin/sftp2
> >// -B //DD:BATCHIN'
> >
> Don't you need a continuation mark in column 72?  Is this copied from
> what you're actually trying?
>
> I'll suggest:
> ...
> //  SET SFTP='/usr/lpp/ssh2/bin/sftp2'
> //STEP02   EXEC PGM=BPXBATSL,REGION=0M,
> // PARM='SH -c '' -B //DD:BATCHIN''; true'
> ...
> >//SYSTSPRT DD  SYSOUT=*
> >//STDOUT   DD  SYSOUT=*
> >//STDENV   DD  DSN=SYS1.TECSSH.PARMLIB(SSHENV),DISP=SHR
> >_BPXK_AUTOCVT=ON
> >_BPX_SHAREAS=NO
> >_BPX_BATCH_UMASK=0022
> >SSH_DEBUG_FMT="%W(72)(2) %Dd/%Dt/%Dy %Dh:%Dm:%Ds:%Df %m/%s:%n:%f %M"
> >_BPXK_JOBLOG=STDERR
> >_EDC_ADD_ERRNO2=1
> >//*
> >//BATCHIN  DD  DSN=J01.MKS.IT057.STORE.FILE.ONE.FTPCNTL,DISP=SHR
>
> -- gil
>
> --
> 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: SFTP Get

[Paul Gilmartin]

On Thu, 6 Feb 2020 09:39:20 -0600, Ron Thomas wrote:

>this is what we use here ,so how is this we need to handle ?
>
>//STEP02   EXEC PGM=BPXBATSL,REGION=0M,
>// PARM='PGM /usr/lpp/ssh2/bin/sftp2
>// -B //DD:BATCHIN'
>
Don't you need a continuation mark in column 72?  Is this copied from
what you're actually trying?

I'll suggest:
...
//  SET SFTP='/usr/lpp/ssh2/bin/sftp2'
//STEP02   EXEC PGM=BPXBATSL,REGION=0M,
// PARM='SH -c '' -B //DD:BATCHIN''; true'
...
>//SYSTSPRT DD  SYSOUT=*
>//STDOUT   DD  SYSOUT=*
>//STDENV   DD  DSN=SYS1.TECSSH.PARMLIB(SSHENV),DISP=SHR
>_BPXK_AUTOCVT=ON
>_BPX_SHAREAS=NO
>_BPX_BATCH_UMASK=0022
>SSH_DEBUG_FMT="%W(72)(2) %Dd/%Dt/%Dy %Dh:%Dm:%Ds:%Df %m/%s:%n:%f %M"
>_BPXK_JOBLOG=STDERR
>_EDC_ADD_ERRNO2=1
>//*
>//BATCHIN  DD  DSN=J01.MKS.IT057.STORE.FILE.ONE.FTPCNTL,DISP=SHR

-- gil

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