topic Re: SQL Sentence Error in Application Development and Automation Discussions

SQL Sentence Error

Former Member — Wed, 25 Mar 2009 13:42:04 GMT

I am trying to execute this sentence :

SELECT PERNR

BEGDA

ZZCPRENDA

ZZDPRENDA

ZZTPRENDA

ZZPROV from ZPREN_EMP_FUNC into (wa_entr-n_pers,

wa_entr-frecog,

wa_entr-cod_prenda,

wa_entr-descrip,

wa_entr-tall_r,

wa_entr-origen)

where subty = '0003' and begda >= ran_f-low and begda <= ran_f-high

and pernr in num_per.

But It gives me and SQL error 'Error in module RSQL of the database interface'.

It is all because of the num_per table. It contains 3001 regs.

How can I solve it ? Should I modify the maximum size of the SQL statement ? or even the space??

Thanks in advance.

Re: SQL Sentence Error

Former Member — Wed, 25 Mar 2009 13:44:33 GMT

Yes for an SQL statement a range can only have a finite number of entries.

You need to use the FOR ALL ENTRIES command instead.

Re: SQL Sentence Error

mvoros — Wed, 25 Mar 2009 23:02:53 GMT

Hi,

check this OSS note 13607. It describes how SAP rewrites OpenSQL statement with ranges into SQL query for DB server and why there is technical limitation of number of items in range. You can try to use FOR ALL ENTRIES or split you select into more select where you will split your range into smaller chunks.

Cheers