• Need help executing MULTIPLE SQL extracts from a JCL

    GREYBEARD52: Thanks again for the info, BUT I'm not sure if a CL command can be used with a JCL. Can it? ALSO, my JCL uses the SELECT command, so it appears that the RUNSQLSTM command won't help - it doesn't support SELECT. Are there ANY OTHER ALTERNATIVES or a way to tweek this command to 1. Run...

    Jonty Walker105 pointsBadges:
  • How to add the date in the file name in JCL

    need to create a JCL which runs every month end and create a file with name which has the current date in it

    Vicky115 pointsBadges:
  • MVS JCL Return-code

    How do I pass pass a return-code of 4 back to MVS JCL?

    Daniel565 pointsBadges:
  • compare Flat files using sort

    I need to compare two files after stripping a record field, to validate that all other field values are same after replacing a specific field value . file1 :1111222223333377771111 file 2:1111222224444477771111 Iin file 1 , records 33333 has been changed to 444444. I need to compare all other...

    Ari200940 pointsBadges:
  • Pause/Wait + JCL z/0s

    Is there a way to pause ZOS between each step of a job? If we had JES3 installed, I would use //**PAUSE, but we don't. My job has six commands I want to automate. F PCICST01, CEMT S TE(????)OUT, and 5 more, where ???? is the LU code needed. If I understand ZOS, it may or may not process the 6...

    ITKE62,320 pointsBadges:
  • QA testing mainframe code

    I have 3500 members in my loadlib and a set of scripts to test this code. However i do not know what sort of code coverage i am achieving with these scripts. Is there a way to monitor which members from the loadlib are being executed by my test scripts? Note my JCL always executes the same program...

    QAtester5 pointsBadges:
  • DB2 Select on a large number of rows/

    I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the records I want to select for...

    Michaelf215 pointsBadges:
  • Printing Documents

    I am printing documents that I have designed in DOC1. The data comes from COBOL programs that I have written that gather information from DB2. The pages are not printing in the center of the page, so it is cutting off some information at the bottom and the right. I got a lead that this is due to...

    Skmcm40 pointsBadges:
  • jcl spool command

    which spool command is used to release a job with hold option

    Sravs5 pointsBadges:
  • JCL transfer from one data set to other

    Hi, I'm looking for CA-7 batch job JCL to transfer or copy members from one data set to other. I need to to move more than 1000 of them and can't do it throught TSO for security reason. Thank you in advance

    IT095 pointsBadges:
  • IKJEFT01 job giving SYSTEM COMPLETION CODE=0C4 REASON CODE=00000011

    One of my job is trying to search the reagions which are holding a file and run this step //PSTY0020 EXEC PGM=IKJEFT01,DYNAMNBR=8, // PARM=('%ISFSCAN,&INS..PO.STDATM.JOURNAL', // 'DD(2&DD),NONCICSABORT') //SYSPROC DD DSN=CSG.CTLCARD,DISP=SHR //SYSTSIN DD DUMMY //SYSTSPRT DD SYSOUT=* //SYSOUT DD...

    Saurabhgargava5 pointsBadges:
  • Mainframe batch DB2 table I-O monitoring

    Dear Sir or Madam: I can examine the excp counts for flat, VSAM, IMS files in the JCL batch JES JOB Log statistics, both while executing & when job has completed. How do you monitor that I/O for DB2 tables? Thank you, Michael Piccolo

    Pic40 pointsBadges:
  • CAVIEW mainframe-JCL convert to PROC-issues

    We have CAVIEW on the mainframe, sequential files containing report data are sent to CAVIEW via the mainframe utility IEBGENER at the ends of jobs that produce reports. This system DID have straight JCL - we converted to JCL-and-cataloged PROCEDURE (PROC). The filename into CAVIEW, the CAVIEW...

    Gypsymorgan5 pointsBadges:
  • use of ftp for multiple files

    I need to process a JOB in mainframe FROM CONTROL_M with FTP sending multiple files from HOST to a user server. The problem is that I need a name different that the original coming from host, even without ' . The execution ( IT'S ONLY A PROOF JCL ): +++++++++++++++ //PTCFTPES JOB...

    Ptc636310 pointsBadges:
  • Making OMIT command inactive after a some count

    I have to write a JCL step in which I have to copy a file in to another file after omitting ONLY 5 records in which starting 4 position are having character 1644. Can you please help? Thanks in advance, Sushant Sharma

    VisionPlus5 pointsBadges:
  • Sending email with SMTP thru JCL

    I'm trying to use SMTP to send emails using IBM JCL (IEBGENER). This is the JCL I'm using.I'm getting INVALID COMMAND errors on the SYSIN commands. Help. //VS90033Y JOB (1,6893215,FPN-800),'CMMS',MSGCLASS=V,USER=VS90033 //**************************************************************** /**MAIN...

    Ldonoho15 pointsBadges:
  • How to submit a JCL through VB Script?

    i have a jcl to submit into mainframe without logging into mainframe. I have write a script but unable to submit the jcl into mainframe from that script. Can anyone please help me out? I really appricate your write.

    Ankitgupta5 pointsBadges:
  • Need help with FILEAID in BATCH

    I'm new to FILEAID, so I'd be grateful for some sage guidance on FILEAID command syntax's and statement for use in a JCL. My problem is that Ihave a datafile which appears be a VB file type with a leading 2 character string ahead of my data. I'm trying (desperately) to create a work-around in order...

    Jonty Walker105 pointsBadges:
  • Unloading specific records in a foreign key, cascade format.

    Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I would like the...

    Donnaw5 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following