DB2 - IF EXISTS statement

marisalondon · New User Joined: 21 Aug 2009 Posts: 10 Location: London

Hi

I am trying to run a SQL sentence using a batch job (JCL is successful). The SQL sentence is introduced in a file.

Purpose to be able to
SET CURRENT SQLID = ‘XXX’
CREATE SYNONYM BBB for XXX.BBB

The problem is that if the synonym exist, then it fails (RC=8). I tried to DROP, but again errors out if it doesn’t exist.

At this point, we tried to use IF EXISTS.

We are trying with:

IF NOT EXISTS (SELECT * FROM SYSIBM.SYSSYNONYM WHERE NAME = BBB) THEN CREATE SYNONYM ...

The errors SQLCODE -104 (Illegal exists)

Any suguestions?

Thanks,

sushanth bobby · Posted: Wed Nov 11, 2009 6:09 pm

Hi Marisalondon,

IF statements are used in stored procedures, not in a query processor.

Sushanth

saiprasadh · Active User Joined: 20 Sep 2006 Posts: 154 Location: US

Hi marisalondon,

Can you post your drop statement. Did you commit after drop?.

Thanks
Sai