Page 1 of 1
Where is DS tables ???
Posted: Sun Mar 18, 2012 9:42 pm
by atul9806
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
Posted: Sun Mar 18, 2012 10:17 pm
by ray.wurlod
This information is not publicly documented, a deliberate decision by the vendor.
Posted: Mon Mar 19, 2012 1:05 pm
by atul9806
Thanks Ray
But at lease we can query these tables or not ??
if yes, how come ??
Posted: Mon Mar 19, 2012 2:08 pm
by stuartjvnorton
If you have a database user with the appropriate permissions, then yes you can.
Posted: Mon Mar 19, 2012 3:05 pm
by ray.wurlod
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.