DSXchange

haha awesome.

then i can mark it as resolved then :D :D :D

this is my job, populate type 6 table https://i.imgur.com/5ZJPcZf.png those 2 SE stages update same table, one is type 1 change another is type 2 change. I had a kind of illegitimate work around: set the array size to 1 to avoid the problem. consider the whole table only have couple thousand rows th...

hi all i think this is more like a database question rather than a ds question but someone may can help me on here. i have a job has two sql server stages that update same table and they may update same row, if they do the deadlock will occur. these 2 stages runs very different queries from same sou...

h double checked on admin console, i didn't NOT tick on that box.

Hi all: I think I find the problem: i didn't put the full code out. the full code is like: if IsNotNull(LkTfProdDetial.Hospital_ProductTypeID) and IsNotNull(LkTfProdDetial.Ancillary_ProductTypeID) then if (LkTfProdDetial.Hospital_ProductTypeID = 3 and LkTfProdDetial.Ancillary_ProductTypeID = 2) or L...

i will run some test and let you guys know later today...

i put the trim() function out side the if statement and it returns right value, problem solved but i am not happy of how ds behaves.
i mark it as work around ...

thanks all

stage variable type is varchar(255)

if (LkTfProdDetial.Hospital_ProductTypeID = 3 and LkTfProdDetial.Ancillary_ProductTypeID = 2) or LkTfProdDetial.Hospital_ProductTypeID = 1 then 'HA' else if (LkTfProdDetial.Hospital_ProductTypeID = 3) then 'H' else if (LkTfProdDetial.Ancillary_ProductTypeID = 2) then 'A' else 'Unknown' thanks craig

hmmmmm...........
update:
i double checked the variable svCoverTypeCode's value
when value set to 'A' or 'H' DS put 2 blanks at the end
does anyone know why? i set this variable type to varchar (255, 0) how come it does it? this is a bit unfair...

cheers
Abyss

hi i am having a weird problem in transformer stage: i created a stage variable: svCoverTypeCode the value can be : 'HA', 'H', 'A' and in the output link's derivation, i create the following if statement if (svCoverTypeCode = 'HA' or svCoverTypeCode = 'A') then 'Y' else 'N' however when the value of...

not yet, i will do it

no one know?

Hi
I just turned on RCP on one of our project, current problem is we only want use rcp for some of the stages for our new jobs. but once you turn it on some existing stages from old jobs were automatically turn on.

is there a way to switch it off for all the existing jobs?

thanks
abyss

Hi all this topic may be a little more than only datastage I am trying to tune a job that calculate check sum on one of our table. The table is massive, it has over 120 million rows in it and more than 60 fields. the job call a checksum stage to calculate checksum value for each record. the problem ...