Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

Enabling this setting can potentially break applications that were not coded for precise decimal.

Info

Support for precise decimal values in SQL results sets is limited to the following drivers:

  • IBMi

  • odbc

  • mssql

With odbc and mssql drivers, values with more than 15 digits can still lose precision, due to limitations in 3rd party packages.

This setting controls automatic definition of precise decimal values. Valid values are:

...

  • Strongly typed field definitions that are produced automatically by the framework from external definitions. For example, external RLA DB files, printer files, and Rich Display Files.

  • Rich Display File bound fields with Decimal type.

  • SQL result sets containing decimal values, where supported.

  • Low Code RDF, Module, and Profound API CRUD generation over DB tables containing decimal columns. The setting is used to auto-populate the Precise decimal checkbox on input/output parameter settings.

  • Low Code Module input/output parameters defined with IBM i / RPG lengths.