RPG触发器数据区结构

xuguopeng

Decimal Offset      Parameter          Type                         Description

0     Physical file Name   char(10)      The physical file being changed

10  Physical file library name  char(10)   The library which the physical file resides
     
20 Physical file member name char (10) The name of the physical file member

30 Trigger Event char(1) The event that caused the trigger program to be called; the possible values can be “1” (Insert), “2” (Delete), “3” (Update),“4” (Read)

31 Trigger Time char(1) Can be “1” (After) or “2” (Before)

32 Commit level char(1) Reports the commit lock level of the interface that activated
the trigger “0” (*NONE), “1” (*CHG ), “2” (*CS), “3” (*ALL)

33 Reserved char(3) Reserved

36 CCSID of data binary(4) The CCSID of the data in the new or the original records. The data is converted to the job CCSID by the database

40 Relative record number binary(4) 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)

44 Reserved char(4) Reserved (待续）

xuguopeng

48 Original Record offset binary(4) 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.

52 Old record length binary(4) The maximum length is 32766 bytes.

56 Old record null map offset binary(4) 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.

60 Old record null map length binary(4) The length is equal to the number of fields in the physical file.

64 New record offset binary(4) 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.

68 New record length binary(4) The maximum length is 32766 bytes.

72 New record null map offset binary(4) 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.

xuguopeng

76 New record null map length binary(4) The length is equal to the number of fields in the physical file.

80 Reserved char(16) Reserved

* Original record char(*) 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 null byte map char(*) 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)

* New record char(*) 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 null byte map char(*) 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)