SAP Knowledge Base Article - Preview

1934885 - Error -1001030 Feature, scalar value subquery inside a conditional expression - SAP IQ

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

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.