Previous Topic: SET CURRENT SQLIDNext Topic: Example


Description

USER

Specifying USER means you want the CURRENT SQLID special register set to the authorization ID of the currently executing plan.

string-literal or host-variable

Use a string literal or host variable if you want to specify a value for the CURRENT SQLID special register.

If the value you specify is not a valid authorization ID that was created by using the CREATE SCHEMA statement, an error results if the authorization ID is later used to qualify a table or view name in a dynamic SQL statement.