- Community Home
- >
- Welcome
- >
- Other HPE Product Questions
- >
- Re: Issues about SQL_C_NUMERIC for vertica odbc dr...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-20-2017 12:09 AM
тАО09-20-2017 12:09 AM
Issues about SQL_C_NUMERIC for vertica odbc driver
Is there anyone use SQL_C_NUMERIC structs to insert/fetch numeric data through vertica odbc driver 7.x?
I wrote one apinumeric.c test odbc API.
It works OK with postgres open source driver and greenplum Data Direct
driver. But it failed with vertica vendor driver.
When I SQLBindParameter(SQL_C_NUMERIC), set SQLSetDescField correctly, run
SQLExecute(),
Vertica ODBC driver return 100. SQL_NO_DATA
[Vertica][VerticaDSII] (20) An error occurred during query execution: Row
rejected by server; see server log for details
When I SQLBindCol(SQL_C_NUMERIC) to fetch data into SQL_NUMERIC_STRUCT,
Vertica ODBC driver return following in structure SQL_NUMERIC_STRUCT numStr.
numStr.sign = 1
numStr.precision = 38
numStr.scale = 0
numStr.val="\x19\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0" 25
[Vertica][Support] (40460) Fractional data truncated while performing
conversion.
-------------------------------------
What postgres driver and greenplum dd driver returned is as following:
[postgres open source odbc driver]
[greenplum dd odbc driver]
numStr.sign = 1
numStr.precision = 5
numStr.scale = 3
numStr.val=0x7C62 25212
So, I think there is a vendor issue when bind SQL_C_NUMERIC to do input/output.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-23-2017 03:30 PM
тАО09-23-2017 03:30 PM
Re: Issues about SQL_C_NUMERIC for vertica odbc driver
What OS are you using?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2017 06:57 PM
тАО09-24-2017 06:57 PM
Re: Issues about SQL_C_NUMERIC for vertica odbc driver
My test failed on both windows x64 and linux x64.
It also failed on other unix such as SPARC, AIX 7.1, and HP-UX ia64.
Is there a way to upload my test file apinumeric.c ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2017 07:07 PM
тАО09-24-2017 07:07 PM
Re: Issues about SQL_C_NUMERIC for vertica odbc driver
So no specific OS. Perhaps you need to ask in the Micro Focus forum?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-24-2017 07:55 PM
тАО09-24-2017 07:55 PM