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

jothi libitha libithashanmugam at yahoo.com
Tue May 20 13:28:50 BST 2008


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


----- Original Message ----
From: jothi libitha <libithashanmugam at yahoo.com>
To: unixodbc-support at easysoft.com
Sent: Monday, 19 May, 2008 1:32:49 PM
Subject: select on date in Timesten throws "Numeric value out of range"


Hi,
I have Timesten 7.0.3 installed on RHAS 4.1 64 bit system. I have unixODBC 2.2.11 installed and I use the same to access TimesTen database with DBD::ODBC from 64 bit perl.

I have a table that has a varchar field and date field. Whenever I try to do a select on the date field, I get the following error

DBD::ODBC::st fetchrow_arrayref failed: [unixODBC][TimesTen][TimesTen 7.0.3.0.0 CLIENT]Numeric value out of range (SQL-22003)

The same program works well with 32 bit TimesTen client and perl
installation.  I did a DBI trace and noted only difference between the
two: field type recognition

32 bit perl (working)
col  1: TIMESTAMP (93) len= 16 disp= 21, prec= 20 scale=0
col  1: 'CHANGED_TIME' sqltype=TIMESTAMP, ctype=SQL_C_CHAR, maxlen=21, (dp = 0, cp = 0)

64 bit perl (erroring out)
now using col 1: type = unknown (0), len = 16, display size = 16, prec = 20, scale = 0

Could someone tell me where the problem is and how can it be solved?

Thanks,
Libitha



________________________________
 Has your work life balance shifted? Find out.


      Unlimited freedom, unlimited storage. Get it now, on http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20080520/9d23a89f/attachment.html>


More information about the unixODBC-support mailing list