DSXchange

Hi,

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

How do I find this object in the repository?

Thanks

Ketfos

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.

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

Because no-one has imported the table definition!

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

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

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