2 Replies Latest reply on Mar 13, 2017 7:55 AM by Egor Larin

    db2 10.1 on Linux problem with double datatype

    Rob Guikers

      Hi all,

       

      Currently have a problem which is reproducible with a small table. create table with column id INT, value DOUBLE.

      After filling in some data connect tableau to the database. Preview shows an #error on the double column. the log file :

       

      2014-01-28 10:26:25.451 (-,-,-,-) 0d90: ODBCProtocolImpl::ResolvePreferredImportBinding: Field named 'none:id:ok' has wire data type -16 (SQL_C_SLONG) and octet length 4; SQL data type is 4 (SQL_INTEGER).

      2014-01-28 10:26:25.451 (-,-,-,-) 0d90: ODBCProtocolImpl::ResolvePreferredImportBinding: The field 'sum:value:ok' has a precision '22' and scale '-1' which may result in data truncation. Attempting to set the binding as a string for local interpretation.

      2014-01-28 10:26:25.451 (-,-,-,-) 0d90: ODBCProtocolImpl::ResolvePreferredImportBinding: Field named 'sum:value:ok' forced to wire data type 1 (SQL_C_CHAR) and octet length 47; SQL data type is 8 (SQL_DOUBLE). Original: wire data type 8 (SQL_C_DOUBLE) and octet length 8.

      2014-01-28 10:26:25.451 (-,-,-,-) 0d90: ODBCRowsetSource::ODBCRowsetSource: Attempting to set the row fetch size to 2570 rows, with 51 bytes per row.

      2014-01-28 10:26:25.451 (-,-,-,-) 0d90: ODBCRowsetSource::BindColumn: Binding column 1 named 'none:id:ok' with wire type -16 (SQL_C_SLONG) and octet length 4.

      2014-01-28 10:26:25.452 (-,-,-,-) 0d90: ODBCRowsetSource::BindColumn: Binding column 2 named 'sum:value:ok' with wire type 1 (SQL_C_CHAR) and octet length 47.

      2014-01-28 10:26:25.452 (-,-,-,-) 0d90: WorkItemCreate: 0x03a123a8, 0x03a599c8

      2014-01-28 10:26:25.452 (-,-,-,-) 0d90: AsyncTaskSvcExecute: 0x03a599c8

      2014-01-28 10:26:25.453 (-,-,-,-) 0d64: Starting AsyncTask for SessionID: -.

      2014-01-28 10:26:25.453 (-,-,-,-) 0d64: Creating system locale object: 0x413 Dutch_Netherlands.1252

      2014-01-28 10:26:25.456 (-,-,-,-) 0d64: Creating user locale object: 0x413 Dutch_Netherlands.1252

      2014-01-28 10:26:25.456 (-,-,-,-) 0d64: Error converting "1,40012300000000E+003" to double, error at character 1 (ts = 0x0)

      2014-01-28 10:26:25.456 (-,-,-,-) 0d64: Error converting "2,00000000000000E+002" to double, error at character 1 (ts = 0x0)

      2014-01-28 10:26:25.456 (-,-,-,-) 0d64: ODBCRowsetSource::NextRowsChunk: No more data is available.

      2014-01-28 10:26:25.456 (-,-,-,-) 0d64:    [Time] ODBCRowsetSource: Fetching the records took 0.000 sec.

       

      Seems like a problem with Tableau, or the driver. I've used the driver from the Tableau driver download site, and the DB2 driver delivered with the product (DB2).

      When changing the datatype to REAL or NUMERIC the preview shows the data correctly, but dragging the value to the rows shelve (SUM(value)), the summed up value is 0.. Strange.. When using real or numeric and creating an extract i see the correct information.

       

      So concluding :

      Double datatype is not working at all (not in preview, not in worksheet and not in extract)

      REAL en NUMERIC datatype is shown in preview, not working in worksheet and working fine when using extract.

       

      DB2 version is 10.1, product is Infosphere warehouse enterprise edition

       

      Hope someone can help me out..