DSXchange

As mentioned, it depends up on the available number of rows. Is it MPP or SMP?
SMP architecture should get benifited with more nodes for large file processing at most of the time.

What is the status of the job EligPxiFileNameCoalitionJob.1832 in director?

Do a Inverse Pivot based on the transaction id. Do a search on the to know available various methods.

And IPC will be overhead only if the increase in nubmer of process (due to usage of IPC) become a nightmare to the CPUs capacity.

Are you sure that not even stage link sort been enabled on the key columns. Try to convert the columns into same length.
And, are the datasets been sorted?

What is the datatype in target? Is it the view data which gives you the truncation or the target or the both?

'if you have time' pls do a search on the same keyword.

You cannot do this unless you have a common column (key) in all the three. If not, you have to try with dummy column, as what you have did. Which will result in cross product. Again you need to remove the recoreds based on your requirements. Which is most ineffecient way of doing.

LAN connection is not required if you server and client is installed in the same machine, but the resquested is installaion of LAN card.

How big is your project? Is there any one doing the same with the existing clinet connection. That would be one of the main reason to see the job disappearing often. Take a backup of all the jobs, and deleter the project and rebuild a new one and import back. So that you the installaion on the fresh...

Need to look into programing logic in deep.
What happens if your code has simple, print and return command.

Check the ipconfig from command prompt.
You can use the same ip which is obtained, most probably the loop back address 127.0.0.1 will work out.
By chance if you get Windows IP Configuratrion', you need to check the NIC installaion or upgrade.

Has the MKS tool kit been installed?

Have you tried running the same shell script from server command prompt?
Try to run the dsjob comand from the client command prompt directly?
But you are sure about compiling from client isnt a issue?

ray.wurlod wrote:No, the Windows-based server is 7.5x2. There is, separately, a version called 7.5.2 for UNIX servers.

This is a new info learnt form you today. Thanks. :D