DSXchange

Are you really running DataStage 5.x? Also, what stage and exact Oracle client version are you using?

Hmmm... not only will you have to add that to every job, but there will be times when you'll want to run a job manually because Something Has Gone Wrong - and this will prevent that. However, if that works for you... I guess you could create a little wrapper job, a job that runs a single job 'under ...

The job is *not* running but its status is stuck there. Clear Status File from Director is the answer, as noted.

Have you tried searching the forums for your error message?

That's a good bit of information and not something I've seen before. I tend to sleep short periods and while awake, poll for interrupt 'flag' files touched into existence with certain names.

Yes, they will. When I've played these games, I make sure the string values are all the same length and zero padded to avoid the 'row out of sequence' error.

When i checked the log , the SQL appears as DELETE FROM CENADM.TEST_A WHERE C4<ADD_MONTHS(SYSDATE,-6) and :1=:1 i.e parameters are not replaced (:1=:1). Is this causing a problem Nope, the log always shows the sql with the parameter markers. Make sure your single trigger column is marked as a key a...

Search the forums for USERSTATUS, it is one of the easiest ways to pass information between jobs in a Sequence.

While there is the option to mark something 'Read Only', that is for protecting the design itself - Designer may be used to look at the job but cannot be used to change the job. It has no bearing on it being runnable or not. I don't believe there is any way to disable the 'Run' option from Director.

When we try to compile and execute, the jobs gives several different kinds of errors You may want to list the details of these 'several different kinds of errors' and let us know which are from the compile step and which are from the execute step. Have you tried a 'force compile'? Does your job inc...

While I don't believe there is a graceful way to select the first ten rows in a table without using a where clause, there are certainly ways to process the first ten records in a table. As Ken notes, for Oracle you can do something with rownum and 'having' with aggregate functions to fake it out: se...

And what did they say the answer was?

The suggestion was based on your earlier post where you said: Actually, with my original design, I'm using the data in each file to lookup to a table and a hash file. Now that you've clarified you are using the filename and not actually any 'data in each file' for that, the suggestion can be ignored...

There's no log. What typically doesn't come up it the dsrpcd processes, is that your issue? If so, try searching the forums for either 'bind bombed' or '-d9' to see how to debug the issue.