Expansion of Table-name

The expanded parameters of table-name represent qualified or unqualified tables, views, procedures, or table procedure identifiers in an SQL statement.
idmscu
The expanded parameters of table-name represent qualified or unqualified tables, views, procedures, or table procedure identifiers in an SQL statement.
Syntax
Expansion of table-name
►►──┬────────────────┬─┬─ 
table-identifier
 ────────────┬──────────────────────►◄     └─ 
schema-name
. ─┘ ├─ 
view-identifier
 ─────────────┤                        ├─ 
procedure-identifier
 ────────┤                        └─ 
table-procedure-identifier
 ──┘
Parameters
  • schema-name
    Specifies the schema with which the table, view, procedure, or table procedure identified by table-identifier, view-identifier, procedure-identifier or table-procedure-identifier is associated.
    For more information about using a schema name to qualify a table, view, procedure, or table procedure 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-identifier
    Identifies a procedure defined in the dictionary.
  • table-procedure-identifier
    Identifies a table procedure defined in the dictionary.
Examples
A Qualified Table Identifier
In the following INSERT statement, the table name is a qualified table identifier:
insert into demoempl.employee values (1,'John', 'Smith');
An Unqualified Table Identifier
In the following INSERT statement, the table name 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.
insert into employee values (1,'John', 'Smith');
More Information