Create trigger using Stored procedure?

[lespaul]

I need to create a trigger on a table that is constantly in use. Is there a way to create a stored procedure that will create the trigger after our weekly backup process?

thanks!

Leslie

 

[sathyarams]

I have tried create table ... so, i don't see why create trigger wont be possible ... But I think you will have to use dynamic SQL ..

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp

 

[lespaul]

I ended up using the following solution:

A simple SQL statement, (create trigger etc....) in a source member could do the trick. Here is what you would do: 
 
1) You would write your [well tested in advance] SQL code in a standard source member let's call it "NITETRIGER"   
2) You would create a simple CL program to execute the SQL code. The instruction to use is 
RUNSQLSTM SOURCELIB/SRCFILE SRCMBR (where SRCMBR would be replaced by NITETRIGER. 
 
You could either use a Job Scheduler or ROBOT/400 or even a DLYJOB instruction to delay the execution until a good time at night.

Thanks to an outside source.

Leslie