DSXchange

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. So the option should be to call the jobs from dsjob command with -warn option. So who ever runs it...

If you do a lookup on a b c d, you need the record on "e f g" or "e s t"?

Yes it can be followed with dsadm previlage.

Or use Kim's code at you Risk. * ------------------------------------------------------------ * EtlClearInstanceIDs * Decription: * This will clear instance IDs. * USE AT YOUR OWN RISK * ------------------------------------------------------------ * Parameters: * 1. JobName * -----------------------...

As the OP stated that input has many records when considiring first 4 keys and the duplicate rows are getting rejected during the key field mark. And would be able to get the full list only if all the six fields are marked as key. But its a very good valid point that, if the lookup is done only base...

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? If you are referring to Multiple instance jobs, better do a compile rather than tweaking aro...

Cleanup resource are generally used to clear the locks and not to stop the jobs. But ofcourse, if stop signal has been raised and if it didn't stop, ther should be a lock held in or as a part of it. You would not be able to compile unless you have full access to the Log file.

It is Hahsed file and not Hash file. And the hashing mecanism is for the whole keys rather than the keys. Its basically stores the data based on the order of the field. The position can be still changed while reading the file using the "Position" option. But care should be take while using this. It ...

Are the key that you lookup in the transformer are first 4 and not 3rd,4th,5th and 6th. If so change the order, maintain the same order while populating as well as lookup operation.

It shows the stop signal has been sent to server. It again depends on the current operation that been performed. Datastage will wait till the immediate thread to finish and initiate the stop signal. You will need to wait for a while, with some patience.

You can use Iconv()/Oconv() as well. If you already set with solution, pls mark the thread as resolved.

Its not Ray or Kim but its "Ray.Wurlod" and 'Kduke". You can find these names in first page under All time contributers.
Btw: What makes you to still to follow up for the code and not the auto purge mechanism.

Its a valid point given by Vincent, with which you can speak to DBA. If access is given to core functional tables, there is no point in restricting the system tables. After all, those are for supporting the business.

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., Director option won't affect if the job is been called by dsjob. Director setting is for e...

If do a search, you ll mostly end up in compiler issues. In addtition to that, do set PWD environmental variable in Admistrator to point to project directory or '.' to note the current working directory.