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