QUERY UNIVERSE DATABASE
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 10
- Joined: Wed Dec 21, 2005 5:03 am
QUERY UNIVERSE DATABASE
I need to generate report by querying metadata in UNIVERSE database....is there any way to query universe database?
You can query UniVerse Databases with either the native query language INFORM or you can use standard SQL queries within the TCL environment. Note that DataStage is no longer UniVerse but they are clones and very similar. The IBM website offers all of the UniVerse documentation free of charge in PDF format for you to download.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you have genuine UniVerse (not DataStage) you can set up ODBC access to it.
I have also used an External Source stage to get data out of UniVerse into a parallel job. Construct a query that does not column wrap (perhaps using FMT to override the default field widths and setting the device width sufficiently wide). Wrap this in a uv, uvsh or dssh command as the command executed by the stage; its stdout will become the input link of the stage.
Example
I have also used an External Source stage to get data out of UniVerse into a parallel job. Construct a query that does not column wrap (perhaps using FMT to override the default field widths and setting the device width sufficiently wide). Wrap this in a uv, uvsh or dssh command as the command executed by the stage; its stdout will become the input link of the stage.
Example
Code: Select all
uv "LIST DS_JOBS ID.SUP NAME FMT '40L' JOBNO WITH NAME LIKE '1A0X'"
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Wed Dec 21, 2005 5:03 am
You use the Hashed file stage to access the Db directly, and you can access via ODBC with the dsn "localuv"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: QUERY UNIVERSE DATABASE
Why do you need to do it that way?ramank1981 wrote:I need to generate report by querying metadata in UNIVERSE database....is there any way to query universe database?
Perfectly good tools are provided "out of the box".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In a PARALLEL job?!!ArndW wrote:You use the Hashed File stage to access the Db directly
Can the Enterprise ODBC stage "see" the localuv DSN and, if so, can it make any sense of "DBMSTYPE = UNIVERSE" in uvodbc.config ?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ray - thanks for pointing that out, I saw hashed files and assumed that we were in the Server world and answered the question as posted (knowing that the answer wasn't going to help, since knowing which stages to use to query a database doesn't give you the tables required or the layout of columns in those tables...).
I will try the ODBC connectivity to Hashed files today in a PX job - I haven't attempted that before and you've piqued my curiosity.
I will try the ODBC connectivity to Hashed files today in a PX job - I haven't attempted that before and you've piqued my curiosity.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You could build a server shared container containing a UV stage. Read the end of Chapter 2 of Parallel Job Developer's Guide for the restrictions on what you can do using this approach.
You could use an External Source (or External Target) stage, as noted above.
You could use an External Source (or External Target) stage, as noted above.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 10
- Joined: Wed Dec 21, 2005 5:03 am
Can you please give us the URL from where we can download the mentioned PDF?ArndW says:
The IBM website offers all of the UniVerse documentation free of charge in PDF format for you to download.
Thanks in advance!
Nitin Jain | India
If everything seems to be going well, you have obviously overlooked something.
If everything seems to be going well, you have obviously overlooked something.