Symptom
A query of this general form produced an error in SAP IQ 15.4 ESD#3, while it worked with no error in IQ 12.7 ESD#10:
select 0
+(select sum (amount) from owner1.table1 where ddate ='20130306' and
column_key not in (3,17,30,130) )
+(select sum (amount) from owner2.table2 where ddate ='20130306' and
column_key not in (3,17,30,130))
...
+ISNULL ((select sum (amount) from owner1.table3 where
ddate='20130306' and column_key not in (3,17,30,130)),0)
+ISNULL ((select sum (amount) from owner2.table4 where
ddate='20130306' and column_key not in (3,17,30,130)),0)
...
Msg 21, Level 14, State 0
SQL Anywhere Error -1001030: Feature, scalar value subquery (at line 9) inside a
conditional expression (CASE, COALESCE, ARGN, NULLIF, or IF), is not
supported.
-- (opt_Select.cxx 2241)
Read more...
Environment
- SAP IQ 15.4 ESD#3
- Red Hat Enterprise Linux 5.8 64-bit
- 64-bit Intel Westmere machines with dual six-core CPUs with Hyper-Threading Technology
Product
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.