• DB2 table load JCL with current timestamp

    Hi I need load the data from the flat file to db2 table by dsnuproc (mainframe ) utility my file dont have the timestamp value but the cloum in the table col2 declared as timestamp not nulll caould you please help how do load current timestamp.Thanks in advance Regards Manju

    Manju25 pointsBadges:
  • Running Multiple SQL statements through JCL

    I need to run multiple sql statements seperatd by ';'. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?

    Vmfquest5 pointsBadges:
  • Using an ampersand in JCL

    Does anyone know how to handle 2 &'s together in a JCL ?? I mean in my jcl after replacement of my variables, it is coming like '&&'. No errors on jj but run time error 'Incorrect use of ampersand' !! Please reply asap, urgent requirement. Thanks!!

    Ankurshankdhar15 pointsBadges:
  • Rexx program working abnormally sometimes when executed through JCL

    I have a Rexx program to browse a very big dataset(say 75,000 lines) and then add 1 or 2 lines then save and end. This is working fine in online or batch execution provided dataset has only few records. However it works fine for all if running in ISPF panel itself, but through jcl execution for...

    Rexxloop5 pointsBadges:
  • Attaching Mainframe dataset to email

    How smtp e-mail from jcl with print image files attached

    Bandit9115 pointsBadges:
  • Need help on SMTP utility in JCL

    I need to send a mail through SMTP utility along with a dataset of record lenght 275 as attacchment, Is that possible can you provide example.

    SasikumarNew5 pointsBadges:
  • extrapartition TDQ in batch mode

    Can anyone please let me know ( along with some code/JCL snippets) how to load a sequential file in a extrapartition TDQ.

    RiteshCP5 pointsBadges:
  • Can I access CICS from batch JCL jobs?

    Can I access CICS from batch JCL jobs?

  • NDM Pull

    Provide me JCL & Control card to pull a file from server to Mainframe

    TSPMBR5 pointsBadges:
  • 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...

    ITKE392,005 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:

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