• 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:
  • JCl Question

    Can we create two procedure with same name and which will be call 1st?

    950309505 pointsBadges:
  • How to use Timestamp related keywords in DB2 IDDA box

    Hi, I have a Fetch query where I need to get the current timestamp for a particular column. I'm getting -904 error code: due to the usage of 'current timestamp'  keyword in IDDA box accelerator. Is there are any work around for this.

    Rajeshmuthukumar10 pointsBadges:
  • Syspunch with Default value to a column in Load JCL

    Hi, Consider having a unload and load jcl. while loading into the table I like to have a default value for a particular column. Eg. for Column CREATE_TIMESTAMP. I like to have current timestamp to be loaded to the column. current timestamp or timestamp when the load JCL is executing. Can this be...

    Rajeshmuthukumar10 pointsBadges:
  • DB2 Unload and Load JCL using IBM utility

    Hi, Can anyone provide me a JCL to unload and load DB2 tables using IBM utility. I'm new to DB2 and need to unload the Syspunch dataset for a table, as I need to load a the table with data. I just only have the file with the data to be loaded. So I need to get the syspunch file created first and...

    Ari200940 pointsBadges:
  • How to replace the batch query in QMF thru JCL?

    i have one batch query in DBC4MED1.BR211Q_SALEANAL(PRODUCTION).. this batch query is running thru the QMF PROC DBC4MED1.BR211P_SALEANAL to create a report. now i have made changes to the batch query and saved with my HLQ  (PM7351.BR21Q_SALEANAL) in QMF.Now i want to repace the query in...

    PratapMetta5 pointsBadges:
  • JCL analyser tool using REXX

    Is there any REXX tool Which analyses a JCL and gives summary of it,like, description of number of steps in the JCL, what does COND parameters contain in each step, no of DD statements each step contains, how many DSN's used, what is the DISP value for those DSN's, are there any Symbolic...

    Charan13125 pointsBadges:
  • Sending HTML file with record length of 5000 char

    I need to send an email with an HTML file attached from the mainframe via SMTP. Even with adding a DCP (LRECL) parameter, the spreadsheet is truncated to the 1st 1024 characters. How do I fix?

    WLR15 pointsBadges:
  • Sending multiple emails thru one SMTP step

    Hi, I want to send around 40 emails with some data in it to 40 recepients. Can it be done in one jcl step giving a datafile with all the tags for all 40 emails, or do i need to write 40 different SMTP steps? Basically can we include any data termination character?

    Shreeyapai5 pointsBadges:
  • DSNTEP2 output problem

    DSNTEP2 (aka SPUFI in batch) is causing problems for my extract JCL. How do you get rid of the SPUFI-like column headers from the output datafile produced by DSNTEP2? I don't have ANY experience with REXX, so an example would be appreciated. Jon

    Jonty Walker105 pointsBadges:
  • S0C4 ?

    I am copying VSAM file to flat file by using ADUT515 but the job is abending with SOC4 with reason code 10. how to fix this permanently ?

    Madabathula5 pointsBadges:
  • JCL wait command

    I want to submit a job. Imbeded in the JCL I want the WAIT command.  I want to wait till a second job is completed.  I do not know the format of the JCL statment.  I am using /* AFTER next_job_name,WAIT What am I missing? 

    Williewhale5 pointsBadges:
  • 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?

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