SQL Reference for DataStage Universe Tables

Basavan · Post by **Basavan** » Fri Mar 30, 2007 1:12 pm

Hi,

I need some reference to retrive data from DataStage Universe tables.

Thanks

DSguru2B · Post by **DSguru2B** » Fri Mar 30, 2007 1:14 pm

What exactly do you want fromt he repository tables? Kim is the leader in querying repository tables. You can search for code by his id "kduke". There are others as well. Search will help.

Basavan · Post by **Basavan** » Fri Mar 30, 2007 1:22 pm

[quote="DSguru2B"]What exactly do you want fromt he repository tables? Kim is the leader in querying repository tables. You can search for code by his id "kduke". There are others as well. Search will help.[/quote]

Thanks DSGURU,

I need to see what are all the tables and looking to query job log from the tables into a file.

so, I need some SQL reference for list of tables and describe specific table like that.........!

Could you pls refer me or send if you have some info regarding that.

Thanks again.

chulett · Post by **chulett** » Fri Mar 30, 2007 1:46 pm

Rethink your approach - use the published APIs. There are 'DSGetLog' functions you can use from a job to accomplish this and command line equivalents as part of the 'dsjob' command if you prefer a scripted approach.

You also need to uncheck your 'Disable BBCode in this post' option.

DSguru2B · Post by **DSguru2B** » Fri Mar 30, 2007 2:31 pm

Craig is right. Use the dsjob command to redirect your log to a file. Utilize the power of unix to parse your own custom log.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 30, 2007 4:53 pm

DataStage repository tables are deliberately bereft of metadata. This is primarily because "they" make use of the non-first-normal-form features of "UniVerse" to store objects and collections of objects, which can not be readily access via SQL. The other reason, of course, is to discourage hacking the repository. They reserve the right to change the structures in these tables, and have done so in the past. Stay with the API - it will continue to work when your hacks start to fail because of strucural or other changes. For example in version 8.0 you get your metadata by invoking a metadata delivery service, rather than querying repository tables directly - the repository may not even be on the same machine as the DataStage server.