Where is DS tables ???

atul9806 · Post by **atul9806** » Sun Mar 18, 2012 9:42 pm

Hi Guys,
can anybody give me the details of DS tables and how to query them and where they all are existing ??

Thanks in advance
Atul Singh

ray.wurlod · Post by **ray.wurlod** » Sun Mar 18, 2012 10:17 pm

This information is not publicly documented, a deliberate decision by the vendor.

atul9806 · Post by **atul9806** » Mon Mar 19, 2012 1:05 pm

Thanks Ray
But at lease we can query these tables or not ??
if yes, how come ??

stuartjvnorton · Post by **stuartjvnorton** » Mon Mar 19, 2012 2:08 pm

If you have a database user with the appropriate permissions, then yes you can.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 19, 2012 3:05 pm

If you have access to the XMETA database you can see all of the table definitions. They're not all for DataStage, and there's no guidance about which of the 2000+ tables are for DataStage, so you're on your own there.