The current collection or library. Valid only on DB2 for z/OS and DB2 for i.
For DB2 for z/OS, this value is the user ID. If an attempt to change the current schema fails, the connection fails and you receive the message Invalid value for Alternate ID.
For DB2 for i, this value is the name of the schema to be used as the default qualifier for unqualified object names. If you want to access a table outside of this schema, you must specify the schema name and the table name. For example:
SELECT * FROM Schema.Tablename
Also, if the Alternate ID option is set, it overrides this option.
Valid Values
user_ID (DB2 for z/OS) | schema_name (DB2 for i)
where:
user_ID
is a valid user ID. DB2 permissions on the user ID must be set to SYSADM.
schema_name
is the default schema to use for unqualified object names.
Notes
This option is mutually exclusive with the Database Name option.
This option is mutually exclusive with the Database Name option.