Create Trusted Context or Alter Trusted Context (IFCID 270)

This topic shows a sample and the field description of a DDL change type of Create Trusted Context or Alter Trusted Context (IFCID 270).

The following sample shows the layout for an DDL change type of Create Trusted Context or Alter Trusted Context (IFCID 270):

TYPE: CREATE TRUSTED CONTEXT           SQLCODE:                100
TEXT: THIS IS THE VARIABLE LENGTH SQL STATEMENT WHEN A TRUSTED
      CONTEXT IS CREATED OR ALTERED. MAXIMUM LENGTH IS 4000.

Field description

The fields are described in the following:

TYPE

The type of trusted context. Possible values are:

CREATE TRUSTED CONTEXT or CREATE: If a trusted context is created.
ALTER TRUSTED CONTEXT or ALTER: If a trusted context is altered.

Derivation: Db2® field QW0270TY

SQLCODE

The SQL return code from the CREATE or ALTER TRUSTED CONTEXT statement.

Derivation: Db2 field QW0270SQ

TEXT

The SQL statement (truncated at 4000 bytes).

Derivation: Db2 field QW0270SS