I'm maintaining DDL files for deploying database changes, using the DB2 CLP. In some cases, the files are run at sites that have older versions of the database structures. At other sites, the database structures don't exist.

I've included Drop statements in the DDL files, which are run unconditionally. This results in errors at sites that don't have the structures. Does the DB2 CLP support conditional statemets (i.e. "IF" statements)? If so, could someone point me to some documentation or provide an example?

For what it's worth, I'm using DB2 UDB v8

No.

..........................