DSXchange

U r right Kumar, But that shell script needs to be called from sequence right?...What if that fails?

Might be silly to you. I tried it and got the following error.

ORA-06576: not a valid function or procedure name

Yeap.I have at the end. Sorry, forgot to copy that. Please see the below statement from Before SQL tab.

{call SP_CID_EXTRACT_CUST_DATA_FIX1()};

Yeap..Thanks for the response. I was just referring that auto-purge setting which can be done from Administrator.

Don't we feel sad that we can't set the warning option for a project?

Hi, I am trying to call SP from SQL --> Before tab by using the following command {call SP_CID_EXTRACT_CUST_DATA_FIX1()} but it gives the following error. ORA-00911: invalid character It is working fine If i call the same SP through script / sql prompt / toad. Can anyone help me in resolving the iss...

I am not talking about log purging in Administrator. Period.

I was thinking is there any option in server to control the warning limit....If not then it is slightly unconformtable of Data Stage where they would have given the option to set at project level.

We are 5 memebers in a team, if some one hasn't set the option in director which causing the job to abort. So if at all any option in DS Administrator (Like purging of log etc.,) i can set the option.

Is there anyways to override the client setting ? I am triggering the job from Director and wanted to take the option from Server if at all available. Because It will be an issue,if i didn't look the setup of director.

First it's not possible to use sub-set of key columns while reading hashed file. Even if he is getting only a part, there is no guarantee that he will get the same because of usage of less key columns.

Actually logout will kill the process but sometimes status in Director remains same. (Running) whereas it is not.So you can compile the job. It happened to me lot of times and i fixed in this way.

Well.You are right it's hashed file. I am not talking about the position of the key columns. What if partial key's are used during lookup?he is using only partial key columns.

How can i clear status file by script. I have an option in DS "Job --> Clear Status File" which clears all the instance of the job.I wanted to clear all the instances which ran one week ago? how to do that?

Could you please explain why you wanted to create hash file with 6 key columns when you are using only 4 for lookup. I don't think you can create hash file with 6 key columns and using only 4 key columns. Because Hash file work in the following way. When it stores the data, hash key will be generate...

Go to Director, Select the job and option "Job ---> Clean Up Resources". It will list the thread and Click Logout.It will kill the job. Sometimes in director the job status might not have changed,so open the job in Designer and compile. The status will be changed.

Hi,

Go to Director.Click "Tools --> Option" and go to Limits tab and set the option "No Limit" for warnings. After this setting jobs won't abort if it's called from sequencer / job control / unix script etc.,