The new syntax IF EXISTS for CREATE and DROP TABLES (see https://ibm-data-and-ai.ideas.aha.io/ideas/DB24LUW-I-259) should also be generated by db2look on demand. This would help and simplify migration scenarios with db2look.
This should also be available for the undocumented stored procedure sysproc.db2lk_generate_ddl().
Why is it useful?
|Who would benefit from this IDEA?||migration scenarios|
How should it work?
add an option to db2look similar to -dp to create the new IF EXISTS commands on demand. It should not be the default for version migration scenarios.
|Priority Justification||for completeness and support in migration scenarios|
|Customer Name||Roland Schock|