DSXchange

There maybe options from the command line "dscc" tool?

Are the HP-UX kernal parameters configured correctly?

Have you exported/imported the executable from/to a project on the same DataStage machine?

Just to be clear - Can you write to an Oracle Table using the PX Stage?

Or are you writing to Oracle using Server and trying to Read the data using PX?

As DataStage on HP-UX is a 32bit application I would expect the Database clients you want to use would also need to be the 32bit versions.

Have you added the <DataBaseType>/bin to the PATH variable?

On a Unix server, You can specify the info as a global value to all projects in the dsenv, or as a project level user defined variable (using the administrator) which then appears in the DSParams file.

DataStage does seem to run on windows XP but it is not supported by Ascential. So if you have a problem you will not receive any support.

You could check the userID you are using belongs to the correct Group on the Unix server for DataStage access.

Timestamp. 2005-04-11 17:46:38
Severity.. Warning
Full Text. Job control process (pid 6846) has failed

It looks like the first log entry implies that things went wrong before the transformer was run?

You can still use Server Before/After rountines that are set from the JobProperties screen.

It sounds like either
1) There is a problem in the way you have compiled your C code. Did you use the compiler options from the example makefile?
2) The path of the Object file does not match the path given in the PX routine definition.

and USS jobs need to be compiled on a USS instance

Is this a Parallel job running on a windows server?

If you have installed DataStage with NLS enabled, then you need to add the user defined variable NLS_LANG to your DataStage environment (set to the same character map as the Oracle database).

You can find the Oracle setting for NLS_LANG by running the SQL: