Missing tables and procedures for RPG - 1.0

Compatibility: v2 v3 Express
What's new? Release Notes
ID: com.castsoftware.rpg.missingtable

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.

Supported client languages

Language Supported?
RPG ✅

Transactions

Transaction support is derived from metamodel concepts used to build CAST Imaging Blueprint and structural transaction flows. Entry Points start transactions; Exit Points include both output/boundary concepts and Data Entities manipulated by transactions.

Role Support Breakdown
Entry Point No direct concept type details
Exit Point
  • Procedure
Data Entity with Accurate FP
  • Table
Data Entities
  • SQL Table - Unresolved

Data version: 1.0.6-funcrel

ISO 5055 Structural Rules

Quality support is based on ISO 5055 structural rules available for the selected extension version.

Reliability Maintainability Security Performance Efficiency

Data version: 1.0.6-funcrel

Prerequisites

Item Description
✅ An installation of any compatible release of CAST Core (see table above)
✅ An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.11-funcrel). Embedded tables were introduced in version 3.8.0-funcrel and system table in 3.8.1-funcrel.

Download and installation instructions

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

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
Embedded Schema Parent of the embedded tables, attached to the RPG Project. CAST_CL400_EmbeddedTable_Schema
CAST_RPG300_RPG400_EmbeddedTable_Schema
Embedded Table A table created/dropped/altered/replaced/renamed/declared in a RPG Query missing from the DDL file. CAST_CL400_EmbeddedTable_Table
CAST_RPG300_RPG400_EmbeddedTable_Table
System Schema Parent of the system tables, attached to the RPG Project. CAST_CL400_SystemTable_Schema
CAST_RPG300_RPG400_SystemTable_Schema
System Table A system table or a system view selected/updated/deleted/inserted in a RPG Query missing from the DDL file. CAST_CL400_SystemTable_Table
CAST_RPG300_RPG400_SystemTable_Table
SQL System Table A system table or a system view selected/updated/deleted/inserted in a RPG Query missing from the DDL file, but we have a SQL Schema, and only one. SQLScript_System_Table

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 Embedded Table / Missing Table / System Table / SQL Missing Table / SQL System Table
  • call from RPG Query to Missing Procedure/SQL Missing Procedure
  • ddl/ddlCreate/ddlDrop/ddlAlter/ddlReplace from RPG Query to Embedded Table