RE: SQL triggers..

[rob@xxxxxxxxx]

Outstanding article!  How to do this was clearly outlined in the section 
"Moving a schema".  David, sounds like a lot of STRJRNPF's but will this 
also work for your problem?

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/29/2005 10:03 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
"'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: SQL triggers..






Ken, check this link out:

http://tinyurl.com/9woc3

My gut tells me it's not working as designed, but only IBM will be able to
confirm/deny that.

Elvis

-----Original Message-----
Subject: SQL triggers..

When we save a library that contains SQL triggered files (tables) and then
restore this save to a DIFFERENT library name... none of the SQL Triggers
work, they were restored in *INOPERATIVE status. 

Why is this happening? Why can't we save and restore an SQL database
(library) to a different library and keep our SQL triggers in an active
status?

Geesh! Sometimes SQL is such a hassle! 

Kenneth

****************************************
Kenneth E. Graap
IBM Certified Specialist 
AS/400e Professional System Administrator
NW Natural (Gas Services)
keg@xxxxxxxxxxxxx
Phone: 503-226-4211 x5537
FAX:    603-849-0591
****************************************

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.