Genearating DDL via spreadsheet and trafer to Z/os



IBM's flagship relational database management system

Genearating DDL via spreadsheet and trafer to Z/os

Postby p19689 » 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
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

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

 

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

Postby prino » Sat Feb 04, 2017 3:40 pm

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!)
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 537
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 21 times

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

Postby p19689 » Sun Feb 05, 2017 10:13 pm

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
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby NicC » Mon Feb 06, 2017 2:34 pm

Try the ISPF Edit & Edit Macro manual.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times


Return to DB2