DSXchange

Oracle is the one parsing your SQL. Can you take the logged SQL statement and run it in another tool? Is 10.2.0.1 the same client you are using on Solaris?

Do you have anything in the way of backups? Exports? Without backups there's nothing to "restore".

Make sure you understand how the Folder stage works before you think it will be the answer to this problem.

That's worth checking as that is not always the case, sometimes run works but view data does not.

Exactly, your error is from the use of wildcards which the stage does not support. Using a "/dev/null" Filename and the full Filter with an explicit file name will also work.

You can't do "insert or update" with a bulk loader.

The Filename is not ignored, hence your problem. So either replace "DSParams" with "/dev/null" or move the real filename there and just put the "grep" portion in the Filter without the filename.

Failure. You can't run a job whose status is 'Running'.

Key word there is also.

datisaq wrote:Could you please tell me whether stable sort will remove the duplicates or not? As in documnetation it's given it's retain the first row as that of unique sort..

No, it's not "given" as that at all. Reread what you posted.

How are you specifying this in the stage? What did you put in the Filter and what did you put in the Filename? You also mentioned a View Data error, does the job run OK and the only problem is the Viewer?

So... is your problem resolved now? And it took a complete reinstallation of DataStage to resolve it?

You keep saying OCI when you mean the Oracle Enterprise stage, they are not the same thing.

Where is your closing parenthesis?

First suggestion would be to actually try it and let us know what happens. Obviously that option won't handle the "also deletes data from the table" part, you'll need to do that elsewhere.

Why? Because that's what it does with an 'unbounded' NUMBER field, i.e. one without any precision specified in the source table.