RE: SQL triggers..

["Graap, Ken" <keg@xxxxxxxxxxxxx>]

Probably "blew away" a bunch of e-mail after returning from Common!  <smile>

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of rob@xxxxxxxxx
Sent: Friday, April 29, 2005 6:25 AM
To: Midrange Systems Technical Discussion
Subject: Re: SQL triggers..


Did you take a recent vacation?  Or perhaps blow away all email after 
returning from COMMON?  None other than list master David had this same 
issue.
http://archive.midrange.com/midrange-l/200504/msg00138.html

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





"Graap, Ken" <keg@xxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/28/2005 06:13 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


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

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.