DSXchange

You might also like to check (or ensure) that your script has all relevant environment variables, such as ORACLE_HOME, set.

Not "should", if you want correct results, but "must" use a key-based partitioning algorithm. Note also that the Join stage requires that its inputs be sorted by the join key(s). If both data sets are in the same database instance you may be better off performing the join there, where it may be able...

Happy New Year to all! May your celebrations be boundless, and your resolutions negotiable.

Post (fully) what's on each of the four tabs in your SCD stage. Without that it's difficult to diagnose. Verify your assertion that you have both a current indicator column and an expiry date column.

The Remove Duplicates stage gives you the choice of removing the first or last record in each group. Sort your data by LEAF_NUM_ID, LEAF_NODE and DESCRIPTION (and hash partition by LEAF_NUM_ID and LEAD_NODE) ahead of your Remove Duplicates stage.

Your unavoidale problem is the single quotes. They are required in SQL to encase a string value, yet they have the effect (as "hard quotes") of suppressing shell expansion of things like environment variables. One solution would be to use DataStage's non-SQL query language RetrieVe which is not so f...

You could use a Column Export stage to create a single VarChar column on each link (containing a comma-delimited string), and run the three links into a Funnel stage to combine them.

It's very well explained, with examples, in the official IBM training class DataStage Essentials (Enterprise Edition).

Standards Note U is a Burmese name (indeed, one of the posters here has that name), wat is a Buddhist temple, and wud isn't anything. Nor is gng. Please endeavour to use a professional standard of English on DSXchange. It makes things easier for those whose first language is not English. Metadata i...

Use substringing and concatenation to convert your string into the format expected by DataStage, presumably "yyyy-mm-dd hh:nn:ss".

Since your timestamp is not in default format you need to get it into default format for IsValid(). If it's already a timestamp data type you can do this with TimestampToString(), which takes a format argument. Otherwise you need to nest a StringToTimestamp() function with the format string that des...

Almost certainly but you will need to give some thought as to your model - do you need an "always running" job or one that starts based on some trigger such as the arrival of data. How many instances of the job would be needed to accommodate the maximum expected data throughput? Have you purchased S...

Then it should have the same ulimit as root.

In Director choose the Project menu.
In that menu choose the Print option. This opens a common print dialog.
Within the Print dialog check the Print To File check box.
Within the browser dialog specify the pathname of the text file (on the client machine) into which the report will be written.

Welcome aboard. That may be a useful snippet of knowledge for future searchers: thank you.