DSXchange

I have 3 libraries and none of them are sym links as below: /ascential/apt/Ascential/DataStage/PXEngine.700.1/lib > ll *oracle* -rwxr-x--- 1 dsadm dstage 2088960 Aug 31 16:19 liborchoracle.so -rwxr-xr-x 1 dsadm dstage 2088960 Sep 26 2003 liborchoracle8ihpux.sl -rwxr-xr-x 1 dsadm dstage 2088960 Sep 2...

Could you please explain why this is needed? Also, I'm using HP Unix 11i server, so what would be the file-name. Are there any documents available on the same?

I'm tring to use the Oracle stage to connect to the Oracle database and read data from a table in a parallel job. I have specified the parameters ORACLE_HOME, ORAHOME and ORACLE_SID as job parameters. But, when I try to view data or when I run the job: Error loading "orchoracle": Could not...

If you are running a unix script to run your job, you can reset the job by the following command: ${DSHOME}/bin/dsjob -run -param '$APT_CONFIG_FILE='$APT_CONFIG_FILE -mode RESET <project name> <job name> You can then run the job using the command: ${DSHOME}/bin/dsjob -run -param <param1> -param <par...

What is the difference in output of the job parameters APT_DUMP_SCORE, APT_PM_PLAYER_TIMING, APT_PM_PLAYER_MEMORY and APT_RECORD_COUNT? All seem to give the same output to me.

I need detailed info about hashed files from basics to their internal details and command line options to modify them.

I have to convert a varchar(15) value to decimal (10, 10) value. If I us StringToDecimal function the job aborts. Can someone elaborate why this happens and how to use the StringToDecimal function so that I get the input string without truncation, rounding, flooring or ceiling in the output?