Symptom
- Insert location (IQ server 1 -> IQ server 2) of table with time columns causing conversion error
- Sample error from DBISQL
$ dbisql -c "uid=SA;pwd=****" -host <hostname> -port <port> -nogui yyy.sql
Could not execute statement.
Cannot convert to a time (column CREATION_TIME)
SQLCODE=-157, ODBC 3 State="07006"
File: "yyy.sql" on line 2, column 1
insert into abc.my_table(datetime_book, datetime_value, ...) location '<servername>.<dbname>'
{select datetime_book, datetime_value, ... from abc.my_table where datetime_book between '2012-Dec-06' and '2013-Jan-20'}
You can continue executing or stop.
1. Stop
2. Continue
Read more...
Environment
SAP Sybase IQ 15.4
Product
SAP Sybase IQ 15.4
Keywords
KBA , BC-SYB-IQ , Sybase IQ , Problem
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.