Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

restrictions for Triggers in ver 6.5 and ver 7.0

Status
Not open for further replies.

coderight

IS-IT--Management
Mar 1, 2004
15
0
0
US
what is the maximum number of triggers we can create in single Table in DB2 version 6.5 and Version 7

Thanks
 
Coderight,

not sure of the physical limit, if indeed there is one. However I am aware on Version 6 on the mainframe DB2 will abort a transaction if it results in more than 16 nested triggers.


Hope that helps, though I suspect it may not.

Cheers
Greg
 
maximum how many triggers we can create a table in DB2 version 6.5 and version 7,is there any restriction are there.Please help me.

Thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top