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.
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.