Examples of the audit row for various operations

Assume you have a table with the columns c1, c2, c3, c4, c5, and c6 with primary key (c4, c2). If all columns except c5 are audited, the audit-data dictionary contains information for these columns in order c4, c2, c1, c3, and c6. The field number 0 then refers to field c4, field number 1 is c2, and so on.

Create table


Length	Appl Data	'C'

Here, the length is the same for all tables: 5.

Drop table


Length	Appl Data	'R'

Here, the length is the same for all tables: 5.

Clear table


Length	Appl Data	'L'

Here, the length is the same for all tables: 5.

Insert row


Length	Appl Data	‘I’	c4	c2	c1	c3	c6

Here, c4, c2, and so on, indicate the values of the corresponding fields. Each field entry size is the size of the field itself.

Delete row


Length	Appl Data	‘D’	c4	c2	c1	c3	c6

Update row

Assume that c2 (primary key column) and c6 are changed.


Length	Appl	'U'	0	N	c4.o	1	Y	c2.o	c2.n	4	Y	c6.o	c6.n

Here, the entry for field 0 (c4) is present, although the entry is not changed, because the field is a primary key field. The field’s only value that is stored is c4.o, which is the old value. Because c2 (field 1) and c6 (field 4) are changed, their old and new values are stored as .o and .n, respectively.