DSXchange

Let's see - you waited a whole minute before asking for quicker help?

What DB2 stage and options are you using? What have you checked? Do other tables have write errors? What does Google for "DB2 Reason Code 106" return? Or sqlcode -804 and SQLSTAT 07002?

If your DataStage server is on UNIX then you will need to buy a 3rd party software package to read Excel files directly using ODBC. The vendor that springs to mind is DataDirect. There are also Java apps in the public domain that might be used to do this, but I have no experience with that.

What do you want to do on the LDAP Server? Access a sequential file?

LDAP Wiki

make sure nobody is logged and do the DS.REINDEX again.

That means some other process has an exclusive file lock on that entry. Can you check up on who else is logged in?

use an absolute path for "testfile".

Try to create a new DataStage job. Can you save it?

Your library paths are not correctly set up in the system test environment. Compare the settings for LIB or LIBPATH on DEV and the system test and I am fairly certani you will having one or more missing directories.

Ana - not from this site! Many of the people here have spent years working with the product and building up both expertise and a reputation. For this reason the general opinion is that people who study up on a subject in order to pass an interview and then expect to be "dragged along" or learn on th...

A simple way would be to create a file at the beginning of the script and delete it at the end, then check for existence prior to creating it.
Some systems you can use "fuser" command on the file to see who has it open, that is an even better method.

Are those jobs marked as "running" in the Director? Do you perhaps have a job monitor window open? Can you do a "reset" on the job if they are marked as "aborted"?

1. Sort the input data by the column you need to have distinct. Let us assume it is "In.CustNo" 2. Create a stage variable svIsSameCustNo, derive it from "IF In.CustNo=svLastCustNo THEN 1 ELSE 0" 3. Create a stage variable svLastCustNo which is derived from "In.CustNo" 4. Create a constraint "NOT(sv...

You can use the Aggregator or, if your data is sorted, you can use stage variables in a transform stage to remove duplicates.

Yep, that is the way the system works.

This one seems to have fallend between the cracks. What sort of options are you using in the Oracle stage? Default or non-default SELECT? Does the exact same SELECT work from SqlPlus or your favorite query tool? Any other problems with other jobs/tables?