Identifier: limit_query_sub_commands

Type

numeric

Description

A global setting for command behavior during the execution of channel and database query language blocks.
This is a numeric identifier with a session start value of 0.

Within channel or database query language blocks, channel/database commands may be interspersed with non-channel/database commands, but channel/database commands are not executed immediately but are buffered up and executed together at the end of the language block. This keeps inter-process/internet traffic to a minimum. It is the default behavior (i.e. when limit_query_sub_commands has a 0 value).

This default behavior (historical in origin) can cause execution anomalies and lead to misunderstandings and it is better to restrict commands within a query block to channel/database commands only. This restriction can be applied by setting limit_query_sub_commands to 1, in which case any non-channel/database commands occurring in query blocks will invoke errors.

See Also