DSXchange

what is the array size ?

Would doing a count and passing it as a param to this job be something that interests you ?

Can you try splitting the job into two steps and see if you still get the same error...

stage variables: svChk (If (svPresKey <> svPrevKey) Or (svPresKey = svPrevKey And svRecDiff<>1) Then 0 Else 1) svDescCon (If svChk =0 Then Trim(DSLink5.DESC) Else Trim(DSLink5.DESC) : svDescCon) svNewRecNo (If svChk = 0 Then DSLink5.REC_NO Else svNewRecNo) OutputLink1 - main : when svChk = 0 ACC_NO...

Have you managed to connect to this Oracle instance from this datastage box before trying this? if so what stage have you used?

I did a sample job and got this output.. Added another output from the tranformer that pulled across the concatenated desc value.. followed by a rd stage that retains the last record and then acts as a referential stream to the actual xfm output that lookups into this to get the DESC value... Let me...

Chandra, When you sort your data ascending by Accno & RecNo your data becomes... Accno|recno|desc|svRecNoDiff|svChk 100|7|DD |7|0 100|9|CC |2|0 100|10|AA |1|1 101|18|FF |18|0 101|19|EE |1|1 101|20|BB |1|1 102|30|GG |30|0 so when you pass only where svChk = 0 your output would be 100|7|DD |7|0 10...

Rai, Sorry if its too late in the day to comment on this .. Did you consider redoing the join in datastage, making best use of the parallelism etc.. perhaps even ading a few parallel hints on your source query Also, you could write data into mulitple files in your first job and then have a clever sc...

I was suggesting the constraint to be svRecNoDiff <>1 so the first record and the 4th record would satisfy this criteria and pass through.

There could be loads of reasons why this could happen. Is it just this job that performs badly? Do you have any other jobs that have a similar logic that run as expected. Does this job take 90mins irrespective of when you run it (peak/offpeak ?) Could You please tell us more about your job and its d...

Dave, I do remember seeing this error.. but not sure what we did then.. See if this helps..

https://www-304.ibm.com/support/docview ... wg21470851

It would be triggering mutliple queries against the table.

Sorting your data and doing something similar to the if-then-else below will certainly ensure you pick the right record.. However concatenating it might be a little tricky.. does it matter in which order you concat the description ? eg: for 100 - does it matter if its AACC or CCAA ? If svPrevKey <> ...

Sort your data before your xfm on acct_no, rec_no (asc).

Within your stage variables whilst comparing keys - do a difference between previous_rec_no and present_rec_no and pass only records where the difference is <>1.

Hi all, Im using datastage 8.1 with fixed pac1. Im trying to read data from MQ message queues and to load into oracle database. Fot this Im looking for mqread and unitofwork stages but Im not able to find them. Do I need to install any more pacs or will they come with 8.1 by default. Please suggest....