Neoview Database Administrator's Guide (R2.2)

NOTE: Note: You must enclose parameter values in double quotes, for example, refExp =

“+”.

Format File Example

Here is a sample format file:

<field name="BIRTHDAY" ignore="false" startPos="41" length="8"

dateFormat="yyyymmdd" dateSeparator="-"/>

<field name="CUST_SINCE" ignore="false" startPos="58" length="8"

dateFormat="ddmmyyyy" dateSeparator=""/>

</layout>

Reflexive Update Support

A reflexive update is an update where the input value provided to update an existing column

is a numerical value to be added to or subtracted from the current column value. Reflexive

updates apply only to columns with numerical values. Specify that an input field is to be treated

as a reflexive update field by setting the refExp option in the format file. Its allowable values

are "+" or "-".

Reflexive updates cannot be applied to primary key columns because they cannot be changed.

Reflexive Update Considerations

The input value provided for a reflexive update has the same limitations as a value provided for

a non-reflexive update. That is, the input value must match the range of values that are legal for

the target column for the reflexive update. These are the value ranges for different column data

types:

Input value rangeColumn type

0 to +65535SMALLINT UNSIGNED

-32768 to +32767SMALLINT SIGNED

0 to +4294967295INTEGER UNSIGNED

-2147483648 to +2147483647INTEGER SIGNED

0 to +999.99NUMERIC(5,2) UNSIGNED

-999.99 to +999.99NUMERIC(5,2) SIGNED

Reflexive Update Example

This is a sample format file where the second input field is specified as a reflexive update field:

</layout>

The comma defined input is:

ABC1234567,100,10022006

In this example, the ACCTBAL column is incremented by 100 after the input has been processed.

106 Using the Neoview Loader