DSXchange

If you generate YEAR upstream in the job sequence (maybe as a sequence parameter) you can use a Routine activity to generate the four date ranges, perhaps pass them back as delimited strings, and unpack them. For example the routine could return a dynamic array containing four fields each with three...

From memory that's PS1 values that contain a newline character. Is that so? What response did you get when you reported this previously?

Get your DBA to monitor what DB2 is receiving.

Welcome aboard. :D There is nothing "out of the box". There are several techniques you can use; all of them require some additional storage. Safest of all is to stage the results of your transformation in a load-ready area (Data Sets) so that your loads can be effected in the shortest possible perio...

Age
Use a stage variable svCurrentDate initialized to current_date().
Use DaysSinceFromDate() to get age in years. Divide by 365.249 to get age in years, then apply the floor() function to get age in completed years.

Date Difference
Use subtraction of Julian dates, as posted earlier.

SMP is everything in one machine - the fastname will be the same for all nodes in the configuration file. MPP is a cluster or grid - the fastname will have varying values in different nodes in the configuration file. For a grid, a dynamic configuration file is needed. That is outside the scope of th...

Now that you know where to find it, don't use it.

If you do, your complaints about performance will fall on deaf ears.

The easiest way is to preprocess the files so that they each have two additional columns, the file indicator and the row number (both of these can be generated by the Sequential file stage using optional properties).
Sort on these.
You can drop those columns prior to your final write.

You need to set the Null Field Value property (from the Edit Row dialog) even though you've handled nulls upstream. The value that you specify is what is written into the file if a null arrives on the input link. Alternatively, change the Nullable property to "No".

Sometimes it does - I've successfully combined string_trim and substring for example.

You have it exactly.

Use the job parameter references to replace constants in the WHERE clause of the extraction SQL. For example:

You can do this on the Selection tab - you do not need to resort to user-defined SQL.

If you want to implement something like the C break construct, you can use link variables from prior output links in constraint expressions. The REJECTED variable will be false if the row has been processed by any prior link. Or you can AND the current link's condition with the logical inverse of pr...

If it's any consolation, on older versions of Windows (we're talking 3.1 and earlier here) you had to edit an ODBC.INI file. That's why the Registry entry is still called ODBC.INI.

I don't believe that Windows 2003 is a supported platform for DataStage version 5.1.

Welcome aboard, and thank you for making an extremely valuable contribution.

We sometimes assume that posters in the US don't have NLS installed, but that's not always the case. And posters elsewhere in the world often do have NLS installed, of course.