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.

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.

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

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.

More information:

ALTER TABLE

CREATE PROCEDURE

CREATE TABLE

CREATE TEMPORARY TABLE

CREATE VIEW

Defining and Using Table Procedures

DROP TABLE

DROP VIEW

SET SESSION