Skip to Content
0
Former Member
Jul 18, 2008 at 10:30 PM

DBIF_RSQL_INVALID_RSQL - Dump

73 Views

Hi,

I am getting a dump on execution of a SQL statement, where the data is huge.

The error description...

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.

The SQL Statement raising the error ...

SELECT * FROM z9ars_agreement

INTO CORRESPONDING FIELDS OF TABLE pp_z9p_generic_agreement

WHERE agreement IN r_agreement

AND customer = space

and orderbegindate le pp_validity_date "v003

and orderenddate ge pp_validity_date "v003

AND orderbegindate LE l_to_date "v003

AND orderenddate GE l_from_date. "v003

DESCRIBE TABLE pp_z9p_generic_agreement LINES g_line_count.

The data in the r_agreement is Huge causing the dump.

The Z program is calling a Function Module where this select statement is executed.

This FM is being used by lots of other programs.

Kindly let know how to rectify the Error.

Do let know if any other details are required.

Thanks in advance.

Regards,

Syed