DecimalPoint

The DecimalPoint parameter specifies which character the High-speed Apply Engine expects to represent the decimal point in the input SQL file.

Related topic

SQL-parameters

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[SQL]

Abbreviation

None

Required?

No

Valid values

Period (.), or comma (,)

Default value

High-speed Apply Engine uses character defined as a decimal point in the DSNHDECP module of the current subsystem

Usage

Some environments use target DBMS options to define a comma (,) instead of a period (.) as the decimal point in any numeric values contained within SQL statements. If your input SQL file is generated in such an environment, use this parameter to direct High-speed Apply Engine to interpret a comma within a numeric value as a decimal point character.

Warning

Exercise caution when the decimal point character of the input file is not supported by the target database. If High-speed Apply Engine processes an input statement as EXECUTE IMMEDIATE, the statement contains the input decimal point character. If that character is not supported by the target database, the results are unpredictable.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*