DSXchange

How did you come to the conclusion that it did not sort the file?

Try to view data to confirm the sort.

Check whether there are any other warnings / errors near this error.

In reformatting the rows.

You need a link from your job to count null and supply the result on constraint to dslogfatal or utilitylogfatal.

Search for them in the forum.

Did you try running it outside DataStage?

If you can, then you can include the SQL as a post-job script.

But still, I believe such an update cannot be utlized as rows may migrate during updates or or migration or rebuild process.

Let us know if you encounter any difficulty in this.

Can you explain why you have it, what you wish to achieve from it and how you are approaching it so we can try to find a solution or alternative way.

You must be able to do that (as long as col1 has datatype to hold the value).

But why will anyone require to issue such a command as rowid may change upon the update itself.

NOTFOUND column can be part of your source. But the issue is when you have it as part of your lookup / reference information column. When you include a constraint as 'referenceLink.NOTFOUND', DataStage will check the value in the NOTFOUND column of the input link than the logical check of whether th...

I am not sure whether you have successfully implemented the logic described by Ray or whether you are having problems. You need to use 2 columns in your link to update - say fld1 and fld2. One of them (say fld2) is to be marked as key. The datatype for both fields must be identical to that of col1. ...

There can be several reasons for this. Some of them are

1.) Someone removed the parameter from your job
2.) Someone included the check in your job
3.) The data flow never used that route in the past and was not tested for

So you are in the best seat to drive the show.

Ensure that 'jobparameter' is a job parameter of the sequence.

Under job properties tab. You have the check-box for this purpose.

You neede BCI routines.

Or you can perform shell calls.

But why do you need to perform a 'SELECT' from a routine?

In that case, you need to verify whether your PC has been upgraded with any other software that may impact DRS. Is your PC a Win XP 2?

Generally nodes = partitions. But you can control the nodes and their uses to control the partitions via your job and/or the configuration file.