Skip to Content
0
Former Member
Jul 22, 2008 at 05:27 AM

'DBIF_RSQL_INVALID_RSQL' short dump

3466 Views

Hello All,

I have a dynamic where_clause in a select query. ie its created at runtime. I get a short dump 'DBIF_RSQL_INVALID_RSQL' at the select statement. The reason shown in ST22 is:

Possible errors:

o The maximum size of an SQL statement has been exceeded.

o The statement contains too many input variables.

o The space needed for the input data exceeds the available memory.

Could you please suggest a solution to the problem, since the data to be fetched is large I would not want to use select-endselect loop as that would make it slower.

Thanks in advance,

Anju