SAP Knowledge Base Article - Preview

3229140 - "double" column is extracted with an exponent - SAP IQ

Symptom

When a table is extracted, a "double" column is extracted with an exponent like below.

$ cat file_extracted
6.68852459016000012e+01,

Interactive sql returns without an exponent unlike the file extracted.

(dba)> select * from tab01;
int_col double_col
---------------------
66.8852459016


Read more...

Environment

  • SAP IQ 

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.