DSXchange

It's not clear from your description. Do you want to select rows alternately from each of the two source files? Are there any other constraints that you haven't included? Are the source files guaranteed to have the same number of rows as the other?

You might find it easier to convert the time within DataStage. Split the timestamp into date and time components, and perform the arithmetic. A small routine is probably easiest. FUNCTION AddHoursToTimestamp(TheTimestamp,Hours) * Error handling has been omitted for clarity. * I have assumed ...

DO NOT, whatever you do, attempt to edit these objects using a UNIX editor. You WILL corrupt them by doing so.

That's true. Even if you disable prompting for all parameters, the Job Run Options dialog will appear, in case you want to enable stage tracing, set limits, and so on. I don't believe this can be disabled.

Most stage types that connect to database tables have a property called something like "rows/transaction". This governs how frequently a COMMIT is sent. It is based purely on row count, not on any grouping in the data. In server jobs there is also the ability to perform "tranaction control" in an OD...

Type 4 : Like Type 2, but the history is maintained in a separate table.

No. DataStage reports everything that is returned from the data source or, in this case, the ODBC driver. That's all you get. That's all you can get. One of the values in your data is inappropriate for the data type to which you are directing it. I'm also curious about the leading "." on the table n...

I am not certain. There may be an 8.0.2 for some platforms. Check the IBM website or your account rep for up to date details.

You can save a Decimal(38,0) in a String(max=40) but not successfully in a String(2). Think about why that is.

DSBINARY relates to version 5.2 and earlier. DSBPBINARY was introduced (as a direct replacement) in version 6.0.

The only way to suppress prompting for job parameter values is via the Set Defaults option in the Job menu in Director.

The prompt will appear even if the job parameter is an environment variable. You can prevent the prompt from appearing using Set Defaults from the Job menu in Director.

What happens if you execute ?

WTX = WebSphere Transformation extender, which is the successor to DataStage TX.

It is no longer a direct part of the DataStage family of products, and therefore is separately versioned.