AUTHID

Causes the preprocessor to include code at SQL initialization that sets the value of your current SQLID to any valid authorization ID.

Syntax:

[NO]AUTHID
AUTHID[=authorization-ID#1;authorization-ID#2;...;authorization-ID#10]

Parameters:

authorization-ID A valid authorization ID defined via SQL Wizard
NOAUTHID No code will be generated

Properties:

Default: NOAUTHID

Comments:

If AUTHID is used without authorization ID, the current AUTHID is set to the default value specified via Options > SQL for DB2 from the IDE menus.

If you are doing static binding, the AUTHID directive also sets the value of the default qualifier. Mutliple authorization IDs are only supported when doing AUTOBIND, IDs must be delimited by a semi-colon with no spaces in the string. A maximum of 10 IDs are supported but the same number of DBRMs must be specified or the number of IDs greater than DBRMs will be ignored.