Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Retrieve DDL Stmts through REXX

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CLIST & REXX
View previous topic :: :: View next topic  
Author Message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Tue Oct 23, 2007 1:05 pm    Post subject: Retrieve DDL Stmts through REXX
Reply with quote

Hi Friends,

I need to retrieve the DDL statements of the tables. Is it possible to retrieve the DDL statements ?

1. How to retrieve the DDL statements ? any table holds the statements ?

Any suggestions ?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Tue Oct 23, 2007 1:14 pm    Post subject: Reply to: Retrieve DDL Stmts through REXX
Reply with quote

Not directly...

You can rebuild the ddl incrementally navigating a few tables

for the basic create table You can retrieve the info
from SYSIBM.SYSCOLUMNS
and SYSIBM.SYSINDEXES

I did it once and it worked, I am afraid that the REXX script has gone..
I would have gladly posted it !
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Fri Oct 26, 2007 9:53 am    Post subject: Reply to: Retrieve DDL Stmts through REXX
Reply with quote

Thanks Buddy.

You have any idea, where the DDL statements were retireved for a given table( when we access platinum(tool) to retrieve DDL stmts) ?

Is it taken care by DBA's to specify location for the DDL ?

My current requirements is ,

I have around 800 tables and i need to take a personnel copy of these tabes under my qualifier in my database ?

So My tool has to accept the highlevel qualifier of prodcution table name, my database name and the qualifier.

It needs to create jobs for this unload and load process?

You got any suggestion about how to approach this problem ?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Fri Oct 26, 2007 12:17 pm    Post subject: Reply to: Retrieve DDL Stmts through REXX
Reply with quote

Quote:
I have around 800 tables and i need to take a personnel copy of these tabes under my qualifier in my database ?


if the ddl have been written properly ( without any qualifier EXPLICITLY specified),
executing the jcl to define the tables under Your (RACF,ACF,TSS) ID will
build everything under Your qualifier
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Fri Oct 26, 2007 12:39 pm    Post subject: Reply to: Retrieve DDL Stmts through REXX
Reply with quote

Yeah Buddy you are rt.

But DDL's have been built upon the qualifier, so my job becomes double.

I need to extract the DDL's , write a rexx to convert the qualifiers to mine and submit the same.

Is there anyother different option/view i can approach this problem?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10326
Location: italy

PostPosted: Fri Oct 26, 2007 12:46 pm    Post subject: Reply to: Retrieve DDL Stmts through REXX
Reply with quote

You mean that the dummy DBA' s of Your organization

wrote ...
CREATE TABLE(useless_qualifier.TABLE_NAME)
everywere

it' s hard to believe!!

How do they manage development, system_test and production ???

anyway the easiest thing is to put all the ddl' s in a single pds and then
1) change the useless_qualifier to nothing,
2) change it to Your userid.

Number 1 would be the best choice
You would get the result You need,
You would teach the dummies how to do things the proper way
Back to top
View user's profile Send private message
diwa_thilak

Active User


Joined: 13 Jul 2006
Posts: 205
Location: At my desk

PostPosted: Fri Oct 26, 2007 12:52 pm    Post subject:
Reply with quote

Yeah buddy.

I am going by your way, Now extracting DDL's manually becomes a problem.

Any automation we can do ?

i have a routine to change te the qualifiers and prepare unload/load jobs.

May be we two can automate this one and release the code in our forum.
Back to top
View user's profile Send private message
kgumraj2

New User


Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad

PostPosted: Fri Oct 26, 2007 4:02 pm    Post subject:
Reply with quote

Hi,
If you want only the DDL please use DCLGEN.
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 -> CLIST & REXX 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 write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 5 Wed Oct 04, 2017 6:54 am
This topic is locked: you cannot edit posts or make replies. Rexx to execute spool commands upendrasri CLIST & REXX 47 Fri Sep 29, 2017 1:08 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
This topic is locked: you cannot edit posts or make replies. Extract all "IF" Statements... Adarsh Damodaran CLIST & REXX 1 Wed Sep 06, 2017 9:28 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us