CAST AIP 8.2.x Documentation
Page tree
Skip to end of metadata
Go to start of metadata

Links detected and saved by the analyzer

Link Type When is this type of link created ?
CALL

When:

  • a trigger, view, function, or procedure calls a function.

  • a procedure calls another procedure.

DDL
  • Create
  • Drop

DDL Create example:

CREATE PROCEDURE SP_CreateTable_Table0001
()
MODIFIES SQL DATA
NOT DETERMINISTIC
CALLED ON NULL INPUT
LANGUAGE SQL

P1: BEGIN

Declare Error int default 0;
CREATE Table Table0001 ( ID CHARACTER(4), Qty INTEGER);
return Error;

END P1

DDL Drop example:

CREATE PROCEDURE SP_DDL_DropTable_Table0001
()
MODIFIES SQL DATA
NOT DETERMINISTIC
CALLED ON NULL INPUT
LANGUAGE SQL

P1: BEGIN

Declare Error int default 0;
DROP Table Table0001;
return Error;

END P1
FIRE
  • Insert
  • Update
  • Delete
  • Select
  • Before
  • After
  • For Each Row
  • For All Row
When a table or view fires a trigger before or after the table or view is modified (for each row / for all rows).
INHERIT

When:

    • a structured type inherits fields and methods from another structured type.
    • a table inherits columns from another table.
    • a view inherits columns from another view.
LOCKWhen a procedure contains a LOCK type instruction on a table. The "lock" on the table is removed by a new LOCK, a COMMIT or a ROLLBACK.
PROTOTYPEWhen an alias is the prototype of a table or view.
REFERWhen a referential "delete" or "update" link exists between two tables.
RELY ON

When:

    • an index organizes data in a table
    • a table is based on a structured type
    • a column in a table, view, alias or nickname is characterized by a distinct or structured UDT
    • a column in a table, view, alias or nickname is a reference on a structured UDT.
    • a parameter in a function or procedure is characterized by distinct or structured UDT.
    • a trigger, procedure, view or function handles a distinct or structured UDT.
USE
  • Insert
  • Update
  • Delete
  • Select

When:

  • a trigger or a procedure contains a DML INSERT, UPDATE, DELETE, or SELECT INTO instruction that handles a table, a view an alias or a nickname.
  • a table is based on a structured type and is linked to a hierarchical table.
  • No labels