Page 1 of 1

Genearating DDL via spreadsheet and trafer to Z/os

PostPosted: Sat Feb 04, 2017 3:48 am
by 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

Re: Genearating DDL via spreadsheet and trafer to Z/os

PostPosted: Sat Feb 04, 2017 3:40 pm
by 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!)

Re: Genearating DDL via spreadsheet and trafer to Z/os

PostPosted: Sun Feb 05, 2017 10:13 pm
by 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

Re: Genearating DDL via spreadsheet and trafer to Z/os

PostPosted: Mon Feb 06, 2017 2:34 pm
by NicC
Try the ISPF Edit & Edit Macro manual.