Trigger buffer field descriptions

Fields in the buffer field are described in alphabetic order.

CCSID of data

The CCSID of the data in the new or the original records. The data is converted to the job CCSID by the database. SBCS data is converted to the single byte associated CCSID. DBCS data is converted to the double byte associated CCSID.

Commit lock level

The commit lock level of the current application program. The possible values are:

'0'

*NONE

'1'

*CHG

'2'

*CS

'3'

*ALL

File library name

The name of the library in which the database file resides.

File member name

The name of the database file member.

File name

The name of the physical file being changed or read.

New record

A copy of the record that is being inserted or updated in a physical file as a result of the change operation. The new record only applies to the insert or update operations.

New record length

The maximum length is 32 766 bytes.

New record null byte map

This structure contains the NULL value information for each field of the new record. Each byte represents one field. The possible values for each byte are:

'0'

Not NULL

'1'

NULL

New record null byte map length

The length is equal to the number of fields in the physical file.

New record null byte map offset

The location of the null byte map of the new record. The offset value is from the beginning of the trigger buffer. This field is not applicable if the new value of the record does not apply to the change operation, for example, a delete operation.

New record offset

The location of the new record. The offset value is from the beginning of the trigger buffer. This field is not applicable if the new value of the record does not apply to the change operation, for example, a delete operation.

Original record

A copy of the original physical record before being updated, deleted, or read. The original record applies only to update, delete, and read operations.

Original record length

The maximum length is 32 766 bytes.

Original record null byte map

This structure contains the NULL value information for each field of the original record. Each byte represents one field. The possible values for each byte are:

'0'

Not NULL

'1'

NULL

Original record null byte map length

The length is equal to the number of fields in the physical file.

Original record null byte map offset

The location of the null byte map of the original record. The offset value is from the beginning of the trigger buffer. This field is not applicable if the original value of the record does not apply to the change operation, for example, an insert operation.

Original record offset

The location of the original record. The offset value is from the beginning of the trigger buffer. This field is not applicable if the original value of the record does not apply to the operation; for example, an insert operation.

Relative Record Number

The relative record number of the record to be updated or deleted (*BEFORE triggers) or the relative record number of the record which was inserted, updated, deleted, or read(*AFTER triggers).

Trigger event

The event that caused the trigger program to be called. The possible values are:

'1'

Insert operation

'2'

Delete operation

'3'

Update operation

'4'

Read operation

Trigger time

The time, relative to the operation on the database file, when the trigger program is called. The possible values are:

'1'

After the change or read operation

'2'

Before the change operation

'3'

Instead of the change operation

Parent topic: