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 8‑2 Example of top-ksh.txt Prolog CodeWhen files are converted to Oracle tables, the main configuration file must reference a sub-configuration file such as:This 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 8‑3 JCL Translator Configuration File for STFILEORA Simple Application (config-trad-JCL.desc ):Listing 8‑4 Launcher Entry in Main Configuration FileListing 8‑5 Example of Launcher CodeThe 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 8‑7 Single JCL Translation ScriptListing 8‑8 List of JCL Translation ScriptListing 8‑9 All JCL Translation ScriptTo illustrate post-translation usage the following example add a comment after line containing m_ProgramExec IEFBR14 "" in the /prtvcust.ksh JCL script.
1. Write the following rule in renov-jcl.desc:To translate all the JCL in the $SOURCE file systemFrom the $SOURCE directory launch the command: