fetching datas from pooled and cluster tables

[Former Member]

Hi ,please tell me how to fetch data from pooled and cluster tables .How to write the select query.

Thanks and Regards,

Jagan.

[Former Member]

>

> Hi ,please tell me how to fetch data from pooled and cluster tables .How to write the select query.
> 
> Thanks and Regards,
> Jagan.

Hi jagan,

You can retrive the data from table-pools similar to data retrival from other tables. But you can't use pooled tables in joins.

You can use IMPORT key word for data retrival from a cluster.

Ex:

IMPORT obj1 ... objn FROM DATABASE dbtab(ar) ID key.

~sdn

Thanks

NItesh

[Former Member]

hi

use the select query like

SELECT * into table i_data FROM Table name

regards

Aakash

[Former Member]

Hi,

Pool Tables (match codes, look up tables)

Should be accessed via primary key or

Should be buffered (SE11->Display Table->technical settings)

No secondary indexes

Select * is Ok because all columns retrieved anyway.

Cluster Tables (BSEG,BSEC)

Should be accessed via primary key - very fast retrieval otherwise very slow

No secondary indexes

Select * is Ok because all columns retrieved anyway.

eg:

• Fetch data for employee

SELECT * FROM zemployee

INTO TABLE i_zemployee.

hope it helps u!

Regards,

Mamta