Knowledge Article View - Customer Support

Accessing a DB2 table using the LIBNAME engine via SAS^® running in a z/OS operating environment might result in the table being qualified even though the AUTHID= LIBNAME or data set option were not specified.

This behavior is different from other SAS/ACCESS^® products. If AUTHID= is not specified, one of the following is used as the authorization ID when the table is referenced in the code submitted to the database:

The user ID specified by the CURRENT SQLID= value set in the DBCONINIT LIBNAME option
The user ID specified in the USER= LIBNAME option
The TSO ID under which the process is running

However, currently, this is not the behavior that is stated in documentation, which says the following:

If you do not specify a value for AUTHID=, the table name is not qualified before it is passed to the database management system.

To turn off this automatic qualifying of the table, specify AUTHID='' in the LIBNAME statement.

DB2 objects might be automatically qualified even though the AUTHID= LIBNAME or data set options were not specified