Expansion of Table-reference

The expanded parameters of table-reference represent qualified or unqualified tables, view identifiers, joined tables, or a reference to a procedure or a table procedure in an SQL statement.
idmscu
The expanded parameters of table-reference represent qualified or unqualified tables, view identifiers, joined tables, or a reference to a procedure or a table procedure in an SQL statement.
Syntax
Expansion of table-reference
►►──┬────────────────┬─┬─ 
table-identifier
 ──┬┬───────────────────────────────►◄     ├─ 
schema-name
. ─┘ └─ 
view-identifier
 ───┘│     ├─ 
procedure-reference
 ───────────────────┤     ├─ 
table-procedure-reference
 ─────────────┤     ├─ 
joined-table
 ──────────────────────────┤     └─ 
( joined-table )
 ──────────────────────┘
Parameters
  • schema-name
    Specifies the schema with which the table or view identified by
    table-identifier
    or
    view-identifier
    is associated.
    For more information about using a schema name to qualify a table or view identifier, see Identifying Entities in Schemas.
  • table-identifier
    Identifies either a base table defined in the dictionary or a temporary table defined during the current transaction.
  • view-identifier
    Identifies a view defined in the dictionary.
  • procedure-reference
    Identifies a procedure defined in the dictionary and optionally supplies parameter values to be passed to the procedure.
    For more information about the expansion of
    procedure-reference
    , see Expansion of Procedure-reference.
  • table-procedure-reference
    Identifies a table procedure defined in the dictionary and optionally supplies parameter values to be passed to the table procedure.
    For more information about the expansion of
    table-procedure-reference
    , see Expansion of Table-procedure-reference.
  • joined-table
    Identifies a table that is derived from joining two specified tables.
    For more information about the expansion of
    joined-table
    , see Expansion of Joined-table.
Examples
A Qualified Table Identifier
In the following SELECT statement, the table reference is a qualified table identifier:
select * from demoempl.employee;
An Unqualified Table Identifier
In the following SELECT statement, the table reference is an unqualified table identifier. If no temporary table named EMPLOYEE has been defined during the current transaction, CA IDMS assumes the table is qualified with the current schema in effect for the SQL session.
select * from employee;
Table Procedure Reference with Keyword Parameter Values
In the following SELECT statement, the table reference is a table procedure reference where values are supplied for the EMP_ID and MGR_ID parameters using keyword notation:
select * from org (emp_id=127, mgr_id=7);
More Information