Skip to Content

SQLID (Change SQL ID)

The SQLID primary command changes the current SQL ID. Without a parameter, SQLID resets the SQL ID to your user ID. The current SQL ID, which is used by generating SQL and other File-AID for Db2 Object Administration functions, is part of your session user profile.

When you first access File-AID for Db2 Object Administration, the current SQL ID is set to the primary authorization ID. If your installation uses SQL IDs, you may need to change it.

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

image2021-4-29_15-48-25.png

USER

Specifies the SQLID is to be reset to the current user ID.

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*

BMC AMI DevX File-AID for Db2 23.01