I want to have the following custom checks added in my CDM, can someone please help me with the VBA scripts for the same:
1. Check if all columns in all entities in a CDM have a data type assigned to it, for any column if the data type is empty, the powerdesigner should return an error.
2. Convert datatypes automatically, e.g all the columns having data type as BOOLEAN, should be converted to CHAR(1) automatically.
3. Reserved SQL keywords should not be used. E.g. we had an entity called ORDER, and we had to manually rename it to ORDERS