Previous Topic: ASSIGN AUTHORIZATION Command (SQL Access)Next Topic: DB2 Considerations

CA Ideal Commands › ASSIGN AUTHORIZATION Command (SQL Access) › Operand Definitions

Operand Definitions

Operand

Description

auth‑id1

For DB2: An authorization ID specified for a DB2 table or view in the program resource table.

For CA Datacom SQL access: The authorization ID of the default plan entered in the environment fill‑in of the program definition and stored in the program object.

auth‑id2

For DB2: An authorization ID that overrides the specified authorization ID.

For CA Datacom SQL access: The authorization ID of the alternate plan. This authorization ID must be defined before the ASSIGN command is entered. (See the DEFINE AUTHORIZATION command.)

UNQUALIFIED

(For DB2 only) As a modifier of old‑auth‑id, indicates that unqualified table references are to be qualified by new‑auth‑id.

As a modifier of new‑auth‑id, indicates that table references qualified by old‑auth‑id are unqualified.

UNQUALIFIED cannot be assigned to UNQUALIFIED.

Example

Given the following program resource table definition:

Dataview	Auth‑id	Qualify?
EMPLOYEE	SBL			Y
PAYROLL	HOU			N

The following embedded SQL statements change those generated FROM clauses as specified:

EXEC SQL	    EXEC SQL
  SELECT ...	      SELECT ...
    FROM EMPLOYEE, PAYROLL       FROM SBL.EMPLOYEE, HOU.EMPLOYEE
END‑EXEC	    END‑EXEC

FROM SBL.EMPLOYEE, PAYROLL	FROM SBL.EMPLOYEES, HOU.PAYROLL

The following ASSIGN commands change those generated FROM clauses as specified:

No ASSIGN command entered
     FROM SBL.EMPLOYEE, PAYROLL      FROM SBL.EMPLOYEE, HOU.PAYROLL
ASSIGN AUTHORIZATION SBL NEW KRI
     FROM KRI.EMPLOYEE, PAYROLL      FROM KRI.EMPLOYEE, HOU.PAYROLL

ASSIGN ATZ HOU NEW KRI	
     FROM SBL.EMPLOYEE, PAYROLL      FROM SBL.EMPLOYEE, KRI.PAYROLL

ASSIGN ATZ SBL NEW UNQUALIFIED 
     FROM EMPLOYEE, PAYROLL          FROM EMPLOYEE, HOU.PAYROLL

ASSIGN ATZ UNQUALIFIED NEW KRI
     FROM SBL.EMPLOYEE, KRI.PAYROLL  FROM SBL.EMPLOYEE, KRI.PAYROLL

Note: This assignment affects CA Ideal programs only.