Re: Triggers, QTEMP and CRTDUPOBJ

[rob@xxxxxxxxx]

Instead of CRTDUPOBJ use the SQL statement:

create table qtemp/myfile as
(select * from myfile)
with no data 

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





"Reinardy, James" <jreinardy@xxxxxxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
11/16/2004 12:36 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Triggers, QTEMP and CRTDUPOBJ






Hello All,
 
We seem to be backed into a corner.  I have a commercial data collection
product on our BPCS environment that does a CRTDUPOBJ on some tables
into QTEMP as part of their RPG trigger programs.  Some of the table
also have SQL triggers of our own creation.  The problem is that the
CRTDUPOBJ seems to be failing because DB2 is unable to create the SQL
triggers in QTEMP.  We are looking for the easiest way out here.  Is
there a way to instruct DB2 to create the trigger programs in a
different library?  Other suggestions are appreciated.
 
Thanks in advance,
 
Jim Reinardy
Director - IS
Badger Meter, Inc.
Milwaukee, WI
--
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.