NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
Does Enterprise Analyzer(EA) support analysis of Pro*COBOL code?
Oracle provides a COBOL pre-compiler for their SQL engine called Pro*COBOL. The programs that are processed by Pro*COBOL contain embedded SQL statements that will be expanded to COBOL calls by Pro*COBOL. It is far better to be able to load the programs before they have been through Pro*COBOL as this then allows you to perform analysis on the SQL statements and the original COBOL code.
EA is setup to be able to process SQL statements embedded inside COBOL and PL/I programs and will process Oracle SQL that is used in either of these languages. There are a number of clipper queries that have been setup that can be used.
These can be used to assit with:
Before adding Pro*COBOL programs to a workspace there are a number of Workspace and Project options that should be turned ON to improve the analysis of SQL code. In that case, EA may have to be re-configured to enable SQL support. If changes are required to the configuration of EA, then all the workspaces will need to upgraded before they can be used.
As Oracle is available for a number of different environments, the Cobol dialect can be mainframe or one of the distributed environments, so the COBOL dialect can be any of the dialects including Cobol/390, Enterprise Cobol and Micro Focus.
Stored Procedures and Packages should be placed into .sql files and are processed as PL/SQL files. Table definitions can also be added to projects; again these would appear in .dcl or .cpy files.
SQL support is built into EA, so Pro*COBOL does not need to be installed on the same machine as EA nor does EA need access to an Oracle database when parsing Pro*COBOL programs or SQL files.
Incident – question came in via the forum