SAP Knowledge Base Article - Preview

1950583 - IQ 15.4 - Insert location (IQ server 1 -> IQ server 2) of table with time columns causing conversion error

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.