Whole Data Retrieval

[Former Member]

Hi Experts,

I have one master table, which contains about 16million records. My scenario is to retrieve all the data from the master table and display it using report. I am getting request time out error, when I use select statement. Can anyone tell me the other options to retrieve the whole data?

Regards,

Harish

[Former Member]

Hi Experts,

I have one master table, which contains about 16million records. My scenario is to retrieve all the data from the master table and display it using report. I am getting request time out error, when I use select statement. Can anyone tell me the other options to retrieve the whole data?

Regards,

Harish

[bpawanchand]

Hi

you can go for CURSORS rather than directly using select statement.Using secondary indexes also you can acheive this

Regards

Pavan

[Former Member]

Hi Pavan,

Can you give some example coding?

My coding is ,

Select fld1 fld2 fld3 fld4 fld5 fld6 from tab1 into inttab where fld1 in fld1.

Regards,

Harish

[Former Member]

what is ur select syntax? how are u trying to display the data???

[Former Member]

User Package size option.

Assume 100000 is package size , the every time it gets 100000

first time

100000

second time

100001 to 200000

-

---

....

Select some number of recorda and process it and then fetch from the count where you stoped before.

or Schedule Backgrond job.

[Former Member]

hii harish

use maximum keys to retrive data from table with select statement.

regards

twinkal

[Former Member]

Hai Patel,

how can i use keys in select statement to retrieve more than 1000000 records?

Regards,

Harish