If you try to change a flag of your record, but you don’t want to make any changes on your application
Your product code use to be “Non Tax”
But now to have to be stored at “With GST”
Below is a sample table structure for illustraction purpose
c1 is the key and c2 is the content :-
create table t1
primary key (c1) constraint c1
Create the procedure and triggle for the update
The triggle only takes effect for INSERT statement :-
create procedure update_t1_prc(pc1 int) returning CHAR(20);
DEFINE pc2 CHAR(20);
SELECT c2 into pc2
where c1 = pc1;
IF pc2 is not null THEN
LET pc2 = ‘With GST’;
create trigger update_t1_trig
insert on t1
REFERENCING NEW AS n
for each row (execute procedure update_t1_prc(n.c1) into c2);
Now, to some insert.
> insert into t1 values (24,’Non Tax’);
1 row(s) inserted.
> select * from t1 where c1=24;
24 With GST
1 row(s) retrieved.
Hope you find this useful
from onstat -g ath output
grep for sm_read
informix@xxxxxxx: onstat -g ath | grep sm_read
23519 5d7ce028 5aa622d0 1 cond wait sm_read 8cpu sqlexec
To trace back the session
grep the 3rd column with onstat -u
informix@devlx005: onstat -u | grep 5aa622d0
5aa622d0 Y–P— 21045 informix 6 5bc6bd48 0 1 0 0
Session ID = 21045
I would like to share this feature with all of you – Informix Archecker.
It can be used to restore/recover (point-in-time) to a new target table (new table name) from backup.
– Someone accidentally performed a mass update for all rows in table “customer” on 2014-08-21 10:48:00.
– You need to restore & recover (point in time) to a new table called “customer_res” until 2014-08-21 10:46:00. (Current table “customer” will be maintained)
– Database = stores_demo, Source Table = customer, Target New Table = customer_res
– You are using Informix Archecker with Netbackup Informix Agent for backup/restore.
Note: Informix Archecker is available since IDS 10.00 or higher.
(1) 2014-08-21 09:50:00:
$ dbaccess stores_demo –
> select count(*) from customer ;
Continue reading Informix Archecker – point in time restore/recover table (Scenario 2) »