PARAMETER

You define a parameter as a named variable with a specific data type and, optionally, a default value for use within queries. Parameters enable you to pass dynamic values into your queries efficiently.

Syntax

parameter_definition ::= DEFINE PARAMETER parameter_name , data_type ,default_value END

Example

DEFINE PARAMETER NOVALUE_NUMBER,NUMBER(38,0),-99999 END
DEFINE PARAMETER VAR_ETL_FALSEVALUE,VARCHAR2(16),"F" END
DEFINE PARAMETER VAR_ETL_NOVALUE_CHAR_NAME,VARCHAR2(32),"~No Value~" END

You can store parameters in separate files, which you can then use in the Data Augmentation Scripts code with the INCLUDE command or reference the PARAMETER definition in the transformation code itself.

For more details, see File Types and Data Types.

Note:

• Use unique parameter names. You can't define parameters with the same names as those that are already existing system parameters.
• You can directly use factory Parameters in the Data Augmentation Scripts application. You can check the list of available factory parameters from the terminal.