DSXchange

Hi DSXians, May I know how to create indices for all the project hash files. (DS_JOBS, DS_JOBOBJECTS, DS_CONTAINERS,DS_ROUTINES, DS_METADATA....) When I do a REINDEX it gives me File "DS_JOBS" has no indices defined! like wise for all the files. I need help to identify the index columns an...

Sorry, Actually I used the command as you mentioned in other post. (With the the key word SCHEMA).
May I know the Insert command used for UV.ACCOUNTS.

What type of join you make. If it is a full outer join, Is the LeftRec and RightRec has uniqe identification? Where you check for the match and unmatch?

say if this is the project folder /usr/Ascential/DataStage/Projects/Project2 All of a sudden I got lot of folder under /usr/Ascential/DataStage/Projects. With the name of Project2_nnnn. Nearly around 3000. It all contains Type 30. OVER.30,DATA.30 present in it. By any change its due to the command V...

Can you explain the job structure?
What is the key in the lookup and what is the role of 'Role_Id' in the lookup?

How about the column 'Role_Id' is it occuring more than once in the lookup?

ArndW wrote:Yes, you need to get rid of the references in UV_SCHEMA as well.

I think it is not same as UV.ACCOUNT. Should I need to use ED.
If so, may I know what is the exact commands.

Hi DSXians, I have deleted a project. Some issue raised to delete the project from Adminstrator client, hence I delted from Unix and performed DELETE FROM UV.ACCOUNT WHERE @ID = 'project' It got deleted. Where i perform SELECT * FROM UV.ACCOUNT WHERE @ID = 'PROJECT' it gave me 0 records. When I crea...

Sorry for confusing in the same thread. I ll start a new thread.

Kumar, editing the UV.ACCOUNT should be sufficient. What happens if you try a "LOGTO Project2"? It sounds like your changing the values in the editor didn't quite work correctly. {project} is not a valid account name. Is for the one which was deleted from unix, UV.ACCOUNT but cannot be recreated wi...

That was due to wrongly used Wild Chard character. But One of the project is completely removed. But still it gives me error that 'Schema already present, If I recreate with the same name. I have deleted the account. No project directory exist in Unix. And any idea about this issue?? SELECT * FROM ...

No, not VERIFY.SQL (this fixes UV_SCHEMA). Yes, you can use a regular INSERT, or even a copy. Maybe ED is even better; open an existing project's record, replace the pathname and file as the name you accidentally deleted. For example, if you deleted Project2 (pathname is /usr/Ascential/DataStage/Pr...

That was due to wrongly used Wild Chard character. But One of the project is completely removed. But still it gives me error that 'Schema already present, If I recreate with the same name. I have deleted the account. No project directory exist in Unix.

Hi DSXians,
I mistakenly deleted an accout in UV.ACCOUNT. May i know, the possibility to insert it back.
Note: The Project directory still exist in unix.

From Client command line 'dscc' can be used to compile jobs, but not sure about unix prompt.