DSXchange

If
(IsNull(a) Or IsNull(b) Or IsNull(c))

Then SetNull()
Else If

(IsNotNull(a) And IsNotNull(c))
And (IsNotNull(b) = 0000000000.0000 Or
IsNotNull(b) = 0)
Then (a* c)

Else If
(IsNotNull(a) And IsNotNull(b)And IsNotNull(c))
Then
(a/ b) * (c) Else SetNull()

Thanks for respodning to my msg b is also decimal , it have 0s in 0.00.. format even i tried that way still its giving warning msgs please help me out this

APT_CombinedOperatorController,1: APT_DecimalNumber::analyzeAndPrepare:divisor is 0. APT_CombinedOperatorController,1: APT_DecimalNumber::analyzeAndPrepare:parameter(s) are invalid or not normalized. APT_CombinedOperatorController,1: APT_Decimal::operator=: the source decimal has even precision, but...

thank you for ur response i have disables the smileys thank you

Hi all, I am getting error while converting date formats here in my job iam converting date to string format and again iam doing string to date conversion here is my logic DateToString(a,"%yyyy-%mm-%dd")= b If IsNull(b) Then SetNull() Else StringToDate(((b)[6, 2]:(b)[9,2]:(b)[1,4]),'%mm-%d...

SELECT
a
, sum(b) as X
, sum(case when c = 0 then 0 else b/c end) as Y

FROM table P

where date <= date('.....')

and nodenumber(a)=current node
group by a

for read only with ur

Here is the SQL

Thank You

Hi i got a problem with db2 stage, iam writing userdefind query in db2 satge that select sum(a), sum(a/b) from table X when iam running this query in DB2 command center its returning results, with same query in DB2 stage, when i am trying to view data just it is returning 0s and nulls for that field...

could you pls help me out how to do this in DS


Thank You

we have to do this in transformer or modify stage

Hi All,

I have date fromat type yyyy-mm-dd

but i have to convert it to mmddyyyy fromat


the version 7.5.2 EE parallel

pls help me out this

thank you

kumar

Hi All,

I am Getting this error

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadVersion: From: Loading memory archive



While running this job, previously it was a successful run,

help me out this

Thank You All

Thank you for ur response,

even iam using the same hash partition in sort and same partition in join satge still it is giving same warning

Hi Iam new to 7.5.2 iam getting this error Join_2: When checking operator: User inserted sort "{natural="Sort_4:DSLink9.v", synthetic="buffer(1)"}" does not fulfill the sort requirements of the downstream operator "APT_JoinSubOperatorNC in Join_2" could u peop...

thanks a lot

Thank you for ur response

Source is dataset