If and else statements in SQL Query

[Melvin Reynold]

Im getting this error using Aqua Data Studio for below query. Thanks.

>[Error] Script lines: 1-13 -------------------------
ERROR: syntax error at or near "IF"
Line: 1

IF CODE = 'ROU3V' THEN
	 INSERT INTO PTRREPO_UNSUCCESSFUL_SUBTYPE_REF
	 (ID, CODE,  DESCRIPTION, GROUP_CODE, CASE_TYPE_ID, DISABLE,SORT_PRIORITY)   
	 VALUES 
	 (#ID#, #CODE#,  #DESCRIPTION#, '3RD PARTY VOL', #CASE_TYPE_ID#, #DISABLE#, #SORT_PRIORITY#)
	 ELSE
	 INSERT INTO PTRREPO_UNSUCCESSFUL_SUBTYPE_REF
	 (ID, CODE,  DESCRIPTION, GROUP_CODE, CASE_TYPE_ID, DISABLE,SORT_PRIORITY)   
	 VALUES 
	 (#ID#, #CODE#,  #DESCRIPTION#, '3RD PARTY UNVOL', #CASE_TYPE_ID#, #DISABLE#, #SORT_PRIORITY#)
END

[Jeanne Boyarsky]

Melvin,
To the best of my knowledge, SQL doesn't have an if statement. Is that a database specific command/stored procedure? What database are you using?

[Melvin Reynold]

Im using this statement in XML. For the database i think its DB2.