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 for Me (Login required).

Search for additional results

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