Identifiers › Expansion of Table-reference

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.

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.

Note: 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.

Note: 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.

Note: 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.

Note: 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

• For more information about defining base tables, see CREATE TABLE, ALTER TABLE and DROP TABLE.
• For more information about defining temporary tables, see CREATE TEMPORARY TABLE.
• For more information about defining procedures, see CREATE PROCEDURE and Defining and Using Procedures.
• For more information about defining table procedures, see CREATE TABLE PROCEDURE and Defining and Using Table Procedures.
• For more information about defining views, see CREATE VIEW and DROP VIEW.
• For more information about establishing a current schema, see SET SESSION.