Re: SQL Triggers where Production and Test on Same iSeries

Collect before and after images

create schema rob130410
CREATE TABLE ROB130410/TEST (MYKEY INT not null

generated always as identity,
MYDATA CHAR (5 ) NOT NULL WITH DEFAULT, PRIMARY KEY (MYKEY))

INSERT INTO ROB130410/TEST (MYDATA) VALUES('A')
update rob130410/test

set mydata='B'
where mykey=1
dspjrn rob130410/qsqjrn
<just showing you the results of that last update>
Sequence Code Type Object Library Job Time
28 R UB TEST ROB130410 ROBS1 13:55:48
29 R UP TEST ROB130410 ROBS1 13:55:48

I hit the function key to display hex

Type . . . . . . . . : UB - Update, before-image
Entry specific data
* . . . + . . . . 1
'00000001C140404040'



Type . . . . . . . . : UP - Update, after-image
Entry specific data
* . . . + . . . . 1
'00000001C240404040'

Rob Berendt