SAP Knowledge Base Article - Preview

2495580 - Setting a null equal to a null on a date - SAP IQ

Symptom

  • Setting a null equal to a null on a datetime column causes a failure.
  • For example, running the following command:

create table #sue1 (authorization_date datetime null, transaction_date datetime null)
insert #sue1 values(null, '2017-03-03')
insert #sue1 values(null,null)
update #sue1 set authorization_date =transaction_date
WHERE authorization_date IS NULL

  • Returns the following error message in IQ 16.1

Could not execute statement.
DateTime is invalid (0)
-- (oslib/hos_date.cxx 55617)
SQLCODE=-1006167, ODBC 3 State="HY000"
Line 1, column 1


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

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.