'DBIF_RSQL_INVALID_RSQL' short dump

[Former Member]

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

[former_member386202]

Hi,

Its a basis problem.You have to increase roll memory area. tell basis guys to increase memory.

Regards,

Prashant

[Former Member]

Hi Anju,

Check your select query.

order of field in select query may be different to the order of field in in internal table.

Regards,

Sandeep

[Former Member]

Hi,

I am using into corresponding fields of in the select query. Also the column positions are the same

Anju

[Former Member]

Hi Anju,

Please review note 690241 to understand why this error is happening.

Regrds,

sandeep

[Former Member]

Hi,

Are you using IN statement .

If yes than decrease the no. of parameter in the IN statement.

Regards,

Sandeep

[Former Member]

Hi Sandeep,

I am using IN clause but I cannot reduce the number of variables after the IN clause. Is there any other way of solving the problem?

Thanks.

Anju

[Former Member]

Hi Anju,

Check the link

[ Perfect link|

;

Regards,

Sandeep

[former_member182354]

Hi,

Split that SQL query into two or more logically and it will solve your problem. I think that you have exceeded the permissible length of query.

Raghav