DSXchange

Create a job sequence. Construct an Execute Command activity to execute the command to read the date from the file (or use a Routine activity that invokes a routine to do the same). Pick up this value as the output value of the command (or the return value of the routine) when setting the job parame...

DataStage can not be successfully installed on Windows XP Home.

What? Reinventing the wheel is easier than using an already-invented wheel? Please reconsider.

It's definitely NOT "much easier using a shell script, since the job logs are database tables.

If the final data type is Date, its format is irrelevant. Therefore you can apply a StringToDate() function to the leftmost field of your input string and that will suffice. You will need to supply an appropriate date format string. If you want to convert that result to a string, apply a DateToStrin...

Do whatever works. Integer is probably a good call if the word INTEGER was used in the CREATE TABLE statement.

I believe that this is part of the resource estimation tool, new in version 8.

Ignoring the year, we also have the death of Elvis Presley and the partition of India and Pakistan on this day.

What was? Woodstock.

The Merge stage consumes rows from its Update input(s) as they are touched. Therefore any remaining rows once the Master input has been exhausted will be those that were not touched.

Are you perhaps using a two-node configuration file, and looking at the row count on one node and not the other?

may be slightly more efficient

Set the preserve partitioning flag to Clear upstream of these stages.

That is, clear the preserve partitioning flag on the output link of the prior stage on each input link to the Lookup stage.

Please describe your job fully, including the stage types used and how they are connected. Post the generated OSH if you think that will help.

There should be an event in the log indicating which Orchestrate modules were loaded. Does orchsort appear in that list?

To check whether no rows were extracted before proceeding you need a modular design - one module (job) to perform the extraction into a staging area (Data Set), and a later module to process the data from that staging area. Perform your check before starting the second module.