Intermediate result is too large while reading ADABAS table

prasadvrk · Active User Joined: 31 May 2006 Posts: 209 Location: Noida

I am getting the following message when I tried to execute query in Natural to read an Adabas table.

MS7845 0420 NAT1301 Intermediate result too large.

NAT9978 ERROR OCCURRED DURING EXECUTION/COMPILATION

Is there any workaround for this problem, please reply asap as this is a show stopper for us.

ofer71 · Posted: Wed Sep 20, 2006 7:28 pm Post subject:

First, ADABAS uses files, not tables.
Second, this is a NATURAL message, not ADABAS (ADABAS messages start woth '3').

This error message means that you are doing some calculation, but the intermediate results are too large to be held in NATURAL buffers. Simply break your calculations into smaller parts.

O.

prasadvrk · Active User Joined: 31 May 2006 Posts: 209 Location: Noida

Thank You very much Ofer71!

I am new to Natural/Adabas programming so I did not know for sure which was throwing the error.

I have figured it out and now it is running fine

Thanks once again for the promt reply.