SCHEMA (Change CURRENT SCHEMA)

The SCHEMA primary command allows you to specify a value for the CURRENT SCHEMA Special Register. This command functions like the SQLID command; the value specified with the command will set the value of the Special Register.

If no value is specified for CURRENT SCHEMA, it will default to the value specified for SQLID.

The value entered for CURRENT SCHEMA will be retained across sessions by Db2 subsystem.

The length of the SCHEMA entered will be limited to the number of available positions of the Command line.

To check the current SCHEMA at any time, use the SHOW command with the SCHEMA keyword. To reset your current SCHEMA to your SQLID, execute SCHEMA without a parameter.

image2021-4-29_15-22-0.png

SQLID

Specifies the SCHEMA is to be reset to the current SQLID.

userid

Specifies a user ID.

groupid

Specifies a group authorization ID.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*