DSXchange

Hi all,

Is it possible to create a copy of an existing job using Universe commands. I mean by using Universe SQL Commands. (Using insert sql statement).

Thanks,
bhasan.

No. Use the GUI.

hi Chulett,

May i know the reason. one more doubt am able to rename the jobs, move the jobs from one folder to another in Datastage 7.5. but am unable to do the same in Datastage 8.1. Are there any changes in the properties in the table DS_JOBS in 8.1 version.

Thanks,
bhasan.

Adding to the previous post.
-- I cannot rename and move the jobs using Universe SQL commands in 8.1 version.

You shouldn't really be doing this in any version, even if you think you know what you are doing. And yes, the architecture in 8.x is vastly different and that information is now stored in two places, things are not just in the 'Universe' repository anymore.

Thanks for your prompt reply chulett. May i know those two places where the details of the objects are stored?

In the original repository plus the new XMETA database repository.

Thanks again. How can we access that XMETA database repository? is it not in Universe database? I am interested to know the details. Please provide me the related links, where can i find those info.

Thanks,
Bhasan.

Talk to whomever set up 8.x for you, they had to choose DB2, Oracle or SQL Server for the XMETA repository. And a search here for XMETA should turn up a plethora of topics.

hi chulett,

Thanks for your patience in replying to all my questions.

Thanks,
Bhasan.