Retrieve Partition type from Xmeta Query

bgs_vb · Post by **bgs_vb** » Tue Oct 09, 2012 4:00 am

Hi,

Using below repository tables ,i could retrieve jobname ,stagename and link names.

DATASTAGEX_XMETAGEN_DSJOBDEFC2E76D84,DATASTAGEX_XMETAGEN_DSLINKC2E76D84 ,DATASTAGEX_XMETAGEN_DSSTAGEC2E76D84

But I couldn't locate xmeta table storing stage properties ,specifically partioning information .

Please let me know if you have information on these xmeta tables .

bgs_vb · Post by **bgs_vb** » Mon Oct 15, 2012 12:28 am

Please let me know if you have information on these xmeta tables .

ray.wurlod · Post by **ray.wurlod** » Mon Oct 15, 2012 2:19 pm

No-one outside IBM has official information about the table structures in the common metadata repository. I have noticed that they change as new releases appear, so anything published would be immediately out of date.

eostic · Post by **eostic** » Mon Oct 15, 2012 6:12 pm

See if the information you are looking for is in a .dsx, especially a .dsx in xml format, which can be parsed if necessary, by DataStage to pull out what you need...

Ernie

DSXchange

Retrieve Partition type from Xmeta Query

Retrieve Partition type from Xmeta Query

Re: Retrieve Partition type from Xmeta Query