DSXchange

"Be more precise and complete with your specification" would be a good start. The answer may even jump out at you!

My guess is that the partitioning algorithm is inappropriate for the data type - check whether Modulus is specified as the partitioning algorithm.

Check your Engine Credentials in the web console for Information Server (http://hostname:9080/ibm/iis/console) - this is where your login to the DataStage Engine is mapped to your user ID. Here hostname is the name of the services tier machine.

UserStatus area is separate for each instance. In general it won't be a problem.

Because of how and where it's stored, you should in general avoid storing dynamic arrays in the User Status area of multi-instance jobs. This is the only way I know to break the mechanism.

Only by checking prior to starting the job, for example using Execute Command activities in the controlling sequence. There is absolutely no way to require a job to ignore a missing Data Set. The sequence-based approach would have to direct control to one of a number of jobs that handle different co...

Field() functions in Transformer stage.

Since a sequence executes in a single process, you will not be able to achieve your goal using out-of-the-box activities. Instead you have to set up an environment in which an asynchronous (and probably background) process waits until a particular time then issues the actual run request. You can sta...

And did that resolve the problem? Was the same change required on the other server?

Open the Administrator client, select your project on the Projects tab, click Properties then click Environment. You'll now be in the workspace of which Craig speaks. Open the User Defined branch and add TNS_ADMIN and any other environment variables you may required (such as ORACLE_SID).

Beat me to it!

For simpler cases you might try using the Looping capability of the Transformer stage.

Format your post using Code tags so it's clear what's happening. It's too difficult to fathom with the way you've presented your information.

Use a third party "XML prettifyer" to post-process the XML produced by DataStage.

Try "escaping" the quote characters. DELETE FROM TEST_MOSAIC_DB.FLOWN_TICKET WHERE TICKET_RPT_DT < ( SELECT CAST(TRIM(CONCAT((EXTRACT(YEAR FROM LST_PRCSSED_DT)- (SELECT CAST(VAL AS BYTEINT) FROM test_LOG_DB.ctl_nm_val WHERE NM=\'DataRetentionPeriod\')),\'1201\')) AS DATE FORMAT \'YYYYMMDD\...

Are your xpath expressions complete and correct?

It's the same as in version 8.7.
http://hostname:9080/ibm/iis/console will suffice as a URL.