DSXchange

Thanks Ray. So here is the final solution: INSERT INTO DICT DS_JOBS (FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC) VALUES ('DEPEND_TYPE', 'I', 'RAISE(TRANS("DS_JOBOBJECTS","J\": @RECORD<5> :"\ROOT",32,"X"))', 'DependType', '3R', 'M', '...

They did not change the way common works. It has worked the same way for many years. Common values are retained across one connection to Universe. If a job is broken down into multiple processes with different connections then common values are not retained. Based on the complexity of a job is when ...

The same error because they are synonyms.

I tried several ways and Universe breaks down. This is the closest I could get. SELECT DS_JOBS.NAME, DS_JOBS.CATEGORY, EVAL DS_JOBOBJECTS."@RECORD<32>" FMT '3R', EVAL DS_JOBOBJECTS."@RECORD<31>" FMT '35L' FROM DS_JOBS, DS_JOBOBJECTS WHERE DS_JOBS.NAME = 'SeqMemberDim' and DS_JOBS...

SELECT EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',32,'X')" AS DEPEND_TYPE FMT '3R', EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',31,'X')" AS DEPEND_JOBS FMT '35L' FROM DS_JOBS WHERE NAME = 'SeqMemberDim' ; 1) EVAL is used to create a dictionary it...

I hate it when things blow up tragically. Nice blow ups are so much better ways to die. I think what Ken is saying is there are failures which DataStage can easily trap. This jobs will end under DataStage control. There are other times when a job fails by violating something that the OS does not all...

This link might help. http://www.dsxchange.com/viewtopic.php?t=88496

That is okay, in Texas we have the three R's, readin, rightin and rithmatic.

If you cannot add this to your script then let me know. It should not be hard to parse with perl. I know I can do it in Korn shell. I do not know perl as well as Korn.

Ray is correct on everything listed. A lot of hacking made this possible and some good Universe skills.

You guys need to add code tags with Alt C. Here is the SQL. SELECT EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',32,'X')" AS DEPEND_TYPE FMT '3R', EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD<5>:'\ROOT',31,'X')" AS DEPEND_JOBS FMT '35L' FROM DS_JOBS WHERE NAME =...

Dhiraj

Post your script please. I might be able to explain how to get all the jobs attached to a sequence.

I don't think so. This is a runtime option for the person running the job.

It can be set in your Director for that PC. It is probably stored in the registry. You might be able to write a simple VB program to do it.

Not really. The exception handler traps any event that you do not trap yourself. So if you trap executed ok and warnings then it will trap any other return value. If you only have an OK link then warnings will go thru the exception handler. The UtilityAbortToLog is so this sequence aborts so the par...

That is why you have to run UtilityAbortToLog to show this sequence as failed or aborted.

The good part of this is to automatically start where it failed. It works great.

You need to also check add checkpoints so sequence is restartable. You need an exception handler stage. We usually route this to an email notification and a routine activity which calls UtilityAbortToLog.