Problem with a query as400/db2

[julen]

Hi everybody, and thanks for reading my post.

I have a problem when I do a query.

This query has various inners.

And when I executed the query, the navigator wait and wait,
and doesn't show me rows.

Sometimes I have to wait fifteen minutes or more and sometimes told me and error that says:

"Limit resource. Too many rows selected, reduce the rows".

How can I "do bigger" this? Is there any way to solute the problem??

Thanks.

 

[blom0344]

There is a good chance that your join strategy is not correct and more rows are returned than needed.
Did you try and add:

'FETCH FIRST 1000 ROWS ONLY' after the SQL to check what is being returned? (like multiple identical rows)

Ties Blom