Need help in SFTP & SYSIN



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Need help in SFTP & SYSIN

Postby rajaranganathan » Mon Feb 10, 2014 12:34 pm

Hi All,

I request all your help on an issue that i'm currently struck with,

Am currently doing secure FTP to transfer a file(Mainframe to server), on the which the file name used to change dynamically,
Example file name: PO7485.txt

In this the 4 digit numeric value will change dynamically, hence we generate the file name and place it in to a flat file and used it as SYSIN (Put statement) for my SFTP.
but , the secure FTP is not allowing a flat file to be used as SYSIN , hence it gets abend with JCL Error.

Is there any way i can use my flat file as sysin and get rid of this error ?
rajaranganathan
 
Posts: 27
Joined: Thu Oct 10, 2013 6:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need help in SFTP & SYSIN

Postby BillyBoyo » Mon Feb 10, 2014 12:40 pm

Paste the full sysout from the step, please.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need help in SFTP & SYSIN

Postby rajaranganathan » Mon Feb 10, 2014 3:12 pm

There is no sysout for this paricular step , as this failed due to JCL Error, i have post the SYSMSG for that particular step,
changed the actual job name in to "JOBNAME" and actual file names in to " File.example.input"

JOBNAME STEP020 STEP060 GSYCARDI+002 - REQUEST FAILED BY SUBSYSTEM
===> CONCATENATION CONFLICT WITH LAM FILE File.example.input
JOBNAMESTEP020 STEP060 - STEP WAS NOT EXECUTED.
CONTROLM.JOBNAME .JOB0022.D0000119.? SYSOUT
CONTROLM.JOBNAME .JOB0022.D0000120.? SYSOUT
CONTROLM.JOBNAME .JOB0022.D0000121.? SYSOUT
STEP/STEP020 /START 2014038.2341
STEP/STEP020 /STOP 2014038.2341 CPU 0MIN 00.00SEC SRB 0MIN 00.00S
VOL SER NOS= PSMS02.
SYS1.PROD.BATCH.LOADLIB KEPT
VOL SER NOS= Volume.
JOB/JOBNAME/START 2014038.2341
JOB/JOBNAME/STOP 2014038.2341 CPU 0MIN 00.68SEC SRB 0MIN 00.01S
rajaranganathan
 
Posts: 27
Joined: Thu Oct 10, 2013 6:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need help in SFTP & SYSIN

Postby BillyBoyo » Mon Feb 10, 2014 3:30 pm

OK, so your JCL is,,,? You are using CA-Librarian?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need help in SFTP & SYSIN

Postby rajaranganathan » Mon Feb 10, 2014 3:38 pm

here is my JCL, and what do you mean CA-Librarian ? (you mean production library ? if yes , you are right that we using production library)

XXSTEP020 EXEC PGM=GSY28C,
XX PARM='%RPATH=&RPATH,%UPATH=&UPATH,%PGSYU=&PGSYU&ADPRM1/'
IEFC653I SUBSTITUTION JCL - PGM=GSY28C,PARM='%RPATH=/ftpp/LZinR/MF,%UP
XXSYSOUT   DD SYSOUT=*
XXSYSPRINT DD SYSOUT=*
XXSYSUDUMP DD SYSOUT=&DMP
IEFC653I SUBSTITUTION JCL - SYSOUT=X
XXSTEP020.GSYCARDI DD
X/GSYCARDI DD DSN=&CNTL(GSY61R20),&LIBE
IEFC653I SUBSTITUTION JCL - DSN=SYS1.PRODSYSI.MASTER(SYSIN1),DISP=SH
XX                 DD
X/         DD DSN=&CNTL(GSY61R21),&LIBE
IEFC653I SUBSTITUTION JCL - DSN=SYS1.PRODSYSI.MASTER(SYSIN2),DISP=SH
XX                 DD DSN=File.example.input,
XX             DISP=SHR
IEFC653I SUBSTITUTION JCL - DSN=File.example.input,DISP
X/         DD DSN=&CNTL(&PUTS),&LIBE
IEFC653I SUBSTITUTION JCL - DSN=SYS1.PRODSYSI.MASTER(GSY61R22),DISP=SH
XX                 DD
X/         DD DSN=&CNTL(GSY61R23),&LIBE
IEFC653I SUBSTITUTION JCL - DSN=SYS1.PRODSYSI.MASTER(GSY61R23),DISP=SH
XXGSYCARDO DD DSN=&&FTPFILE,
DISP=(NEW,PASS,DELETE),
UNIT=&TEMP,
SPACE=(TRK,(1,1),RLSE),
DCB=(RECFM=FB,LRECL=80,BLKSIZE=0)
rajaranganathan
 
Posts: 27
Joined: Thu Oct 10, 2013 6:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need help in SFTP & SYSIN

Postby BillyBoyo » Mon Feb 10, 2014 5:15 pm

It looks like SYS1.PRODSYSI.MASTER is managed by CA-Librarian. You will probably get your best results by asking the technical people responsible for this how they would like you to achieve what you need to do. It seems that a simple concatenation will not work as it stands.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Need help in SFTP & SYSIN

Postby Peter_Mann » Mon Feb 10, 2014 9:35 pm

if in fact SYS1.PRODSYSI.MASTER is a LIBRAIAN filesystem and you have the LAM subsystem active, you will need to add a SUBSYS parm to the DD statement
// DSN=SYS1.PRODSYSI.MASTER(GSY61R22),DISP=SHR,SUBSYS=LAM
this may help
Peter
Peter_Mann
 
Posts: 145
Joined: Fri Jun 24, 2011 7:37 pm
Location: Lowell,AR
Has thanked: 15 times
Been thanked: 3 times

Re: Need help in SFTP & SYSIN

Postby Hoe San » Wed Oct 15, 2014 1:04 pm

Hi,

Do we need to code user id and password in the SFTP JCL? FTP we need to code UserID and password.

Thank you.
Hoe San
 
Posts: 4
Joined: Thu Feb 05, 2009 1:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Need help in SFTP & SYSIN

Postby Blackthorn » Wed Oct 15, 2014 2:58 pm

What product are you using for sftp?

We use Co:Z SFTP from Dovetailed Technologies, and generally speaking we generate a ssh key which is sent to the remote server so that a password is not required. It is possible though to specify the password in a file. Check the documentation for your particular product.
Blackthorn
 
Posts: 130
Joined: Tue Feb 01, 2011 7:12 pm
Has thanked: 1 time
Been thanked: 9 times

Re: Need help in SFTP & SYSIN

Postby Hoe San » Wed Oct 15, 2014 4:53 pm

My shop is thinking of using IBM Ported tools Open SSH. Does this tool come free with every zOS installation?
Hoe San
 
Posts: 4
Joined: Thu Feb 05, 2009 1:12 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post