DSXchange

Hi All, I am trying to unlock the job and i followed the below steps(I dont have DS Administrator window access,so logged into unix box) 1. Login as dsadm. 2. cd into DataStage home 3. Enter ". ./dsenv" 4. bin/uvsh after enter of 4th step im getting the below message instead of TCL prompt ...

Hi, I got the solution. :D . The error is due to the Abs() function. Abs( ) function returns an integer value. So, code is failing since, SHRPAR_QTY_SUM is a decimal value and we were trying to convert an integer to a string with an incorrect type conversion function and the values coming from UAT e...

If you are good in writing BASIC routines, write a routine to get the log(in to a file) when the job gets abort, and attach that file;send to support personnel thru notification activity.

Hi Ray, but im converting all the decimal fields to strings. Eventhough the length of the decimal field is larger from the source iam converting decimals to string. Iam putting the following logic for the decimal columns. 1)the field from source is : -(SHRPAR_QTY_SUM) decimal [31,11] In Tfm iam conv...

Hi all, My job is getting aborted by showing the below Fattel error. Fatal Error: APT_Decimal::asInteger: the decimal value is out of range for the integer result. In the transformer im converting all the decimal fields to string. im not using any integer datatype in the target. The same job is work...

Use either Trim(columnname) or TrimB(columnname)