 |
|
| Macro Variables and System Options for Relational Databases |
DB2CATALOG= System Option
Overrides the default owner of the DB2 catalog tables.
| Default value: | SYSIBM |
| Valid in: | OPTIONS statement |
| Syntax | |
| Syntax Description | |
| Details |
Syntax |
| DB2CATALOG= SYSIBM | catalog-owner |
Syntax Description
- SYSIBM
-
specifies the default catalog owner.
- catalog-owner
-
specifies a different catalog owner from the default.
| Details |
The default value for this option is initialized when SAS is installed. You can override the default only when these conditions are met:
-
SYSIBM cannot be the owner of the catalog that you want to access.
-
Your site must have a shadow catalog of tables (one to which all users have access).
-
You must set DB2CATALOG= in the restricted options table and then rebuild the table.
This option applies to only the local DB2 subsystem. So when you set the LOCATION= or SERVER= connection option in the LIBNAME statement, the SAS/ACCESS engine always uses SYSIBM as the default value.
|
|
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.