DSXchange

previous i was using srvc_typ_cd_id<>'A' or srvc_typ_cd_id<>'Z' ...... This would have worked more better with an 'AND' between them, not an 'OR'. This expression gets you everything as not only are all other letters not equal to 'A' or 'Z' but 'A' is not equal to 'Z' (so it gets counted) and vice ...

Daddy Doma wrote:Do you believe that using the Job Activity stage would eliminate the issues about parallelism I am describing?

Yes.

For the record, that routine is meant to be used in a job - a Server or PX job, not a Sequence job - where you need to run a job using data from each incoming row from your source. For example, a sequential file containing filenames - read each record and run a job per record that loads that file. T...

...determine the values and pass it as hardcoded or as parameter. I know the Invocation ID and would like to do this. But I am not sure how. I should explain further - we are using the UtilityRunJob Routine Activity to call our parallel jobs. I'm sure there is a simple way to get the Invocation Id ...

Actually, generated SQL would give you a TO_DATE function with the mask that you noted. And as noted, simply tack on the zero time that the function requires if all you are getting is a date in the correct format.

I tried specifying multiple triggers from Job_Activity_1 that all use the same condition. In theory, the next three jobs should all fire at the same time. But according to the log in Director, they are occurring one after the other. I also tried inserting a Branch stage with one output link from Jo...

Post a sample of your data and the actual derivation you are using.

You need to set the Read Method to the option that allows a wildcard pattern.

You mean limit a job to use no more than 50% of a CPU? No can do.

I was wondering the exact same thing, if all we were talking about was a normal 'OK (Conditional)' trigger...

Narasimha, what makes you think that UserStatus is involved in any of this? All Vijay ever said was: i want to use variables in sequence. so used USER VARIABLE ACTIVITY.Actually i want to declare a variable called status and assign it value . User Variables stage. A variable called status. Then you ...

So now you two are some kind of search for hire tag team?

Ok, that was stoopie. Not sure why I decided to add an 'sh' onto the command:


Doh!

Have a test server's license expire over the holidays on 1/1/2007 and now having a silly problem. I was able to go into the Administrator and connect (in spite of the fact that the license is expired, nice) and successfully re-licensed it with the permanent license. It tells me the changes won't tak...

Arnd is 'semi-retired' and tooling around on his new boat that he seems to be living on now. He said he would be off and on (mostly off) as he lived the Good Life cruising ports for Wild Women. Or he might be working down under... not really sure right now. We'll have to see if/when he resurfaces!