SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Connecting to DB2 OS/400 |
The naming convention defines how database tables are identified.
DB2® OS/400® can use two kinds of naming conventions:
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.
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.