View previous topic :: View next topic
|
Author |
Message |
tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
My requirement is to fetch the table column names and its datatype by connecting from REXX program.
I'm to create the Cobol equivalent of the DB2 TABLE.
When a user types in the table name the table structure with its its column names should be retrieved so that the REXX program can convert the column names to its Cobol variable equivalents.
Is there a way to get the table structure from the BMC , if is can we connect the BMC to retrieve the same.Please help. |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
DCLGEN? |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
tecnokrat,
if you would take 5 minutes and describe what tools you have,
what you want to be able to accomplish,
you may get more productive suggestions,
than if you attempt to isolate what is a wall to you
for our suggestions;
nor will you receive the full bounty of our experience. |
|
Back to top |
|
|
tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
I want to build a tool which generates me the DCLGEN for a given table,obviously which is a new table.
At my shop we have to create the DCLGEN from the table structure so to reduce the pain i thot of this idea.
So when a user inputs the TSO <new table name>
The tool would search for its DCLGEN with the same name, if found then will ignore and if not found then would try to create the DCLGEN from the table column names and its datatype.
This is what i want.Please advice me in retrieving the table structure elsewhere like the BMC load or if any other. |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
I am confused. DCLGEN *is* a tool. |
|
Back to top |
|
|
tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
DCLGEN in the sense the Cobol equivalent for the table. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
And instead of wasting time writing an inferior tool, why not just run DCLGEN in the DB2 command sense? |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
DCLGEN is the name of the DB2 command that creates the "Cobol equivalent for the table".
It just so happens that it has become common practice to refer to the output of the DCLGEN command as a "DCLGEN".
The most common way to create a "DCLGEN" is to choose option 2 on the DB2I PRIMARY OPTION MENU. (i.e. the same menu where you find SPUFI). |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
thx for letting us know what you are trying to accomplish.
with that knowledge, members of the board were able to provide you with a solution to need,
and not your problem |
|
Back to top |
|
|
don.leahy
Active Member
Joined: 06 Jul 2010 Posts: 765 Location: Whitby, ON, Canada
|
|
|
|
dbzTHEdinosauer wrote: |
thx for letting us know what you are trying to accomplish.
with that knowledge, members of the board were able to provide you with a solution to need,
and not your problem |
It's another example of why terminology is important; people tend to throw around the word "DCLGEN" carelessly, but usually the meaning is clear from the context. In this thread it took a few tries before the TS explained what the context was. |
|
Back to top |
|
|
tecnokrat Warnings : 1 Active User
Joined: 22 May 2009 Posts: 160 Location: Bangalore
|
|
|
|
sorry for the ignorance.never explored the DB2i functionality.
Now, able to create the same thru DB2I. Thanks all. |
|
Back to top |
|
|
|