DSXchange

Sainath - cool, I didn't know that command existed!

It is in the nature of programs to do the same thing with the same data. If that is not happening, then usually some factor is affecting the outcome. In this case, are you 100% certain that your source dataset has the same cnotents and that every single parameter to the job is the same between runs?...

an "error like.." is not as helpful as using cut-and-paste and displaying the complete message, particularly when the issue isn't clear as in this case. Also, is this a server or a PX job?

Manu1 - You need to find out how many bytes per row your data has and then use the rows/sec value times the number of bytes. Often people say that DS is slow because it is only doing 1000 rows per second - but if each row is 1Mb then the throughput is actually much better than it looks. Thus your co...

By default the projects are located in $DSHOME/../Projects/{YourProjectName}. If the projects are located elsewhere, the command will give the path on line 4 of the output.

Create a common column for both files using @INROWNUM and then combine them.

Marcus426 wrote:...resetting the counter...

What counter do you mean?

By "tags" do you mean XML-style tags, i.e. <Col></Col>? Or are you just refering to columns that contain no values, i.e. in a comma separated source file where columns B and E have no value?

As always when an error message is from the "APT_CombinedOperatorController", add "APT_DISABLE_COMBINATION" to your parameters and set the value to "true" in order to discover the stage causing the problem.

www.ibm.com and then go to support. You will need your IBM login id and password and can then search on the eCase/patch number and download from there.

How about just using SH scripting
(from UNIX)
cd {project directory}
dssh "SELECT JOBNO FROM DS_JOBS WHERE NAME = 'Test';" > textfile.txt

If you look at the dates you would see that this problem is over 3 years old. Patches are generally available for download once you login to IBM's website .

But since the comparison is done on all 3 sorted columns you won't get duplicates...

Are all 3 keys supposed to denote the duplicates or just the first or second keys?

Paranoid - in your original post you specified server on "Windows" and all the answers you have gotten so far assumed that Windows was your platform. ODBC to Excel is much more difficult on UNIX, and DSGuru2B's response also assumes a Windows platform. DataStage cannot write to an Excel bi...