DSXchange

Alas, no. It is best practice to keep them all in a standard location, to make this kind of task easier.

Are you saying that there was a French character in the source file that was passed to either key1 or key2? DataStage should have no trouble with this! However SQL Server may require NVarChar rather than VarChar (or NChar rather than Char) and this may have engendered the data type mismatch error fr...

It is not clear in your logic where you are trying to USE this job parameter. What is the name of the parameter? Is it ID? Is it SrcFilter? What I'd be looking for in such an expression, to use a comma-delimited list in a single job parameter is an IN operator (which is actually not valid). To proce...

If the lookup fails, that is there is no payment, simply replace the null payment amount with zero. Use the NullToZero Transform. Or derive as something like:

G:\Tt is a complete pathname. What is the value set for ALLOWNFS in your uvconfig file? Have you tried accessing the directory using a UNC pathname?

Thanks for that input; those manuals are for version 7.0, but would serve as something to begin the OP's learning curve.

Welcome aboard. :D There's no such thing as dynamic blocking in QualityStage. You select one or more blocking fields in each match pass. For records even to be considered for matching, the blocking field values must be the same. Running multiple match passes with different blocking fields can help t...

You can use a lookup stage, specify a reject link to capture the unmatched inputs and set your Lookup Failed rule accordingly.

You could also use a right outer join; the rows with NULL from the left inputs are unmatched rows in the target.

Having posted that, I had second thoughts. The Framework is likely to be intelligent enough to do this just once, because the Lookup stage is a composite operator; first it loads the virtual data set, then it performs lookups against the virtual data set. Use Entire partitioning. Select Max(col&...

To paraphrase, do you want the overhead of selecting the (same) max value for every row you process? If so, you can do it in one job. A more efficient approach would be to select the max value in a prior job, park it somewhere (for example the prior job's user status area), then feed this value into...

Only for the non-default port number (31539).

Dunno. Should be. Try it, let us know.

Why is there a need to FTP anything? You can use diff right there on the DataStage server, surely?

Your best chance for an online site is IBM but, as far as I am aware, they have not posted the manuals for download. It might be worth contacting your local IBM office to request copies of manuals; most IBM offices are usually prepared to help in these matters. But learn to be patient - nothing happ...

JOBTYPE is the actual stored value. It is "" for a server job. JOBTYPEIND is a virtual field that replaces "" with 0. JobType = 0 for server job JobType = 1 for mainframe job JobType = 2 is Job Sequence JobType = 3 for parallel job <trivium> This is the chronological order that the job types became ...