![]() |
![]() |
![]() |
![]() |
![]() |
It is not the purpose of this document to describe z/OS JCL, for any explanation of JCL statements, please see the z/OS Internet Library.
Table 2‑1 JCL Card Equivalences m_FileAssign -e m_JobBegin -c (with TuxJES). m_JobBegin -p (with TuxJES). m_JobBegin -t (with TuxJES)
Table 2‑2 DCB Parameter of DD Statement
Table 2‑3 SYSOUT Parameter of DD Statement A deferred step restart of a job is caused by coding the function m_JobBegin with the -r parameter containing a job step and by submiting the job again.The concatenation of files (or in-stream files) is supported using the m_FileAssign function with the -C parameter.Use the m_UtilityExec function in order to execute commands stored in a file.
Table 2‑4 Supported Parameters Captures terminations abnormally or normally from user program. It provides three COBOL programs, ILBOABN0, CEE3ABD and ART3ABD, which can be called in specific conditions to ABEND the program by itself. When the ABEND routine calls stop run, stop run terminates the process after Batch Runtime performs necessary cleanup.abcode: the ABEND code.
• CEE3ABD abcode, clean-upabcode: the ABEND code.1: Issue the ABEND. Batch Runtime will capture ABEND and store a system dump in a file, then do clean-up work. Job failed.abcode: the ABEND code.
Note: For Micro Focus COBOL, Batch Runtime provides two ABEND-handling routines, ILBOABN0 and ART3ABD, that are called to force ABEND. Micro Focus COBOL provides its own ABEND-handling routine, CEE3ABD. It works as defined by Micro Focus COBOL.
Table 2‑5 General Utility Commands Equivalences
Table 2‑6 Sort Utilities Equivalences
Table 2‑7 ICETOOL Equivalences when using syncsort utility, there are some limitations:
• DFSORT (DATE3) format has no equivalent on syncsort.
• DFSORT statements (outrec, inrec) are not fully suppported in the following situations:
• If a key or a filed definition of an outrec field cut a field constant type, an error shows up (MT_ERROR in SYSIN translation) and :#PHX in ksh.
•
Table 2‑8 DB2 Utilities On mainframe, DSNTIAUL program is used to unload data from DB2 tables into sequential data sets. The data is copied to the data sets and is not deleted from the table.To unload data from Oracle Database tables, Batch runtime provides you DSNTIAUL utility, which has the same functionality as DSNTIAUL program on mainframe with DB2.
Table 2‑9 Supported Data Types
Note: Only supports the default format "YYYY-MM-DD-HH24.MI.SS.FF6".
Note: Only supports the default format "HH24.MI.SS".
Note: Only supports the default format "YYYY-MM-DD".
• When applying equivalent SQL functions in select statement for the same database table column, the data type that Batch runtime DSNTIAUL outputs for Oracle Database may be different from the data type that mainframe DSNTIAUL outputs for DB2.
• For real, Float(n) (1<=n<=21), Float(n) (22<=n<=53), and Double data types in DB2, they are converted to BINARY_DOUBLE data type (with eight bytes) in Oracle Database. You can retrieve the field in target file to COMP-2 variable in COBOL program by using Micro Focus COBOL (COBOL-IT COBOL may produce incorrect results).For more information, see Setting Environment Variables in Oracle Tuxedo Application Runtime for Batch User Guide.To enable it, you can either use export MT_DB_SQL_PREPROCESS="${JESDIR}/tools/sql/oracle/BatchSQLConverter.sh" or configure MT_DB_SQL_PREPROCESS in $JESDIR/ejr/CONF/BatchRT.conf.
3. Configure MT_DSNTIAUL=Y.The default value of MT_DSNTIAUL is "Y". For more information, see Setting Environment Variables in Oracle Tuxedo Application Runtime for Batch User Guide.
4.
• Environment "DSNTIAUL_DATE_FORMAT" defines date format. If it is not set, use the default value "YYYY-MM-dd HH24:MI:SS".
• Environment "DSNTIAUL_TIMESTAMP_FORMAT" defines timestamp format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
• Environment "DSNTIAUL_TIMESTAMP_TZ_FORMAT" defines timestamp with time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
• Environment "DSNTIAUL_TIMESTAMP_LTZ_FORMAT" defines timestamp with local time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".On mainframe, DSNUTILB specifies a utility control program. Batch runtime provides you DSNUTILB utility to unload data from Oracle tables into a variable-length sequential data set and load data from a sequential data set to Oracle table.
•
• Environment "DSNUTILB_DATE_FORMAT" defines date format. If it is not set, use the default value "YYYY-MM-dd HH24:MI:SS".
• Environment "DSNUTILB_TIMESTAMP_FORMAT" defines timestamp format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
• Environment "DSNUTILB_TIMESTAMP_TZ_FORMAT" defines timestamp with time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
• Environment "DSNUTILB_TIMESTAMP_LTZ_FORMAT" defines timestamp with local time zone format. If it is not set, use the default value "YYYY-MM-DD-HH24.MI.SS.FF6".
• Set DSNUTILB_CLEAN_TABLE.
• Environment "DSNUTILB_CLEAN_TABLE" chooses the way to delete records in a table when REPLACE option is set for load process in DSNUTILB. Valid values are 1, 2, and 3. If it is not set or set incorrectly, use the default value 1.
• 1: Use stored procedure. Batch runtime provides SQL script $JESDIR/util/DSNUTILBPKG.sql to create DSNUTILB_PKG package, which contains a procedure to truncate specific table.
• 2: Use statement truncate.
• 3: Use statement DELETE.A COBOL runtime, runb, is provided to initialize the execution context of a user COBOL program before the call for its execution. This runtime is used instead of the standard COBOL runtime.
• Initialization: The runtime command, runb, connects it to the database according to the MT_DB_LOGIN environment variable . It must have the correct value (user name, password and Oracle instance, at least "/"). It can be used in the TuxJES Security Configuration file and specified when submitting jobs or set as an environment variable. If the configuration file is not specified, the environment variable MT_DB_LOGIN value is used.
• Termination: Depending on the program return code, the Batch Runtime executes a COMMIT (if program return code is less than MT_PROG_RC_ABORT) or a ROLLBACK (if program return code is greater than or equal to MT_PROG_RC_ABORT), then disconnects from the database.
• On mainframe, svc99() is a function that provides access to SVC99 on z/OS, which provides ability toThis table shows elements contained by __S99parms.
Table 2‑10 __S99parms Elements Listing 2‑1 Data Type Definition in C Programunsigned char __S99RBLN; /* Length of the request block */unsigned char __S99VERB; /* Action verb */unsigned short __S99FLAG1; /* Flags 1 field */unsigned short __S99ERROR; /* Error Code */unsigned short __S99INFO; /* Info Code */struct S99TU** __S99TXTPP; /* Pointer to text pointer array */void ** __S99S99X; / * Pointer to the Request Extension Block */unsigned int __S99FLAG2; /* FLags 2 field for APF authorized programs */Listing 2‑2 Data Type Definition in COBOL Program03 s99rb-s99tu-array-ptr pointer.
Table 2‑11 Return Code
Table 2‑12 Error Code
Table 2‑13 Verb Code
Table 2‑14 Text Units Text unit key. The key identifies the type of information contained in the text unit. Number. The number field contains the number of length-data pairs that follow. Most of the text units have only one length and one data field. Length. The first of perhaps many length fields. The length value includes only the length of the data field immediately following it. Data. The first of perhaps many data fields. The data field contains the parameter information being passed. Listing 2‑3 Data Type Definition in C Programunsigned short key; /* Key for type of parameter */unsigned short number; /* Number of len/parm pairs to follow */unsigned short len; /* Length of the following parm */char parm[MAXTULEN]; /* Parameter value */Listing 2‑4 Data Type Definition in COBOL Program03 tu-ptr-xxx pointer.03 ws-aldsn-TU-xxx-key pic 9(4) comp-5.03 ws-aldsn-TU-xxx-num pic 9(4) comp-5.03 ws-aldsn-TU-xxx-ent-len pic 9(4) comp-5.03 ws-aldsn-TU-xxx-ent-txt pic x(80).set s99rb-s99tu-array-ptr to address of tu-ptr-list.
Table 2‑15 Text Units for Dsname Allocation Function