|
View previous topic :: View next topic
|
| Author |
Message |
PRADEEP57
New User
Joined: 29 Dec 2011
Posts: 1
Location: india
|
|
|
|
Hi All,
Greetings...
it may look old topic but am unable to find the solution through the older posts.
I need to extract the ddl for all the possible objects from database level in mainframe, am using V7 Zo/s. That ddls have to be created by using jcl jobs.because manually putting HDDL infront of db would not helps because i have to deal with 1000+ db's. so please suggest me some sample jcls or the utilities in mainframe to capture the ddls.
After extracting ddls as file or member that database object needs a header record (example one header record for each table, one header record for each trigger, etc).
The file names can be whatever we like. I would propose that they be named DatabaseType_DatabaseTypeVersion_DatabaseName_SchemaName_YYYYMMDD.TEXT.
Please anyone help me in this. |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
| This is not a JCL question, this is a DB2 question and next to that, you seem to be utterly clueless about mainframe file naming conventions. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
OK... start it over again and speak slowly so that we can understand.
JCL will just do frigging nothing ,
( since Your profile shows ...
| Quote: |
Occupation: database administrator
Mainframe Skills: jcl,vsam |
You should already know that )
what tool/program do You plan to use
rebuilding the ddl is something that no vanilla/barebone DB2 install will provide.
the ball is in Your court now  |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| Try DB2LOOK. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| Your post is in JCL part of the Forum but you talk about DDL. I'll make a safe guess that by DDL you mean, Data Definition Language, aA series of Structured Query Language (SQL) commands used to define objects. But even though, I don't really understand what are you looking for? Do you want to say, there are some COBOL-Db2 Programs and you want to write out only the SQL part in some data-set? |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| IMBBW, but isn' t DB2LOOK a LUW only thing ? |
|
| Back to top |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
Yes Enrico,
looking at the dataset name my guess is a windows environment.
Beside that if it is one can connect to the DB2 subsystem on z/os
with db2look and then execute the ddl extracting command. |
|
| Back to top |
|
|
|
|
