topic Re: 'CX_SY_OPEN_SQL_DB'- Select-options maximum value in Application Development and Automation Discussions

'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member — Fri, 14 Dec 2007 06:21:49 GMT

Hi,

On running a Program, i am getting a 'CX_SY_OPEN_SQL_DB' dump.On analyzing the dump i found that the dump is coming due to more values passed in the select-options on the selection screen at the time of executing the program.

I was passing 5223 enteries in the select-options at the time of running the program.

Can anybody tell me what is the maximum value that needs to be passed to the select-options and whether this can be changed by changing some system parameter.

Thanks,

Mohit

Re: 'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member — Fri, 14 Dec 2007 06:51:09 GMT

Can anybody provide some insight into this.

Mohit

Re: 'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member — Thu, 16 Apr 2009 07:32:21 GMT

Hi,

Even i'm facing same problem,Could you please tell me what is the Maximum limit?

Thanks

Bhuvaneswari

Re: 'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member — Thu, 16 Apr 2009 07:40:48 GMT

Hi,

Split the 5XXX records entries into 1000 and use appending fields of table in the select statement. And write this code in the do and endo.

Thanks,

Sriram Ponna.

Re: 'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member — Thu, 16 Apr 2009 09:54:54 GMT

Hi Ram,

Thanks for your suggession, but i'm not writing any program.

I'm executing SAP Query , i can't make changes in code.

I want to know what is the maximum limt of single values in select-options ?

We are working with 4.7 version.

Thanks

Bhuvaneswari