Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Capturing ddl using jcl & adding header to the captured

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
PRADEEP57

New User


Joined: 29 Dec 2011
Posts: 1
Location: india

PostPosted: Thu Dec 29, 2011 12:18 pm    Post subject: Capturing ddl using jcl & adding header to the captured
Reply with quote

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
View user's profile Send private message

prino

Senior Member


Joined: 07 Feb 2009
Posts: 1028
Location: Oostende, Belgium

PostPosted: Thu Dec 29, 2011 2:46 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10279
Location: italy

PostPosted: Thu Dec 29, 2011 2:51 pm    Post subject: Reply to: Capturing ddl using jcl & adding header to the
Reply with quote

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 icon_cool.gif
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Thu Dec 29, 2011 2:58 pm    Post subject:
Reply with quote

Try DB2LOOK.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Dec 29, 2011 3:23 pm    Post subject:
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10279
Location: italy

PostPosted: Thu Dec 29, 2011 3:27 pm    Post subject: Reply to: Capturing ddl using jcl & adding header to the
Reply with quote

IMBBW, but isn' t DB2LOOK a LUW only thing ?
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2435
Location: Netherlands, Amstelveen

PostPosted: Thu Dec 29, 2011 3:32 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Validating file with multiple header/... mohitsaini DFSORT/ICETOOL 6 Thu Apr 13, 2017 1:53 am
No new posts Adding records from two files into on... shiitiizz SYNCSORT 4 Mon Sep 19, 2016 8:41 pm
No new posts Adding a descending character to a file Steve Ironmonger DFSORT/ICETOOL 3 Fri Jul 15, 2016 4:57 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us