SHOW SCRIPT VARIABLES

Lists the SQL scripting variables of the session (set with LET or as Script arguments)

Arguments

None.

Examples

SHOW SCRIPT VARIABLES;

Notes

Lists the SQL scripting variables of the session: SHOW SCRIPT VARIABLES.

One row per variable, sorted by name: its name as last assigned, its type and its value. String values are shown between single quotes (so the string 'NULL' is told apart from a NULL value, shown NULL). Only variables set with LET or passed as Script arguments are listed, never API variables set with VAR. Allowed at the prompt and in Scripts; the list is shown even under OUTPUT QUIET.

See Script variables in the SQL scripting guide.

Last modified in release 5.3.3.