DSXchange

Please post the exact, and complete, error message.

Service Pack 3 for Windows XP is currently being shipped by Microsoft. Does anyone have any information about the potential impact on either DataStage 7.5x2 or Information Server of installing this service pack?

Don't bother telling me it's not a supported operating system - I do know that.

I have never had a problem with DSJ.LINKROWCOUNT in either server or parallel jobs. How do you know it's the wrong count?

Parallel Job Advanced Developer's Guide (version page 801. There is no mention of an explicit equivalent of DSJ.ME because, in the C API, you have to declare the appropriate structure before you call DSOpenJob().

Cartesian product.
Inner join or left outer join.
Right outer join.
UNION ALL.
Difference (sometimes called "minus").

The "dates", which are actually strings, can be compared. What dates exist in the hashed file? Are the dates on both inputs identically trimmed and formatted?

That doesn't help.

Show us some examples of data on both inputs, together with what you expect to get on the output.

Also show us what you have tried, and explain more fully what you mean by "does not work".

Put your expression in a 'test harness' (a small routine) then test to ensure you are getting what you think you are getting from it, as Craig suggested. This is how you find out whether it will work or not.

The Routine editor has its own, inbuilt, test utility.

Only the first two of those are Linux, and represent the complete set of supported Linux platforms (and then with reasonable restrictions such as you have not modified the kernel code).

AIX, HP-UX, and Solaris are examples of UNIX (not Linux) platforms on which Information Server is supported.

Of course you could us a Routine activity to invoke UtilityRunJob (an SDK routine). Rohan, you're only right in a very limited sense. DataStage jobs always run in the background so that a run request (which starts that background processing) returns immediately even if it itself is not a background ...

Every If needs its own Then and every If needs its own Else. Write out your requirement in English (if you don't have it already in a design specification) and post that here. There is a far more elegant solution available using Index() function, but you need to learn how to code the IF expression i...

It's a DataStage patch, called ds_xpsp2. Ask your support provider to obtain it.

You need to purchase one specifically for Excel if you want to read directly from the worksheet. If you want to work from a CSV or TXT dump from the worksheet then a text driver would work, but you need to organize for the dump to occur.

It is not an If command; it is an If expression. Therefore every part needs an Else part (since the expression must produce a result) and there is no EndIf. Take some time to analyze your logic. In particular Not(A) Or Not(B) is always true. Write out your requirement in English (if you don't have i...

Import > Table Definitions > Orchestrate

will invoke orchdbutil when that particular option is selected in the dialog - you don't need to learn the intricacies of the orchdbutil command itself.