SQL (*SQL) naming convention

 

When you use the SQL naming convention, tables are qualified by the collection name in the form collection.table.

If the table name is not explicitly qualified and the default collection name is specified in the default relational database collection (DFTRDBCOL) parameter of the CRTSQLxxx or Create Structured Query Language Package (CRTSQLPKG) command, the default collection name is used. If the table name is not explicitly qualified and the default collection name is not specified, the following rules apply:

• For static SQL, the default qualifier is the user profile of the program owner.

• For dynamic SQL or interactive SQL, the default qualifier is the user profile of the job running the statement.

 

Parent topic:

Naming of distributed relational database objects

 

Related reference

Create Structured Query Language Package (CRTSQLPKG) command