sql file to add columns only if needed

[2Fuzzy4U]

After tackeling my upgrade scripts for Oracle, SQLServer and SQLAnywhere now I starting with DB2.

I'm trying to write an upgrade script that adds column and/or data only if the column doesn't exist yet.
However I can't seem to find the right documents or info to get a good start.
I guess I already have the part that defines the sp which should return me 0 or 1 occurences of the column.
But I don't know how to collect the result.

If somebody has an example or can point me to a realy usefull website?

Greetzzz
Coretta

 

[gregsimpson]

http://www7b.boulder.ibm.com/dmdd/library/techarticle/0203yip/0203yip.html

Cheers
Greg