Genearating DDL via spreadsheet and trafer to Z/os

[p19689]

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

[prino]

I'm sure some clever-clogs can do it with Excel, but if I would be in your place, I'd save the lot as CSV file(s), transfer them to z/OS and write an edit macro to convert them to DDL. If the CSV format has a clearly defined format for each table, that has indicators as to what is what, my estimate for the time to write something is about half a day, but that might be too pessimistic. (Yes, pessimistic!)

[p19689]

Thanks Rob, can you please point me to a good refrence material on edit macro ? Even if it take couple of days it is still useful in the future too!

Regards,
Pete

[NicC]

Try the ISPF Edit & Edit Macro manual.