DSXchange

The default behaviour of Trim() is to remove leading, trailing and redundant consecutive trimmable characters. Therefore Trim(" ") would leave a single space character as the result.

Partition by sortcode (modulus or hash as the algorithm) and sort by sortcode then by store number. You did not give us the rule for what determines the data set into which a particular row goes - but presumably you can use a Switch, Filter or Transformer stage to effect that.

Did you build your custom trigger expressions in your Nested Condition activity using the expression editor? If not, please do so and let us know the result. Also make sure that the casing is correct, or apply an Upcase() function to force a case-insensitive comparison. Finally, you need to check th...

Welcome aboard. Almost certainly the answer is no, given the age of DataStage version 4.3. However, you may be lucky - try it both with the Sybase OC stage (which may have retained upward compatibility) and with the ODBC driver for Sybase. There is a matrix of compatibilities that you can find on th...

The only approach is trial and trial. Start with one stream, then increase gradually until elapsed time doesn't reduce any more. Of course all this is predicated on "all else being equal" on the server machine. You can use the DataStage resource estimator tool, but this does not report an ...

If it is in your PATH, then the which command will find it quickly.

If it is not in your PATH, then find is the appropriate command.

Control Panel on the server machine. Depending on which flavour of Windows you are running depends on precisely where within Control Panel the application for working with users and groups will be found. Get help from your Windows administrator person.

Are you using your own ("hand written") job control code? Look for code like the following: hJob1 = DSAttachJob(JobName, DSJ.ERRNONE) ErrCode = DSRunJob(hJob1, DSJ.RUNNORMAL) ErrCode = DSWaitForJob(hJob) (These may not be adjacent lines in your node.) Note that the variable used in DSWaitF...

Welcome aboard.

Try to choose meaningful subject lines - it will aid future searchers.

Search DSXchange for topics such as the dsrecords command and use of the Data Set Management tool.

Never, ever, delete jobs in that way. Even after Bryceson posts his findings about what's in the common metadata repository there are yet other things that will need to be cleaned up in the local repository, among them entries in the table of job objects (DS_JOBOBJECTS), and possibly references to t...

"The business has a rule..."

Thin air.

Next week a doctor with a flashlight will show us were business estimates come from.

This is confusing code because you have used Status1 to capture information that is not status information.

What value is being returned by DSGetJobInfo(hJob2, DSJ.STAGELIST2) ?

Resist stupid requirements. DELETE all rows is transactional, and takes a long time. TRUNCATE is non-transactional and is fast.

There were presentations on high availability at the most recent two Information on Demand conferences, so one must assume that IBM does have some offering in this area.