DSXchange

Do you mean to say, based on the 3rd column of RPT_Tbl, you need to do a lookup on REF Tbl to get NAME and based on the name you need to do a lookup on Hash to get 2nd and 3rd column to populate the '-' in the RPT_Tbl?
If so this can be acheived by two lookups.

Using commnad line interface.

Where "?" can be used for IN type.

Try to export in dsx format, by unchecking "Export as XML Document".
Also make sure "Use default Viewer" is selected under Viewer tab.

Just execute it after the loop.
You can do this from the job sequence, by using ExecuteCommandActivity to call the SP from OS level. Or use a JobControl which has the db2 api stage (in the before/after sql tab) to call SP.

There are very few option left from DS perspective. It is soley a networking issue. concentrate on the improvement of your bandwidth.
BTW, it is really a FAQ discussion?

If the poll is closed, why still in home page.

The type of the file, XML or dsx is up to you, how you select the option available in Manager client.
Even a empty job sould atleast give you header information. Was there any error comming out while exporting?

Perhaps the default datatype Double (38,10) might be chosed to get your result not presice as expected. And the implict conversion from double to Decimal might have caused the slow down of your job drastically in the second case. You can try Double(18,2) in the output of aggregator and use a modify ...

Have you tried to get the information from the developer that how he manage to make is disapear. Atleast we can try reverse engineering.

You can acheive this by inserting any dummy field with a value 1. And sum it up in the Aggregator for each group to get the distince count for each group.

Is it a new installation?
Was there anything happend suspiciouly to make it a empty file?

And why do you need to repeat the post in multiple form.

Duplicate post.

And BTW, these are not stages like join or transformer...., these are tools like DataStage, Metastage....

Its familiar warning of yours. Have you tried the suggested solution on the other post regarding schema file. the nullable field value is given as single character where as the total lenght of HIREDATE is 19. Is it in target or in source file. Are you mentioning any Nullable field value to these fie...

What is the stage you are trying to access? Is it routine activity?
It is particular to that stage?
Have to tried other general steps like, closing the job and reopening, trying in another client machine, trying REINDEX, trying restarting the server?