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
 

 

ddl extraction

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

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Tue Feb 28, 2006 6:23 pm    Post subject: ddl extraction
Reply with quote

hi,

could somebody tell me how to extract ddls of tables from db2 on mainframes.

thanks in advance

regards
rashmi
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Tue Feb 28, 2006 6:43 pm    Post subject: Re: ddl extraction
Reply with quote

Hi rashmi,
In IBM , you can use ADBGEN utility. there are different tools in different companies for DDL extraction.


Thanks
Rags
Back to top
View user's profile Send private message
venky5436

New User


Joined: 06 Dec 2005
Posts: 12

PostPosted: Fri Mar 17, 2006 3:22 am    Post subject: Extract DDL in DB2 on Unix use db2look
Reply with quote

Extract DDL in DB2 on Unix use db2look

No idea about mainframes.
Back to top
View user's profile Send private message
astro

New User


Joined: 08 Mar 2006
Posts: 3

PostPosted: Fri Mar 17, 2006 4:38 pm    Post subject:
Reply with quote

One quick way in mainframes: if you have access to ADBL(DB2 Administration Tool Set ) utility, after selecting the required table, You can type ddl in the command line and press Enter key to get the ddl of that table.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 6:28 pm    Post subject:
Reply with quote

hy rashmi,

how you want to extract the ddl,
in batch or online?
in online: go to the db2 administrator from
ispf primary option menu, choose option g.d.2.a
and before any object like table, tablespace, database....
you can type the line command ddl. the dialog will
extract this or at least will generate a job which will
do this. save that job for the next time so you can
use it also in batch....

martin9
Back to top
View user's profile Send private message
rashmi.ranjan75

New User


Joined: 20 Feb 2006
Posts: 34

PostPosted: Wed Mar 29, 2006 3:33 pm    Post subject:
Reply with quote

thanks for your inputs

regards
Rashmi
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 Business Rule extraction frozenblood CLIST & REXX 9 Tue Dec 27, 2016 10:06 am
No new posts Record Extraction Mismatch from Header sri_gans CLIST & REXX 3 Mon Dec 08, 2014 8:23 am
No new posts Extended extraction liam,khaosong DFSORT/ICETOOL 3 Thu Jul 31, 2014 3:42 pm
No new posts Record extraction using JCL Sort Sumeendar SYNCSORT 12 Tue Apr 08, 2014 6:39 pm
No new posts Extraction of applications and jobs p... omprakash.mf IBM Tools 9 Fri Mar 28, 2014 10:05 am


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