LRECL and RECFM for flat file created by VSAM unload I have to Unload a VSAM file to a flat file, I think I can do this using REPRO command of IDCAMS utility, my question is what should be the record length and record format that I should specify for the flat file to which […]
LRECL and RECFM for flat file created by VSAM unload Read More »
How to send email from mainframe? Hi My name is Aakash, and I have recently joined a project on mainframe, my requirement is to send an email from Jcl, if the job executes successfully. Since I am new to the concepts, I am posting this query to your forum. Can someone provide me the JCL
How to send email from mainframe? Read More »
Notifying multiple users using JCL In our system, there are multiple people responsible for monitoring a particular set of jobs, which run in the cycle. I need to have some mechanism of reporting the un-successful finish of a Job to these multiple users. The Notify parameter of the job, as far as I know, it
Notifying multiple users using JCL Read More »
Topic / Topic starter Replies Last post Normal topic LRECL limit of SPUFI output dataset by Anonymous » Wed, 07/06/2011 – 05:58 1 by Anonymous Fri, 01/11/2013 – 22:42 Normal topic Grant with Grant on Views by Anonymous » Thu, 06/23/2011 – 07:58 1 by Anonymous Fri, 01/11/2013 – 22:42 Normal topic DB2 cursor close
Topic / Topic starter Replies Last post Normal topic Cloning a DB2 table by Anonymous » Tue, 11/22/2011 – 06:52 0 by Anonymous Fri, 01/11/2013 – 22:43 Normal topic Db2 question which query will not work by Anonymous » Sat, 07/16/2011 – 16:32 1 by Anonymous Fri, 01/11/2013 – 22:43 Normal topic Subquery used in
Is it possible to submit a JCL in loop? I have a requirement in my project to repeat a particular function carried by a JCL, n number of times each time changing the parameter being passed to the JCL. I think if I could somehow submit the JCL in loop, I would be able to
Is it possible to submit a JCL in loop? Read More »
Instream or Catalog proc in JES spool This is an interview question related to JCL that was asked to me. How would you determine if a particular Proc is instream or catalog proc by looking at the expanded
Instream or Catalog proc in JES spool Read More »
Alternat Index file in VSAM upon loading VSAM file I have a VSAM file which has alternate index defined. Now I am replacing all the data in this file with new data. I am going to use IDCAMS repro for doing this, it should load the data in the VSAM file, but for the alternate
Alternat Index file in VSAM upon loading VSAM file Read More »
Converting date in Julian format to Gregorian format I have a file which has date in Julian format, I need to convert it to Gregorian format, could someone suggest any SORT JCL for doing this real quick. Also if we have some COBOL intrinsic function available for such date conversion please share. “; ; ; ;
Converting date in Julian format to Gregorian format Read More »
send email using SMTPNOTE in mainframe Use the following JCL to send email from mainframe using SMTPNOTE. There are other ways of sending emails as well. Note:- Attachements can’t be send using SMTPNOTE. //STEP01Â Â EXEC PGM=IKJEFT01, //Â Â Â Â Â Â Â Â Â Â Â Â DYNAMNBR=250 //SYSPROCÂ DDÂ DSN=XXX.DSN.ALLOC.TO.SYSPROC, //Â Â Â Â Â Â Â Â Â Â Â Â DISP=SHR //SYSTSINÂ DDÂ * SMTPNOTE + Â Â TO(toemailaddress@example.com)Â Â Â Â Â Â Â + Â Â CC(ccemailaddress@example.com)Â Â Â Â Â Â Â + Â Â
send email using SMTPNOTE in mainframe Read More »
