DSXchange

So?

The -lognewest allows you to find the most recent "started" event, and you can use that information to filter what you get back from -logdetail.

It's probably easier to do this with a DataStage BASIC routine than with dsjob commands.

... which compiles to precisely the same code as the equivalent Field() function.

Find the stage in which an explicit collection algorithm has been specified and change it to (Auto).

Please begin a new thread. This error is about parallel execution and specifying an explicit collection algorithm, not about the Match stage per se.

Have you done investigation and standardization on these data?

My error.

Describe fully the Oracle-related environment variables that you have set up in your Windows server. Prove (for example via a DataStage log entry) that these are being picked up correctly by DataStage processes.

John's response was a COMPLETE ANSWER to your question, which only sought a three-character string. if 1st character of okcucl = 5 then 020 else two first character of okcucl = 65 then 030 else 001 You have now changed the question. We at DSXchange are not in the business of supplying a complete sol...

Time dimension table.

As I noted in my earlier post, "main" is not relevant in this case.

Partitioning is only ever set on input links. Data on output links will always be the same as specified on the main input link. In your case, the Join stage has its inputs partitioned identically, so "main" does not come into consideration.

Please explain in detail the steps you are taking to start:

• IBM Information Server
  
  WebSphere Application Server (ASB node)
  
  ASB agent (if required)
  
  DataStage server

Why?

You had a response to this very same question recently. And you have not provided the elaboration I requested there.

The score files *should* be automatically deleted - there is nothing to enable. They are cleaned up when the conductor process is closing down after all section leaders report that they have finished. If the automatic process can not delete them, then check with your Windows O/S administrator that t...

All four environment variable values are incorrectly set.

Search the forum for more information.