Pre-defined Variables

A number of pre-defined variables exist:

•Translation resources: name starts with 'res:', followed by a resource code. For instance, the variable 'res:itgen_description' will expand to the string value of the resource 'itgen_description' which is 'Description' on an English user interface and 'Omschrijving' on a Dutch user interface.

•Last result outcome: name starts with 'outcome:', followed by a 0-based row and column number separated by comma. The variable 'outcome:0,0' will expand to the string value of the first row and column in the result of the last SQL executed.

•Local statement executions: name starts with local:'. Pre-defined list of:

ohoststdout: regular output of the last (successful) host statement.

ohoststderr: error output of the last (successful) host statement.

ohostexitcode: exit code of the last (successful) host statement.

•Execution statistics: name starts with 'stat:'. Pre-defined list of:

oerrorcountignore: number of errors fully ignored.

oerrorcountdefault: number of errors during default setting.

oerrorcountcontinue: number of errors ignored, but memorized for exit code.

ostatementcount: number of statements executed.

•Application variables: name starts with 'application:'.

•Database variables: name starts with 'database:'.

•System variables: name starts with 'system:'.