Query de SQL a Hana

[kriptonniano]

Hola buen día amigos del foro.
Alguien me puede apoyar o decirme donde esta mi error al convertir este query de sql server a Hana:
SQL SERVER:

IF @transaction_type IN ('A') AND @object_type IN ('4')
BEGIN 
	IF((SELECT "U_ts_sic_estatus"  FROM OITM WHERE "ItemCode"=@list_of_cols_val_tab_del) = 'P')
	BEGIN
		UPDATE OITW 
		SET "U_TS_SIC_Estatus"='P'
		FROM OITW 
		WHERE "WhsCode" IN (SELECT "WhsCode" FROM OWHS WHERE "U_TS_SIC_CodExt" IS NOT NULL);
	END;
END;

HANA STUDIO:

IF (:transaction_type='A') AND (:object_type='4') THEN
			BEGIN 
					IF((SELECT 
								"U_ts_sic_estatus"  
					FROM OITM 
					WHERE 
								"ItemCode"=:list_of_cols_val_tab_del) = 'P') THEN
			END;
			END IF;
			BEGIN
					UPDATE OITW 
					SET 
							"U_TS_SIC_Estatus"='P'
					FROM OITW 
					WHERE 
							"WhsCode" 
					IN (SELECT 
							"WhsCode" 
					FROM OWHS 
					WHERE 	"U_TS_SIC_CodExt" 
					IS NOT NULL);
			END;
END IF;

ERROR:

[Fer_Munoz]

Hola @kriptonniano,

En HANA no se puede usar un SELECT dentro de un IF.

Tendrias que sacar el select afuera, setear una variable y luego llamarla

DECLARE a INT;
SELECT 1 INTO a FROM DUMMY.

SALUDOS.

[Fer_Munoz]

@kriptonniano

IF (:transaction_type='A') AND (:object_type='4') THEN
     SELECT "U_ts_sic_estatus" INTO a  FROM OITM WHERE "ItemCode"=:list_of_cols_val_tab_del;
	IF( a = 'P') THEN
	
					UPDATE OITW 
					SET 
					  "U_TS_SIC_Estatus"='P'
					FROM OITW 
					WHERE "WhsCode" 
						IN (SELECT "WhsCode" FROM OWHS WHERE "U_TS_SIC_CodExt" IS NOT NULL);
	END IF;		
END IF;

Creo que seria algo asi