DSXchange

You must have at least one blocking field. Even if it's a constant in each file.

Got him by the testimonials!

As the Generator property for the field for which you want to generate the value.

Right click on this field in the Columns grid, choose Edit Row from that menu, and fill in the Generator property sub-options from the Available Properties to Add.

I didn't really mean that as a serious suggestion. And changing them would still invalidate the restart logic.

The whole point of restartability is to be able to restart the same job sequence as the one that failed. This includes its parameter values.

Use a Cycle with just one Value, "D".

See answer to your other post. A column called keyChange is usually the result of a Sort stage.

The Match stage does not compare two columns unless you use a two-file match with one column in each file. The Match stage compares rows within one file (searching for potential duplicates) or rows between two files (also searching for potential duplicates). I don't think you understand the role of ...

chulett wrote:Constraint?

Code: Select all

@OUTROWNUM = 1

Foiled by parallel execution!

Maybe

"Relpy soon" We do not do "urgent". DSXchange is an all-volunteer site, whose participants post as and when they can, if they have something to contribute. If you want rapid replies, sign up with your support provider for premium services, and be prepared to part with large amounts of cash in excha...

DataStage does not handle imaginary numbers, as far as I am aware.

If you mean "valid" numbers the Num() function is good to validate numbers in general, or you can use the IsValid() function if you want to limit the possibilities to a particular data type.

Disable operator combination and find out where the error is occurring. That may yield some ideas.

Nullable property must be "Yes" before the Nullable options become available.

Don't bother. Let Oracle work it out.

Try to do a single-job compile in Designer. If the job is locked, the message box will yield the session ID of the owner. Open the web console for Information Server, go to Session Management and disconnect that session. This will release the lock. This - I believe - is what Arnd was referring to.

Note that the Funnel stage requires identical metadata on all inputs, hence the constants in syeed's response. But why not perform a UNION ALL in the SELECT statement?