hi ,

this is prasath,

i am new to db2,

i am in need to ALTER TABLE ADD COLUMN IF THE COLUMN DOES NOT EXISTS<

is it any solutions for this ?

if any possible solutions please reply me

Thanks and Regards

Prasath A

If you try to add the column and it already exists, then the add will fail. If you try to add it and it does not already exists, it will succeed. You can do this one of two ways. You can check if the columns already exists by querying syscat.columns, or you just try to add the column and handle the error if it already exists.

Andy

CREATE PROCEDURE PR1
BEGIN
IF NOT EXISTS(
select * from SYSIBM.syscolumns where tbname='S_2' and name='NAME' ;
)THEN

ALTER TABLE S_2 ADD S_2_FIRSTNAME VARCHAR(250);
END IF;
END

actualy am using the above procedure to get do the stuff.

but the procedure is not created shows some error,

i have get the code to find the column is already exists or not

but the procedure is not created ,

can u please reply , what could be the issue

thanks and regards

Prasath A

How would I know what the problem is? You did not supply the error you are getting.

Andy

can u able to give me the code for alter the table add a column if the does not exists,if exists dont add.

thanks and regards

Prasath a

First, you must include a schema name in your query or you may not check for the right table. Then you may have to use dynamic SQL instead of static SQL for the ALTER TABLE statement.

Thank you stolze