Genearating DDL via spreadsheet and trafer to Z/os
Posted: Sat Feb 04, 2017 3:48 am
Hi ,
I have to create about 400 new tables from scratch. I have volumetrics , table names and column names and attributes in a spreadsheet for each table. Has somone tried the automation of this to produce a text file of the DDLs for Tablespaces, Tables and Primary Indexes (for minimum) ? Then to transfer to Z/os .
Many thanks in advance - Pete
I have to create about 400 new tables from scratch. I have volumetrics , table names and column names and attributes in a spreadsheet for each table. Has somone tried the automation of this to produce a text file of the DDLs for Tablespaces, Tables and Primary Indexes (for minimum) ? Then to transfer to Z/os .
Many thanks in advance - Pete