Exception: DBD, MicrosoftODBC SQL Server DriverSQL ServerStatement(s)

[Former Member]

Hello Experts,

When i put the following SQL statment in the Univesre i am getting the error.

Exception: DBD, MicrosoftODBC SQL Server DriverSQL ServerStatement(s) could not be prepared.State:42000

Code.

QAS.qas.CRMD_ORDERADM_I.ORDERED_PROD = QAS.qas.ZCOMV_PR_CAT.PRODUCT_ID AND

QAS.qas.CRMD_PARTNER.PARTNER_FCT= CASE QAS.qas.ZCOMV_PR_CAT.CATEGORY_ID_MAST WHEN 'ZUCORD' THEN 'ZCRMBY' ELSE '00000001 ' END

Regards,

Shiva Kumar G.C

[Former Member]

Ans

[Former Member]

The correct syntax for case statements is:

CASE WHEN condition = outcome then result WHEN condition2 = outcome2 then result2 ELSE result3 END

I think the first bit is a touch disjointed.

What is the logic that you are trying to represent?