Cloudscape Properties
Page 25 of 47

cloudscape.language.triggerMaximumRecursionLevel

Function

Specifies 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
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.language.triggerMaximumRecursionLevel',
    'integerValue')

Default

16.

Minimum Value

-1 (no limit; see notes above).

Example

-- database-wide property
CALL PropertyInfo.setDatabaseProperty(
    'cloudscape.language.triggerMaximumRecursionLevel',
    '10')

-- publishing a database-wide property
CREATE PUBLICATION APub
ADD TARGET DATABASE PROPERTY
cloudscape.language.triggerMaximumRecursionLevel=
    '10'

Scope

database-wide (publishable)

system-wide

Dynamic or Static

Dynamic; the change takes effect immediately. For information about dynamic changes to properties, see Dynamic or Static Changes to Properties.