The following is a list of the identifiers that must conform in general to specific naming rules:
For a description of the naming rules, refer to the DB2 Server for VSE & VM SQL Reference manual.
You can access a data object (table, view, dbspace, or package) owned by someone else if you know the owner's authorization-name and have the appropriate DB2 Server for VSE & VM privileges. You need to qualify references to the object by prefixing its name with the owner's authorization-name followed by a period. For example, to access the table called EMPLOYEE which is owned by SMITH, enter SMITH.EMPLOYEE.
When you specify the owner along with an object name, you have fully qualified the object and uniquely identified the table. For example, you cannot have two SMITH.EMPLOYEE tables at the same time.
To avoid confusion and errors, use fully qualified object names. This is especially true if you are coding programs that will be preprocessed by another user.