IFCID145: Audit DML Statement

The IFCID145 DD contains the extracted IFCID 145 (Audit DML Statement) records.

Fields

Begin program-specific programming interface information.The IFCID145 DD has the following fields:
LOCATION NAME
The location name.
Field Name: QW0145LN
PKG COLLCT ID
The package collection identifier.
Field Name: QW0145PC
PROGRAM NAME
The program name.
Field Name: QW0145PN
TIME
The hexadecimal value of the precompiler timestamp.
Field Name: QW0145TS
TYPE
The SQL statement type.
Field Name: QW0145ST
STMT#
The precompiler statement number.
Field Name: QW0145SN
STATEMENT ID
The statement ID. This field can contain one of the following values:
  • SQL statement ID
  • 0
Field Name: QW0145SI
HOST OPTIONS
The options used in the host to check the SQL statement. The bits of this field are used as indicators. If all bits are 0, the statement is not an SQL statement. See the OPTIONS field of IFCID140: Audit Authorization Failures for a full description of the bits of this field.
Field Name: QW0145HO
SQL TEXT
The SQL statement text.
Field Name: QW0145RT_Var
DATABASE
The database ID.
Field Name: QW0145DB
TABLE OBID
The object ID.
Field Name: QW0145OB
ISOLATION
The isolation level of the DML statement. ISOLATION can have the following values:
  • RR Repeatable read
  • CS Cursor stability
  • RS Read stability
  • UR Uncommitted read
  • RRX Repeatable read with X lock
  • RSX Read stability with X lock
Field Name: QW0145IS
ACCESS SCHEMA
Field Name: QW0145AS_D
ACCESS OBJECT
The access control object name
Field Name: QW0145AO_D

Example

              LOCATION NAME: STLEC1                                                      
              PKG COLLCT ID: PKCC1A3                                                     
              PROGRAM NAME : MCC1A3                                                      
              TIME         : 02:22:12                                                    
              TYPE         : INSERT                       STMT#: 0000000014              
              STATEMENT ID : 00000000000000036343                                        
              HOST OPTIONS : X'0300D70010020000'                                         
              DATABASE     : 00269                   TABLE OBID: 00004                   
              ISOLATION    : CS                                                          
              SQL TEXT:  INSERT INTO SCCC1A31 . TBCC1A31 ( ID , NAME ) VALUES ( 1 , 'X' )
End program-specific programming interface information.