Basic Language Elements › Authorization ID

Authorization ID

An authorization ID is a string of 1 to 18 characters. This rule applies for both ANSI mode and the CA Datacom/DB extended mode.

Authorization IDs are used to identify schemas. For example, to select from a table named PAY in the schema named CA, the table name is preceded by the authorization ID:

 SELECT *
 FROM CA.PAY

Note: Do not specify authorization IDs for tables and views that are to be used in Dynamic Plan Selection. (In a z/OS environment, Dynamic Plan Selection online requires CA Datacom CICS Services Release 2.5 and higher. Dynamic Plan Selection is batch only in z/VSE.) For more information on Dynamic Plan Selection, see the CA Datacom/DB Database and System Administration Guide.