DSXchange

I am very new to datastage Please help in: I have input columns Empno,Ename,sal 10 ,aaaa,15000 10,bbbbb,20000 10,ccccc.250000 20,xxxxx,30000 20,yyyyy,24000 20,zzzz,26000 I want out put columns like Empno,Emane,sal(total), Empno(count) 10,aaaaa,bbbbb,cccccc,60000, 3 20,xxxxx,yyyyy,zzzz,80000,3 for th...

You got c0de -99 error. i think it is coming from target data loding area. at a time your doing 2 operations in u r target database. may be your using 2 table names in single DB2 stage. am i right? No idea. Did you Search DSXchange for this error message? Funnily enough, code -99 also really means &...