Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

'CX_SY_OPEN_SQL_DB'- Select-options maximum value

Former Member
0 Kudos
158

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

4 REPLIES 4

Former Member
0 Kudos
78

Can anybody provide some insight into this.

Mohit

0 Kudos
78

Hi,

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

Thanks

Bhuvaneswari

Former Member
0 Kudos
78

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.

0 Kudos
78

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