DSXchange

The output schema of the external filter does not need to match the input schema to the filter. You could try? If you change the DataSet design schema you should ensure any previous datasets with the same name are deleted before running the job again (Use Manager -> Tools -> Data Set management) Che...

Have you re-generated the wrapped stage?

1 extract job, 1 transform and then 1 load job. Just to Note that the extract job will be reading from DB2 in sequential mode and the transform job will be running in parallel mode. You could try? In the transformer stage -> properties -> stage tab -> advanced you can set which nodes the transforme...

why would you want the 'c' code?

set the value of fastname to the hostname of the server.
(type 'hostname' from the command line on the server to find it's hostname)

AlanP - Out of interest - Is the new DataStage Sever
1) the same version?
2) the same OS?
3) the same NLS settings? (i.e DataStage NLS enabled)

What is the default NLS map for your DataStage Project?
(assuming you have not changed the default within the stage)

I think you are required to create a Directory C:\tmp ?

ray is right, if you install DataStage with NLS you alos need to add the environment variable NLS_LANG.
This should be set to the language settings of the Oracle Database in the form:
"NLS_LANGUAGE_NLS_TERRITORY.NLS_CHARACTERSET"

First you should have given DataStage the location of your Oracle clients during the install.
Then you need to add $ORACLE_HOME/bin to you PATH
and $ORACLE_HOME/lib to LD_LIBRARY_PATH.
(first add oracle lib32 if you have one).

then try again.

I guess you'll need to look for the include files in your compiler.
You could try running a find from /opt/SUNWspro?

You can configure the refresh interval of the Director Client.

Director -> Tools -> Options -> General Tab - Refresh

I'm not sure that you can execute a script, but you can execute a single SQL statement (enter into the "Close Commadn field") which will be run once for each node in your configuration file.

Have you tried a Force Compile?

Is the Job Monitor working?
(You will see a message like this if the JobMonApp is not running)

Search the forums ...