DSXchange

Depending on your database's optimizer the following query may be more efficient, but it achieves the same result: select t1.col1, t1.col2, t1.col3 from TableA t1 where t1.col3 = (select max(t2.col3) from TableA t2 where t1.col1 = t2.col1); Just another way of looking at things.

Walter hates IE passionately, and uses only Firefox. So Walter may not be seeing the issue.

UtilityWarningToLog() is doable from the current job.

It's possible.

Why?

It's not possible. No record is kept of the state of indexes prior to rebuild. (The only choices in any case are "rebuild required" or "rebuild not required".) Craig's observation that reindexing will fail with other users in the project is accurate. You must, in this case, reindex with no users in ...

It is possible, but not because it's Enterprise Edition. You can install multiple versions of Server Edition also. But why do you think there's a need to? And - I suspect - IBM will want to get licensing revenue from each of them. The magic word here is "-itag". You install different engines with a ...

What the output looks like will depend on which command you instruct the Compress stage to use.

No, the diagnosis suffices. Thank you.

No.

And it would probably violate your licensing agreement also.

These are dates and times. I believe that the warnings are telling you that DataStage is using default formats.

And any other constraint that you may already have.

My #1 idea is to create jobs that do not fail.

Will these jobs be running consecutively or simultaneously?

So the required value is in a file and you want to pick it up to pass to another job as a job parameter. In the job sequence you have many choices, but probably the easiest is to use an Execute Command activity to cat the file; you can then use the "angle bracket" notation to get the appropriate lin...

Your two VarChar fields are unbounded (they have no maximum length). Is this deliberate?

Also, what you posted is not the record schema (which you can find from the generated OSH).

Please post the exact text of any error message you have received from this job. Otherwise we're guessing.