Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see High-speed Apply Engine 13.1.

DecimalPoint

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

Attributes

This parameter has the following attributes:

Attribute

Value

Section

[SQL]

Abbreviation

None

DBMS

Db2, Db2 LUW, Oracle

Required?

No

Valid values

Period (.), or comma (,)

Default value

  • Db2

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

  • Db2 LUW

    High-speed Apply Engine extracts character from the locale setting obtained from the current operating system

  • Oracle

    High-speed Apply Engine obtains character from the nls_session_parameters (specifically, nls_numeric_characters)

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.


Related topic

SQL-parameters


 

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