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?
Answer Question
| February 28, 2012 8:27 PM
Excel 2007, JCL, SMTP
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?
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 Parameters used in the JCL, [...]
Answer Question
| March 31, 2012 5:29 AM
JCL, REXX, REXX Procedure, REXX tool
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 Parameters used in the JCL, [...]
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 DBC4MED1.BR211Q_SALEANAL with the modified query which was there in my HLQ [...]
Answer Question
| March 31, 2012 5:56 AM
AS/400 batch jobs, JCL, Mainframe jobs( JCL, QMF, QMF Objects
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 DBC4MED1.BR211Q_SALEANAL with the modified query which was there in my HLQ [...]
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 ?
Answer Question
| July 21, 2011 10:15 AM
COBOL, JCL, VSAM
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 ?
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?
Answer Question
| May 5, 2011 6:06 PM
IBM Mainframe, JCL, JCL wait, Mainframe
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?
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?
Answer Question
| January 13, 2011 11:05 PM
DB2 SQL, JCL, SQL error messages, SQL Server, SQL statements
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?
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
Answer Question
| January 13, 2011 5:56 AM
AS/400 flat file, DB2, DB2 Table, JCL
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
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!!
Answer Question
| November 22, 2010 2:00 PM
Date in JCL, JCL, Job Control Language, Programming Languages
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!!
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 [...]
Answer Question
| October 8, 2010 12:07 PM
Datasets, JCL, REXX, REXX Mainframe, REXX Procedure
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 [...]
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?
Answer Question
| December 9, 2011 3:55 PM
Data File Utility, JCL, SMTP, SMTP Email Address
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?
Attaching Mainframe dataset to email
How smtp e-mail from jcl with print image files attached
Answer Question
| August 4, 2010 4:55 PM
JCL, Mainframe, SMTP, SMTP Email Address
How smtp e-mail from jcl with print image files attached
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.
Answer Question
| June 10, 2010 10:22 AM
CICS, JCL, Mainframe, TDQ
Can anyone please let me know ( along with some code/JCL snippets) how to load a sequential file in a extrapartition TDQ.
NDM Pull
Provide me JCL & Control card to pull a file from server to Mainframe
Answer Question
| April 9, 2010 11:07 AM
Control Card, JCL, Job Control Language, Mainframe, NDM, PULL, Scripting languages
Provide me JCL & Control card to pull a file from server to Mainframe
Can I access CICS from batch JCL jobs?
Can I access CICS from batch JCL jobs?
Answer Question
| May 18, 2010 7:24 PM
CICS, JCL
Can I access CICS from batch JCL jobs?
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.
Answer Question
| July 23, 2010 10:55 AM
JCL, SMTP
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.
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 [...]
Answer Question
| April 19, 2013 2:47 AM
DB2, IBM Mainframe, JCL
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 [...]
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 records in the two file fileds and [...]
Answer Question
| December 16, 2009 6:16 PM
File, JCL, JOIN KEY, Mainframe, 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 records in the two file fileds and [...]
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 [...]
Answer Question
| October 13, 2009 2:44 PM
JCL, z/OS
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 [...]
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
Answer Question
| July 31, 2009 7:58 PM
Batch jobs, CA-7, JCL
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
MVS JCL Return-code
How do I pass pass a return-code of 4 back to MVS JCL?
Answer Question
| January 27, 2010 8:02 PM
JCL, MVS
How do I pass pass a return-code of 4 back to MVS JCL?





