DSXchange

My requirement is I want to find the max of two negative decimals
for eg;

max(-89.62,-88.02) I want the output as -89.62

but I am getting 0 The output feils data type is decimal(10,2)

Can you please help me

My job was running fine in ww server
When it is transfered to rr server. It fails and the faltal message is

sorted}}}(0),0: Input not sorted at record 6
can anybody please help me

Thanks

I am not using sort any where

My job was running fine in ww server
When it is transfered to rr server. It fails and the faltal message is

sorted}}}(0),0: Input not sorted at record 6
can anybody please help me

Thanks

another reqriment is i have to count in first 6 byte there are how many value greater than 1

yes

Hi My reqriment is at present i am having 24 byte column with 24 zero (000000000000000000000000) like this after doing calculation i have to put the calculated value in the first byte and to truncate the last 0. like this if i run the job every month the last byte should be truncate and new value wi...

How to remove the whitespace.
My need is i am having number 00123654(space is included before) because of it the last number 4 is skipped i have to remove the space to get last 4 also i tried with trim and stripwhitespace

Im my job I am doing calculation for 3months,6Months and 12Months upto 3Months the calculation i writtten in transformer is working good if i go to 6month job got abort and throwin the error The calculation i am doing is (a1+a2+a3+a4+a5+a6)<0 then '-9' else if (a1+a2+a3+a4+a5+a6)=0 then '-8' else ((...

Hi
I want to take max of two dates in transformer.
the problem is i am having some rows as null. so the record dropped.
My req is i have to find the max of the two dates

i checked onlt84% is used

Hi My job was working fine if i add more transformation logic it aborts and displays the following message APT_CombinedOperatorController(1),1: Failure during execution of operator logic. buffer(3),1: Fatal Error: waitForWriteSignal(): Premature EOF on node rndlatam Error 0 APT_CombinedOperatorContr...

Handle isnull(columnname) and do the process asper your reqirment
handle isnull in all the place like stae variable and transformer

while joining four datastage stage.
the job got abort due to
1) operator logic
2)Join_4,0: Fatal Error: waitForWriteSignal(): Premature EOF on node No such file or directory
3)buffer(4),0: Fatal Error: waitForWriteSignal(): Premature EOF on node Error 0

these error occur in join stage

hi ray the resolution was fine the problem is i am using the column name in stage variable i didnt handel null there but handled in transformer only