My Oracle Support Banner

DB2 DECIMAL NUMBERS ROUNDED USING DG4ODBC (Doc ID 2648429.1)

Last updated on APRIL 01, 2020

Applies to:

Oracle Database - Standard Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Database Gateway for ODBC (DG4ODBC) 19c to connect to a DB2 database.

When selecting DECIMAL values via the gateway, notice that the values are rounded.

A DG4ODBC trace file shows the following:

 SQLFetch: row: 2, column 1, bflsz: 14, bflar: 5

 SQLFetch: row: 2, column 1, bflsz: 14, bflar: 5, (bfl: 0, mbl: 14)

  0: 302C3735 30 [0,750] ---->using "," as decimal separator .

In the trace file, it shows following parameter is used by default:

HS_NLS_NUMERIC_CHARACTERS = ".,"

 

 

Changes

Using Oracle Database Gateway for ODBC (DG4ODBC) 19c to connect to a DB2 database.

At the DB2 database, there are decimal column values with a delimiter of "," instead of "." .

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.