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
insert location, conversion error , 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.
SAP Knowledge Base Article - Preview