[unixODBC-support] Re: select on date in Timesten throws "Numeric value out of range"

jothi libitha libithashanmugam at yahoo.com
Tue May 20 15:28:59 BST 2008


Hi Nick,
Could you please tell me where I can download unixODBC 2.2.13 pre?

Thanks,
Libitha


----- Original Message ----
From: Nick Gorham <nick.gorham at easysoft.com>
To: Support for the unixODBC project <unixodbc-support at easysoft.com>
Sent: Tuesday, 20 May, 2008 6:49:49 PM
Subject: Re: [unixODBC-support] Re: select on date in Timesten throws "Numeric value out of range"

jothi libitha wrote:

>Hi,
>I got a reply from Martin Evans asking me to run help table in isql to see the column types returned.
>
>I tried the same. I don't get the table details displayed. I get empty lines with message 'SQLRowCount returns -1'
>
>SQL> help EMP
>+---------------------+---------------------+---------------------+---------------------+----------+---------------------+------------+------------+-------+-------+---------+---------------------+---------------------+--------------+-----------------+------------------+-----------------+------------+-------+-----------------+
>| TABLE_QUALIFIER     | TABLE_OWNER         | TABLE_NAME          | COLUMN_NAME         | DATA_TYPE| TYPE_NAME           | PRECISION  | LENGTH     | SCALE | RADIX | NULLABLE| REMARKS             | COLUMN_DEF          | SQL_DATA_TYPE| SQL_DATETIME_SUB| CHAR_OCTET_LENGTH| ORDINAL_POSITION| IS_NULLABLE| INLINE| LENGTH_SEMANTICS|
>+---------------------+---------------------+---------------------+---------------------+----------+---------------------+------------+------------+-------+-------+---------+---------------------+---------------------+--------------+-----------------+------------------+-----------------+------------+-------+-----------------+
>|                     |
>|
>+---------------------+---------------------+---------------------+---------------------+----------+---------------------+------------+------------+-------+-------+---------+---------------------+---------------------+--------------+-----------------+------------------+-----------------+------------+-------+-----------------+
>SQLRowCount returns -1
>2 rows fetched
>
>Thanks
>
>  
>
I am, guessing its an issue with the definition of SQLLEN, try building 
2.2.13pre, that defaults the length the other way from 2.2.12.

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org

_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support



      Meet people who discuss and share your passions. Go to http://in.promos.yahoo.com/groups/bestofyahoo/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20080520/4be851a5/attachment.html>


More information about the unixODBC-support mailing list