Please enable JavaScript to view this site.

The INITIALIZE command initializes a target field/column to a constant value. This has a performance advantage over mapping string constants to a target field, since it is performed only one time.

Once the value of a target field has been set with the INITIALIZE command, it can subsequently be mapped later by functions within the Apply Engine script.

Syntax

INITIALIZE [<target_datastore>][.<target_description>].<target_field> <value>;

 

Keyword and Parameter Descriptions

<target_datastore>   Specifies the name of the target datastore that contains the  the target field.

<target_description>   Specifies the name of the description/structure that defines that target data record.

<target_field>   Specifies the name of the target field to be Initialized.

<value>  Specifies the Initialized value which may be a ‘constant’ in quotes or one of the special keywords:

&SYSDATETIME: initializes with date and time.

&SYSTIMESTAM: initializes with time stamp.

&SYSTIMESTAMPPK: initializes with

&SYSSTCK:

&SPACES: initializes with spaces.

&ZEREOS: initializes with zeroes.

&LOWVALUES.initializes with low values.

Example 1:

Initialize the target field tgt_field1 to the value ‘501’.

INITIALIZE target_field1     '501';

 

Example 2:

Perform the same initialization as the above example, except specify a fully qualified name (i.e. target datastore, target description, target field).

INITIALIZE   target_ds.target_descr.target_field1   '501';

 

Example 3:

Initialize the target field target_field1 to the value all ZEROS.

INITIALIZE   target_field1   &ZEROS;

 

Example 4:

Initialize the target field target_field1 to  spaces.

INITIALIZE   target_field1   &&SPACES;