When translating JCL, a good knowledge of JCL, Z/OS utilities and UNIX/Linux Korn Shell is required.
•
•
• Generated by other Oracle Tuxedo Application Rehosting Workbench tools, the e Oracle Tuxedo Application Rehosting Workbench DB2 to Oracle Converter provides the JCL translator with the list of files to be converted to Oracle tablesIn addition to the AST of the JCL(s) to convert produced by the Oracle Tuxedo Application Rehosting Workbench Cataloger, the Rehosting Workbench JCL Translator takes as input a main configuration file that specifies various aspects of the translation, such as:The main configuration file for the JCL translation is called config-trad-JCL.desc in this guide for use with the Simple Application application.The sub-files specified by the two options top-skeleton and bottom-skeleton represent respectively a header file and a footer file for the generated script. You can customize these files.Listing 7‑2 Example of top-ksh.txt prolog codeThis sub-file is generated by the Oracle Tuxedo Application Rehosting Workbench File-to-Oracle Converter. This file indicates to the JCL Translator, which are the files that will be converted to Oracle tables in order to correctly translate the steps involving these files. In our example PJ01AAA.SS.VSAM.CUSTOMER is the file to be converted.For example, when the JCL source involves files that will be converted to Oracle tables, the corresponding shell script uses the Batch Runtime function m_ProgramExec with the -b option to execute a Cobol program. The -b option indicates a connection to the database must be opened before executing the program. For example:Listing 7‑3 JCL translator configuration file for STFILEORA simple application (config-trad-JCL.desc ):The general options root-skeleton, target-proc, label-end, etc. are described in the JCL Translator section of the Oracle Tuxedo Application Rehosting Workbench Reference Guide.
The following commands can be used to execute the translation. Logs file are generated in $LOGS/trad-jcl.Listing 7‑5 Single JCL translation scriptListing 7‑6 List of JCL translation scriptListing 7‑7 All JCL translation scriptSee Make configuration in the Cataloger user guide