can we write the below case statments in Teradata 14.10

Database
Enthusiast

can we write the below case statments in Teradata 14.10

IF A.COL1 IS NOT NULL THEN B.COL1 AND C.COL1='Y'

PLEASE CAN ANY HELP ME HOW TO WRITE ABOVE IF THEN INTO CASE STATMENTS.

THANKS,

SANTOSH.PATIL

1 REPLY
Enthusiast

Re: can we write the below case statments in Teradata 14.10

Seems like when A.COL1 is NOT NULL then you want to insert/update C.COL1 with 'Y".

But insert and update can't be used inside the case statement!! 

You have to use stored procedure/macros to achieve this!! You can try merge options also.

Thanks!

-Sakthi