DSXchange

Using PRECISION 15 throws warnings. the max value for PRECISION is 14. Anyways, I still had issues dealing with large values in Integer part of the Decimal values. Ex 6689722.9700000000 I used SCMP. It really works (But, must Check if the value is Numeric using NUM function before using SCMP). The c...

Is there a way to Supress Trialing 0's?

I shall look into the Basic document to come up with a solution.
This is one of Ken's routines that is still used at my Client' s place. He came over to this Client in 2004 to introduce his Framework and Methodologies.

I am using KBADifferent, one of Ken Blands Server routine that Checks to see if 2 values are different or same. While using this to compare 2 Decimal values that are equal, if the Fractional part is 10 digits in one of the 2 values, the routine returns 1. If the Fractional part is less than 10 or gr...

Is there a way using Universe Query or Use Basic COmmands?

Is there a way to list the Jobs that have Before or After Exec Shell from a Project.

Thanks

Hi, Yes, the Network Admin has created a new Logical Host with its own VIP Address. I am going to use -itag option for the installation. I checked if any other services is using hexITAG "apd" (ipcs -m | grep apd), and i did not find one. Can i pass anything as hexITAG value (as long as it ...

The Network Admin has created a Logical Host on the server that currently runs DS 7.5.1. I am planning to install the new instance on this Logical node. Is it possiple to install DS server with out the -itag option.

Thanks

This is a part of dsenv file for the existing instance. Do you think i should comment the first if block (anyway, the second if block overrides the DSHOME value) if [ -z "$DSHOME" ] && [ -f "/.dshome" ] then DSHOME=`cat /.dshome` export DSHOME fi if [ -z "$DSHOME&quo...

Currently the .dshome is ponting to the existing instance's Home directory. Also, the dsenv file uses this home directory. For the new Instance, what are the necessary things that i need to take care of before moving forward. Unfortunately, the Installation document does not say about these things. ...

Hi,
Is it possible to have two instances of DataStage Server 7.5.1 installed on the same box.

Thanks

Ray,
Sounds like i should not worry, should go ahead and install 7.5.
You are the boss.....

Ken, do you have anythingto say.........

Thanks

Hi, I want to install DataStage Server ver7.5 on the same box that currently has DataStage Server ver4.2 running on HP-UX 11i. The client wants both versions running. And, once the jobs are successfully migrated and tested they are planning to retire 4.2. This could be possible using -itag option du...

Hi, I have a PX job that reads a Sequential File and Loads the data into a DB2 table. One of the Column is defined as Decimal 16 with Precision 15. After running the job, when i checked the Output in DB2 table, this Column had rounded values. Is there any way that i can make my job read the Column v...

If Column Data is "ABC" "BCD" "CDE" "DEF" "EFG" "FGH" For 6 rows in one coulmn, the final output should be 1 row with 6 columns. "ABC"|"BCD"|"CDE"|"DEF"|"EFG"|"FGH" Is there a way ...