unable to find object in repository

ketfos · Post by **ketfos** » Wed May 04, 2011 3:10 pm

Hi,

One of job uses a table claimseq defined under data source localuv.

How do I find this object in the repository?

Thanks

Ketfos

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 3:29 pm

Which repository are you asking about? The localuv data source is the project itself, the table is a UniVerse table (created with a UniVerse stage). Why do you need to find this object? Has anyone bothered to import the table definition for this table? If not, it probably does not exist in the repository at all.

ketfos · Post by **ketfos** » Wed May 04, 2011 3:55 pm

Why do not I see the table name under the folder Table Definitions - Universe - localuv

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 4:15 pm

Because no-one has imported the table definition!

ketfos · Post by **ketfos** » Wed May 04, 2011 4:22 pm

This is what I did

I logged into administrator (8.1 datastage) and ran the following command

CREATE TABLE "testseq"("Seq" NUMERIC(11, 0) NOT NULL PRIMARY KEY, "Uniondata" VARCHAR(70) NOT NULL);

Now in my job if I try to view data in this stage, I get a message - No data.
This is correct as table is empty.

Why I am not able to see the table name in table definitions?

Thanks
Ketfos

ray.wurlod · Post by **ray.wurlod** » Wed May 04, 2011 4:45 pm

Which part of "Because no-one has imported the table definition" is not clear?

ketfos · Post by **ketfos** » Wed May 04, 2011 4:52 pm

Hi Ray,

You are correct.
I went to the table definitions - import table definitions - import Universe table definitions - selected the table and was able to import the definition and see it in the localuv tab.

Thanks for help and follow up to resolve the issue.

Ketfos