Skip to Content
0
Former Member
Jun 12, 2009 at 10:15 AM

Maximum size of an SQL statement

3191 Views

Hello,

we get a short dump with runtime error DBIF_RSQL_SQL_ERROR and exception CX_SY_OPEN_SQL_DB.

The dump occurs at the following select statement:

select * from /rtc/tm_inuse

appending table gt_zrtc4inuse

where obj_name in lv_sel_copy

and trkorr ne p_trkorr.

We think the problem is the number of entries in the range table lv_sel_copy so that the maximum size of the SQL statement is reached.

But how likely is the maximum size ?

Depends the size on the data base ? We are using MaxDB 7.6, MaxDB 7.7.

How can we determine the maximum size so that we can calculate the nubmer of entries in the range tabel.

Any other idea or solution ?

Thanks

Arnfried