DSXchange

What happens when you Reset the job via the Director? Do any 'extra' messages labelled something like 'From previous run' get pulled into the log? I was having something similar happen and the reset showed the job was actually core dumping due to some funky SQL in an OCI stage.

The advantages are pretty well spelled out in the documentation, primarily the Server Job Developers Guide. Performance. Between the use of Row Buffering or IPC Stages, performance gains can be substantial, especially on multi-processor systems. As to the "why"... it just seems to be a bug. I've see...

Ah... the old "It's for your own good, Dear" ploy.

Sure, just simply... use the Job Parameter in the SQL! From either Column Generated or User Defined SQL, use the parameter like you would (almost) anywhere else - enclosed in pound signs. To extend your example: select emp_no from emp where dept = #DEPT# I've found that you need to enclose things in...

Derivations in Transformers are expressions, not assignments. See Ray's post at the end of this thread for an example. You'll need to write a routine to do what you are trying to do.

Yes, there is. It is set via the Administrator: Project -> Properties -> Tunables.

Do you have Row Buffering enabled? If so, try your job with it turned off and see if that solves it.

Hmmm... I don't think DataStage is supported on Windows 2003.

You could also do this with a hash if that's the way you want to go. Create one with a fixed key so it only has one record - like a "1" - and a data field to hold your number. Setup your job to do the lookup from and also write to this hash file. On each row, compute the number, do the lookup and co...

David, check your online help Index for "Bit functions". There is a whole series of functions you can use - BitAnd, BitOr, BitXor, etc. I would think you'll find what you need there.

Well, then you can't group them. For whatever reason, that is the rules of the game here.

They all have to come from the same Transformer. Is that the case?

Welcome. The ODBC stage is your only choice, as far as I know. Search on that keyword in this forum for many examples of how to configure your connectivity if you need help with that. Any of the passive plugin stages for database access should allow joins to be performed. You typically have a choice...

Is there a way to concat the string with a null value. No. Null is the unknown value, so adding null into any mix results in null as the output. You need to either explictly convert the nulls to something else or account for them in some if-then-else logic. Check out the Built-In Transform NullToEm...

Dig out your Client cdrom and look for a directory called something like "Unsupported Utilities". In there, you'll find the HFC - the Hashed File Calculator tool. Use it to find the ideal creation statement for your hash file based on # records, key types, etc etc.