Query regarding access of internal DataStage repository

[Rea_Antony]

Hi,
I was gng thru the FAQ sections and noticed the following code:
Code:
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO';

I am assuming that DS_JOBOBJECTS must refer to a table(?) in teh datastage internal repository. I needed to know how I can access it..in the sense, how can i browse through these inetrnal tables?

The main reason for this query is that I am trying to find where datastage stores all the metadata information for all the jobs in a project.

Thank you in advance for your responses.

[Pierre]

Hi,

You can use dsadmin, or dssh command line to use SELECT on the internal tables.

exemple :

D:\Ascential\DataStage\Projects\Decisionnel>D:\Ascential\DataStage\Engine\bin\dssh
DataStage Command Language 7.5
Copyright (c) 1997 - 2003 Ascential Software Corporation. All Rights Reserved
DECISIONNEL logged on: Friday, September 26, 2008 10:53

>SELECT * FROM DS_JOBOBJECTS
SQL+


Object type........ J
Object record id... 2770
Object record name. V0S122P1
Description........

Object type........ J

[ray.wurlod]

I don't suppose you bothered to Search?

[Rea_Antony]

Yes, I did try. I came across lots of code stuff.. the only prob is that I have never coded so I cudnt make head or tail of it
Later, I came across a post which said one cud either write a routine or use the UniVerse. So, was trying out the second approach when I saw Pierre's reply. And after that was trying to search for more tables that I could query thru dssh... Its just that I don't have an overall picture and I'm kinda grasping at straws
Anyway, thank you very much for your response. Thanks to Pierre too

[ray.wurlod]

Click the Search link in my previous post.