IFCID270: Trusted Context

The IFCID270 DD contains the extracted IFCID 270 (Trusted Context) records.

Fields

Begin program-specific programming interface information.The IFCID270 DD has the following fields:
STATEMENT TYPE
The type of trusted context. STATEMENT TYPE can have the following values:
  • ALTER
  • CREATE
Field Name: QW0270TY
SQLCODE
The SQL return code from the CREATE or ALTER TRUSTED CONTEXT statement.
Field Name: QW0270SQ
SQL STMT LENGTH
The length of the SQL statement.
Field Name: QW0270SL
SQL STATEMENT
The SQL statement.
Field Name: QW0270SS

Example

STATEMENT TYPE : CREATE                                                                                                        
SQLCODE        :  0000000000                                                                                                   
SQL STMT LENGTH:  0000000236                                                                                                   
SQL STATEMENT  : CREATE TRUSTED CONTEXT CTXCC1A33 BASED UPON CONNECTION USING SYSTEM AUTHID USRT003 ATTRIBUTES(ADDRESS '9.30.89
                 .162') DEFAULT ROLE ROLECC1A3_SYSADM WITH ROLE AS OBJECT OWNER AND QUALIFIER ENABLE WITH USE FOR USRT003 ROLE 
                 ROLECC1A3_SYSADM
End program-specific programming interface information.