Contents
Environment & System Variables - Embedding Parameters in SQL Code

Combine Variables - Environment and System Variables

Combine Variables is a collective name for Environment Variables and System Variables, which are two types of variables that can be embedded inside your SQL code. Variables can be embedded in scripts that are part of a code package, or in scripts that are executed directly from the editor, against a single DB from a connected window or against a Container. Environment Variables are also supported in the Query used by a Dynamic Container. When Combine executes code that includes Environment or System Variables, Combine replaces the value of the variables in run-time before code is deployed.

Environment Variables are user-defined parameters and are supported in package scripts, individual scripts in the editor, as well as Queries used by Dynamic Containers. If Environment Variables are found in your SQL code, then Combine will prompt you to validate and update the value of these parameters before code is executed. The syntax for Environment Variables is <$VariableName$> (for example, <$MyTableName$>). For additional information please refer to Introduction to Environment Variables.

System Variables are fixed and built-in (i.e., non-user-defined) variables that can be embedded in code. System Variables are supported in package scripts and individual scripts, however are not supported in the Query used by Dynamic Containers. When the SQL code contains System Variables, Combine will not prompt you to enter their value since the value of these parameters is automatically replaced by the application in run-time. The syntax for System Variables is <%VariableName%> (for example, <%Execution_DatabaseName%>). For additional information please refer to the System Variables section.

Note: The term




© 2001-2018 JNetDirect, Inc. All Rights Reserved.