![]() |
Cloudscape Properties
|
Reference Manual |
cloudscape.language.triggerMaximumRecursionLevelFunctionSpecifies the maximum recursion level for trigger firing. It is possible for one trigger to cause another trigger to fire, and thus it is possible for triggers to recurse infinitely. If the trigger recursion level exceeds the maximum recursion level, an exception is raised and the statement that caused the trigger to fire is rolled back. A value of -1 means that there are no limits to recursion. A value of 0 means that no triggers will ever fire. NOTE: When the maximum recursion level is reached when a trigger is fired, Cloudscape throws an SQLException of SQLState X0Y73. Syntax
-- database-wide property DefaultMinimum Value-1 (no limit; see notes above). Example
-- database-wide property
-- publishing a database-wide property Scopedatabase-wide (publishable) Dynamic or StaticDynamic; the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |