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

Nick Gorham nick.gorham at easysoft.com
Tue May 20 14:19:49 BST 2008


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




More information about the unixODBC-support mailing list