Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

dump while selecting data using ranges

Former Member

‎2008 Mar 24 4:29 PM

0 Likes
1,155

Hi everybody,

I am using ranges to select data from BSEG table.

In a particular case the ranges table contains around 7000 entries, hence it leads to a short dump. Is there any limitation associated with ranges? with fewer number of entries it works fine. The code is already optimized properly for performance tuning purposes. There are no duplicate entries in ranges table i.e. all 7000 entries are unique and all are with sign as 'I' and option as 'EQ' , so all entries are unique single values.

Apart from this I have another query also. While selecting data from BSEG / CATSEKKO table if I use for all entries, then complete data is not fetched, However when I use ranges for same set of values, the missing records are also fetched. Any ideas for this behavior ? Is this related to cluster / pooled / transparent table types?

Thanks,

Harmeet Singh.

2 REPLIES 2
Read only

Former Member

‎2008 Mar 24 4:39 PM

0 Likes
603

hi ,

it is better to use the package size in the tables declaration..

regards,

venkat.

Read only

chaouki_akir
Contributor

‎2008 Mar 24 4:42 PM

0 Likes
603

Hello,

I am using ranges to select data from BSEG table.

In a particular case the ranges table contains around 7000 entries, hence it leads to a short dump. Is there any limitation associated with ranges? with fewer number of entries it works fine. The code is already optimized properly for performance tuning purposes. There are no duplicate entries in ranges table i.e. all 7000 entries are unique and all are with sign as 'I' and option as 'EQ' , so all entries are unique single values.

i have already encoutered problem using range in SELECT statement. TO avoid the SELECT statement to dump, i have changed my SELECT statement : FOR ALL ENTRIES instead using range.

+Apart from this I have another query also. While selecting data from BSEG / CATSEKKO table if I use for all entries, then complete data is not fetched, However when I use ranges for same set of values, the missing records are also fetched. Any ideas for this behavior ? Is this related to cluster / pooled / transparent table types?+

Could you show us the SELECT statement ?

Cordialement,

Chaouki AKIR.