By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,740 Members | 790 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,740 IT Pros & Developers. It's quick & easy.

Set integrity after load

P: n/a
Hi all,
I have an issue with SET INTEGRITY after loading my table. Set
integrity does not see integrity violations checking by trigger. My
shell script does the following steps:

- LOAD FROM ... REPLACE INTO my_table
- SET INTEGRITY FOR my_table IMMEDIATE CHECKED

We have just a trigger, verifying loaded data from my_table with an
another table, nothing else. SET INTEGRITY does not detect my bad
datas committed by LOAD, my_table is not in pending state

Our DB2 version is AIX 5.2 running on AIX5.2

Any idea?
Thanks for your help

D.
Feb 13 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Doug" <cd***@sopragroup.comwrote in message
news:3c**********************************@s19g2000 prg.googlegroups.com...
Hi all,
I have an issue with SET INTEGRITY after loading my table. Set
integrity does not see integrity violations checking by trigger. My
shell script does the following steps:

- LOAD FROM ... REPLACE INTO my_table
- SET INTEGRITY FOR my_table IMMEDIATE CHECKED

We have just a trigger, verifying loaded data from my_table with an
another table, nothing else. SET INTEGRITY does not detect my bad
datas committed by LOAD, my_table is not in pending state

Our DB2 version is AIX 5.2 running on AIX5.2

Any idea?
Thanks for your help

D.
The Load command does not fire triggers. If you want triggers fired, you
need to use the import command.
Feb 13 '08 #2

P: n/a
On 13 fév, 14:01, "Mark A" <nob...@nowhere.comwrote:
"Doug" <cd...@sopragroup.comwrote in message

news:3c**********************************@s19g2000 prg.googlegroups.com...
Hi all,
I have an issue with SET INTEGRITY after loading my table. Set
integrity does not see integrity violations checking by trigger. My
shell script does the following steps:
- LOAD FROM ... REPLACE INTO my_table
- SET INTEGRITY FOR my_table IMMEDIATE CHECKED
We have just a trigger, verifying loaded data from my_table with an
another table, nothing else. SET INTEGRITY does not detect my bad
datas committed by LOAD, my_table is not in pending state
Our DB2 version is AIX 5.2 running on AIX5.2
Any idea?
Thanks for your help
D.

The Load command does not fire triggers. If you want triggers fired, you
need to use the import command.
Thanks Mark,
Feb 13 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.