This documentation is not maintained. Please refer to doc.castsoftware.com/technologies to find the latest updates.

Extension ID

com.castsoftware.mainframe.missingtable

What's new?

Please see Missing tables and procedures for Mainframe - 1.0 - Release Notes for more information.

Description

This extension is designed to analyze SQL queries embedded in JCL / Cobol code and create "missing" SQL and JCL / Cobol table / procedure objects to represent SQL objects that have not been delivered for analysis. Links to these objects are also created. The primary goal of the extension is to ensure that a full transaction is identified by CAST, resulting from the SQL queries embedded in the JCL code, even if none or only part of the referenced SQL objects are delivered for analysis.

AIP Core compatibility

This extension is compatible with:

AIP Core releaseSupported
8.3.x(tick)

Supported DBMS servers

DBMS

Supported?

CAST Storage Service / PostgreSQL(tick)

Supported client languages

LanguageSupported?

Mainframe

(tick)

Prerequisites

(tick)An installation of any compatible release of AIP Core (see table above)
(tick)An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.9-funcrel)

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when Mainframe source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

IconObject TypeDescriptionMetamodel Type

Missing Schema

Parent of the missing tables and procedures, attached to the JCL /Cobol Project.

CAST_JCL_MissingTable_Schema

CAST_Cobol_MissingTable_Schema

Missing TableA table or a view selected/updated/deleted/inserted in a JCL / Cobol Query missing from the DDL file.

CAST_JCL_MissingTable_Table

CAST_Cobol_MissingTable_Table

Missing ProcedureA procedure or a function called in a JCL / Cobol Query missing from the DDL file.

CAST_JCL_MissingTable_Procedure

CAST_Cobol_MissingTable_Procedure

SQL Missing TableA table or a view selected/updated/deleted/inserted in a JCL / Cobol Query missing from the DDL file, but we have a SQL Schema, and only one.SQLScript_Missing_Table

SQL Missing ProcedureA procedure or a function called in a JCL / Cobol Query missing from the DDL file but we have a SQL Schema, and only one.SQLScript_Missing_Procedure

Links are created for transaction and function point needs. You can expect the following links on the JCL / Cobol Embedded SQL queries:

  • useSelect/useUpdate/useDelete/useInsert from JCL / Cobol Query  to Missing Table/SQL Missing Table
  • call from JCL / Cobol Query to Missing Procedure/SQL Missing Procedure