DSXchange

But the number of jobs is more and we are not sure how much more is impacted Is there a way to find it or will a change to any environmental variable will solve it

Hi ,
Is there a way to get logs for all the jobs in a datastage project.

Hi, I have a peculiar issue. In datastage 7.1 when I used source as char(4) and value (26 two leading spaces) and convert to integer (without any function) it goes through fine but in 8.1 it is converted to zero. Since we need to change for lot of jobs is there any environmental variable settings wh...

Hi I used a surrogate key generator stage. My job consists of Flat file -- > Surrogate stage --> Flat file Input file consists of name and I have to assign a sequence number to it. Input file ------------ xxxx yyyyy zzzzz ccccc I created a state file using UNIX touch command and in the surrogate key...

Thanks Ray, I enabled run time column propagation and it worked fine. But in my production environment it would be disabled. Is there any other way to solve this issue?

Hi , I used combine records stage in datastage my meta data in the input dataset is name varchar2(100),marks integer(10).My output dataset metadata is comb char(1000).when I use combine record stage (key is name )I get 3 rows output from the link. My input data is x1,100 x1,90 x,390 x4,50 but when I...

Hi, I want to delete a hashed file based on certain conditions from a routine. I used the command Call DSExecute('UV', "DELETE FROM ":pHashFileName:" WHERE JobName = '":pJobName:"';", cmdOutput, cmdRetCode) where pHashFileName and pJobName are parameters.This one works ...

Hi Guys, Sorry for the late update Decimal_to_decimal(inputcolumnname,"ceil") works fine when rounding to 2 decimal places.My source column was decimal[20,4] and my destination i gave as Decimal[20,2].The problem i encountered error due to using a transformer and passing the modified colum...

Hi,
I resolved it there were some type coversion issues

My input column is decimal[20,4]
My values are 83.2356,98.2345
i want it to round to 2 decimal places
do i have to give my target as decimal[20,2]
i tried using decimal_to_decimal(inputcol,"ceil")
But no luck

Hi,
Sorry made some mistake.
I got it but for negative integers it is not working.
-00890.54 is stil as -00890.54

I tried it i gave target as varchar[24] but still i am getting as 00000893.55 and 000000450.000

Hi,
I have the following scenario

My source is Decimal[20,4]
my data is like
00893.5500
00450.0000
But i want the output as
893.55
450.00
when i tried decimal_to_string with suppress_zero i am getting 450.00 as 450
but i want it as 450.00

Hi,
Is there any tutorial/Power point presentation available to explain SCD stage in 8.0 with example

Hi all,
Thank you very much now i am able to call the shellscript.
Suppose i need to pass a argument to the DSexecute command from a function i.e.
s = Arg1
Call DSExecute('UNIX','sh check.sh s',Output, SystemReturnCode)
But i am not able to pass the actual value.
Kindly advice.