Db/2 LUW – Conditional Schema Creation

Background Wanted to explore what it will take to conditional create a schema in DB/2 LUW. Transact SQL In Transact SQL, it is straight forward. DB2 Stored Procedure ddlCreateSchema Outline Declaration Language :- SQL Atomic Code Find matching Schema in SYSCAT.SCHEMATA If none found, then create schema sql is 'CREATE SCHEMA ' || v_SchemaQuoted Prepare … Continue reading Db/2 LUW – Conditional Schema Creation