Page History

...

The parameters are one or two values, which are separated by a blank or tab. Therefore, the parameters may not have any blanks or tabs. The first parameter is the name and the second paramter is the value that is assigned to the name. However, the second parameter (the value) is optional, because it if a value for #IFDEF is not necessary, otherwise it cannot be used for replacement.

...

#DEFINE aNumber 1000
#EVAL bNumber = aNumber + 2000
#EVAL cNumber aNumber + 2000

Remarks:

• If you want to access elements that are defined (e.g. with another DEFINE) you will need to omit the "${}"
• You cannot use a loop variable here 

#INPUT/#INCLUDE

This command copies the input from the source given into the current script file. The source can be a local file or a file on a web server (giving an URI).

...

#STOPSCHEDULER

#UNDEF

This command sets the transformation configuration for following commands. The transformation configuration defines how a query is transformed into an executable plan. The transformation configuration that was set is used until another configuration is explicitly set.

Parameters

...

With this command, a given value for a variable can be removed and a new value can be assigned with #DEFINE.

Example

#UNDEF variable