System (*SYS) naming convention

 

When you use the system naming convention, files are qualified by library name in the form library/file.

Tables created using this naming convention assume the public authority of the library in which they are created. If the table name is not explicitly qualified and a default collection name is used in the DFTRDBCOL parameter of the CRTSQLxxx or CRTSQLPKG command, the default collection name is used for static SQL statements. If the file name is not explicitly qualified and the default collection name is not specified, the following rules apply:

• All SQL statements except certain CREATE statements cause SQL to search the library list (*LIBL) for the unqualified file.

• The CREATE statements resolve to unqualified objects as follows:

  • CREATE TABLE: The table name must be explicitly qualified.

  • CREATE VIEW: The view is created in the first library referred to in the subselect.

  • CREATE INDEX: The index is created in the collection or library that contains the table on which the index is being built.

 

Parent topic:

Naming of distributed relational database objects