Skip to Content

Are "intersect" and "except" supported in SAP IQ?

Dear All,

As I remembered in ASA, I can use intersect and except in select statement, But when I tried it in IQ. I found this error --

Could not execute statement.

Feature, Unknown query block type, is not supported.
--
(optlib/opt_Driver.cxx 435)
SQLCODE=-1001030, ODBC 3 State="HY000"
Line 1, column 1

select * from #t1 intersect select * from #t2

Does it mean that "intersect" and "except" not supported in IQ? Thanks for your help.

Regards

Eisen

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 07, 2016 at 01:22 AM

    Hi,

    Yes, IQ does not support "intersect" and "except", "minus".
    You need to change the query like below.
    -----------------------------------------------------------------------------------------------------------------------------------------
    SAPIQ) SELECT a.product_id FROM inventories a, order_item b WHERE a.product_id = b.product_id;


    Vs.

    Oracle) SELECT product_id FROM inventories INTERSECT SELECT product_id FROM order_item;
    -----------------------------------------------------------------------------------------------------------------------------------------

    Best Regards,
    Gi-Sung Jang

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2016 at 07:05 AM

    Thanks a lot.

    Regards

    Eisen

    Add comment
    10|10000 characters needed characters exceeded