youngerk

Have anyone had the challenge to export DDL from IDMS for DB2

Discussion created by youngerk on Sep 29, 2014
Latest reply on Sep 29, 2014 by youngerk

Have anyone had the challenge to export DDL from IDMS for DB2 or other RDBMS.  How would you extract DDL statements for tables from an SQL schema that was copied from a non-SQL schema (Syntax: CREATE SCHEMA HGSCSQL FOR NONSQL SCHEMA HGSCHMA;) on the mainframe.  Then being able to modify the DDL statements for tables and use it to load table definitions into DB2 or SQL Server?  What tools, utilities, and/or system defined scripts would be of your chose to accomplish this task and that is not third party product?

Outcomes