we tried like this,
IF STATUS=1 THEN 'ACTIVE' ELSE 'INACTIVE

but we got the query like this,

SELECT DISTINCT
BT_RESOURCECATEGORY_RESOURCE01."IF STATUS=1 THEN 'ACTIVE' ELSE 'INACTIVE'" AS COL0
FROM
RAMS.RESOURCECATEGORY BT_RESOURCECATEGORY_RESOURCE01
,RAMS.RESOURCETYPE BT_RESOURCETYPE_RESOURCETYPE
WHERE
( BT_RESOURCECATEGORY_RESOURCE01.TYPE_ID = BT_RESOURCETYPE_RESOURCETYPE.ID )
AND
(
(
BT_RESOURCETYPE_RESOURCETYPE."VALUE" = 'Software'
)
)

Here the if statement is appearing after the table name.

Please Advice how to resolve this issue!!!