Set integrity after load

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Doug
    #1

    Set integrity after load

    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.
    Tags: None
    • Mark A
      #2
      Re: Set integrity after load

      "Doug" <cdngo@sopragro up.comwrote in message
      news:3c6d054f-9525-4277-a2e4-83ec17c51723@s1 9g2000prg.googl egroups.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.


        Comment

        • Doug
          #3
          Re: Set integrity after load

          On 13 fév, 14:01, "Mark A" <nob...@nowhere .comwrote:
          "Doug" <cd...@sopragro up.comwrote in message
          >
          news:3c6d054f-9525-4277-a2e4-83ec17c51723@s1 9g2000prg.googl egroups.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,

            Comment

            Previous template Next
            Working...