In our application, we support multiple types of databases namely
IBM DB2 (both UDB and ZOS),
postgresql and So on. Currently we are maintaining separate DDLs and DMLs for each of these different databases.
It is difficult to maintain these multiple set of DDLs/DMLs and moreover in future our application might support few more database type.
What will be the best approach if we want to maintain a single set of DDLs/DMLs?