Naming Conventions

The naming convention defines how database tables are identified.

DB2® OS/400® can use two kinds of naming conventions:

• The *SQL naming convention.

  The table has to be qualified with the name of the collection (schema) which must be the same name as the user connected to the database. All tables have to be in the same database.

• The *SYS naming convention.

  If a table is unqualified, it will be searched for in the *CURLIB collection. You can change the library list with the ADDLIBLE command. You may create a small CL program attached to the profile that will change the library list on sign on. You can also globally change the user portion of the library list using the QUSRLIBL system variable, but this would affect all users on the system.