CODEWITHSUNDEEP
triggersdb2
senior
senior

Reputation: 2276

db2 execute triggers using ant script

I have an sql file containing triggers. I want to execute this file using Ant script:

<target name="exec-sql-proc_db2" depends="init">
  <property name="project.sql.dir" value="${project.metadata.dir}/sql" />
  <property name="triggerFile" value="${project.sql.dir}/triggers_db2.sql" />
  <echo message="${triggerFile}" />
  <sql rdbms="DB2" driver="com.ibm.db2.jcc.DB2Driver" 
       url="jdbc:db2://localhost:50000/project:currentSchema=mySchema;" 
       userid="root" password="root" 
       classpath="C:\projects\myProject\lib\db2jcc.jar" 
       src="${triggerFile}" 
       onerror="${sql.onerror}" 
       keepformat="true" delimiter="/" />
</target>

I get build successful, but the triggers are not executed ! Is there any other solution?

my trigger is :

CREATE or REPLACE TRIGGER PRODUCT_HISTORY_AFTER_UPDATE
AFTER UPDATE ON PRODUCT 
REFERENCING NEW AS N 
FOR EACH ROW 
BEGIN 
   INSERT INTO productHistory ( id_h, id_product , name) values (id_h_seq.nextval, N.id_product , N.name ); 

    END 
/

Upvotes: 0

Views: 828

Answers (1)

senior
senior

Reputation: 2276

<sql rdbms="DB2" driver="com.ibm.db2.jcc.DB2Driver" 
       url="jdbc:db2://localhost:50000/project:currentSchema=mySchema;" 
       userid="root" password="root" 
       classpath="C:\projects\myProject\lib\db2jcc.jar" 
       src="${triggerFile}" 
       onerror="${sql.onerror}" 
        delimiter="/" >

SET SCHEMA mySchema
</sql>

I tried this part of code, that solves my problem

Upvotes: 1

Related Questions