DSXchange

You need to add the Oracle bin directory to your path environment:

PATH=$PATH:$ORACLE_HOME/bin; export PATH

Check the setup sections of the Docs, remember that ODBC (wired and non-wired), Plug-ins and PX stages al lhave their own setup instructions.

An empty string is not a Valid Integer, it should be 0 or Null. A null is often represented in a sequential file as an 'empty' field. If you set the column type as Nullable you can set the null value property so when you read the 'empty' fields in the sequential file they will appear as a NULL withi...

Check you have enough disk space / quota ?

OR you could use the uninstall script "uninstll.sh" found in your install media

You could look at the PX Routine Samples on your Install media.
(under the samples directory -> TrxExternalFunctions)

What version of Liunx are you using?
(is that ASE3.0?)

What is your default umask setting?

What is the free disk space in /home/dsadm?

Can you tar/un-tar normally?

This tells you the job has been terminated.

Without a description of what you are doing and more information about the problem I don't expect you'll find the answer your looking for.

Set DB2CODEPAGE in either dsenv or as a project level user defined variable in the administrator.

You could also add the code into the db2_cs.txt file

I agree with ArndW. These are the values from my routine:

S>"ABCD"
T>ABCD"
U>ABCD
V>ABCD"

I think you have to look in later releases that have the Production Manager Role. Unless you can utilize the existing Role settings?

Red Hat 2.1 and 3.0 use a different Compiler Version.
So you should re-compile all objects that use the compiler after the upgrade.
You may also have to re-point DataStage to the new compiler? although if you upgrade DataStage it should do that automatically.

1) you are installing into the location "/home/dsadm/Ascential/DataStage/PXEngine"

Does the user you are using with the -admin flag have the correct Unix permissions in dsadm's home directory?

Remember there is no such thing as a NULL in a sequential file only an empty string

"multiple instances", does this mean job invocation?

the fifo should have a uniquie name so you should be able to run multiple invocations with no problem, although if they are all trying to write to the same fileset at the same time you will have a problem!

Solaris is not supported on any non-sun machine.