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.