Extension ID
com.castsoftware.RPG.missingtable
What's new?
Please see Missing tables and procedures for RPG - 1.0 - Release Notes for more information.
Description
This extension is designed to analyze SQL queries embedded in RPG code and create "missing" SQL and RPG 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 RPG code, even if none or only part of the referenced SQL objects are delivered for analysis.
| AIP Core release | Supported |
|---|---|
| 8.3.x |  |
Supported DBMS servers
DBMS | Supported? |
|---|---|
| CAST Storage Service / PostgreSQL | |
Supported client languages
| Language | Supported? |
|---|---|
RPG | |
Prerequisites
| An installation of any compatible release of AIP Core (see table above) |
| An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.11-funcrel) |
Download and installation instructions
The extension will be automatically downloaded and installed in CAST Console when RPG source code is delivered for analysis.
What results can you expect?
Objects
| Icon | Object Type | Description | Metamodel Type |
|---|---|---|---|
| Missing Schema | Parent of the missing tables and procedures, attached to the RPG Project. | CAST_CL400_MissingTable_Schema CAST_RPG300_RPG400_MissingTable_Schema |
| Missing Table | A table or a view selected/updated/deleted/inserted in a RPG Query missing from the DDL file. | CAST_CL400_MissingTable_Table CAST_RPG300_RPG400_MissingTable_Table |
| Missing Procedure | A procedure or a function called in a RPG Query missing from the DDL file. | CAST_CL400_MissingTable_Procedure CAST_RPG300_RPG400_MissingTable_Procedure |
| SQL Missing Table | A table or a view selected/updated/deleted/inserted in a RPG Query missing from the DDL file, but we have a SQL Schema, and only one. | SQLScript_Missing_Table |
| SQL Missing Procedure | A procedure or a function called in a RPG Query missing from the DDL file but we have a SQL Schema, and only one. | SQLScript_Missing_Procedure |
Links
Links are created for transaction and function point needs. You can expect the following links on the RPG Embedded SQL queries:
- useSelect/useUpdate/useDelete/useInsert from RPG Query to Missing Table/SQL Missing Table
- call from RPG Query to Missing Procedure/SQL Missing Procedure
