DSXchange

Then the warning will remain.

If you want to know what jobs were actually called (which is a function of the logic within the job sequence) the best place to look is the log for the job sequence itself. The penultimate entry - apart from entries relating to auto-purge of the job log - is a summary of the sequence run.

Pattern matching in server jobs uses neither SQL wildcards, which your examples use, nor regular expressions. Instead they have their own idiosyncratic patterns, which you can read about in the DataStage BASIC manual. To get you started, the "any" wildcard is either "0X" or "..." and the single char...

Don't you mean "ally" as well as the inaccurate possessive pronoun?

It's a problem that you're remembering the old days (Prime), when the "" in the OPEN statement was necessary. If my memory serves it was made optional in about version 6 of Prime INFORMATION.

Waiting for nibble to respond with code and call before chasing any red herrings.

I don't think hostname is stored at the project level; only at the server level (unless you count the project's record in UV.ACCOUNT and UV_SCHEMA as being at the project level). You can always retrieve the hostname using the operating system hostname command, probably via a call to DSExecute subrou...

The error message suggests that some or all of the SYS.MESSAGE hashed file has been trashed, perhaps via a file unit management error. Can you please execute the following commands, either within the DataStage environment on the server or from the Administrator client command window and post the res...

A friend, knowing my interests in such things, sent me this URL today. I felt that I should share it.

You've only answered some of the questions I asked in an endeavour to diagnose what's happening. Please post the actual SELECT statement, and the results when the output from this query is directed into a text file. At least for a few rows. And post the precision and scale of the decimal data types....

There's no Trunc() function in DataStage BASIC. What is the source? What is the query that extracts data? Capture exactly what's coming from source, into a text file. Verify that the expected values are being delivered. Check the precision and scale of all the decimal numbers. What are the data type...

Although this tutorial is about integrating WebSphere Federation Server with DataStage, it uses RTI to do so and therefore may help you to compare your approach with the one they used. In particular, Section 3 is specifically about how to configure DataStage RTI to run the DataStage jobs as web serv...

Supply the invocation ID as a job parameter and use that as part of the file name.

I have no idea. That's why I said you would have to check with IBM.

You are missing initializing the surrogate key value with the result of SELECT MAX(Skey) FROM targettable
You then ADD the generated integer to this value.