topic Re: dump while selecting data using ranges in Application Development and Automation Discussions

dump while selecting data using ranges

Former Member — Mon, 24 Mar 2008 16:29:16 GMT

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.

Re: dump while selecting data using ranges

Former Member — Mon, 24 Mar 2008 16:39:02 GMT

hi ,

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

regards,

venkat.

Re: dump while selecting data using ranges

chaouki_akir — Mon, 24 Mar 2008 16:42:15 GMT

Hello,

I am using ranges to select data from BSEG table.

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.