DB2 equivalent for MySQL's DROP .. IF EXISTS

Is there an equivalent in DB2 for MySQL's (or PostgreSQL's):


DROP TABLE IF EXISTS sometable;


No.

You'll need an IF clause to check for the existence of the table and then a separate statement to actually drop it if it does exist.

StackExchange Database Administrators Q#9535, answer score: 4