Hi All,

I have a hold file with 58K records(Value changes).
I need to send these records to a SQL query and fetch the records.
I am sending these 58K records to the query using a REPEAT loop; but it is returning me the following error:
Reporting Server messages exceeded IBIF_max_messages, report retrieval aborted.

How can i make these huge amount of records get executed through REPEAT loop? or any other way to acheive this.

URGENTLY NEEDED!!!

Thanks in Advance

This message has been edited. Last edited by: Kerry,

Hi Narayana,

Has this issue been resolved?

If not and it is still urgent, please contact Information Builders' Customer Support Services and open a case. You may either call at 1-800-736-6130, or access online at InfoResponse.

Cheers,

Kerry

Do you have &ECHO on?

quote:

IBIF_max_messages

This is a topic that has been covered in some detail on the forum before.
If you could be bothered to do a simple search you will find the solution you need.

Personally, I would NEVER use a repeat loop to send records to SQL. I'd use TABLE with JOIN or MAINTAIN to do this ...