select stmt condition

[Former Member]

hello friends,

can we use ' for all entries '

when ever we want to join internal table and database table

or are there any restictions in using that,

one restriction today i came through was that,

i could not use it againt bseg table.

are there any more.

thank you.

[RichHeilman]

Cluster tables are usually an issue with inner joins as well, so I would assume that you would have the same trouble with "For all entries".

So to answer your question, yes there are limitations when dealing with cluster and/or pooled tables.

Regards,

RIch Heilman

[Former Member]

Hi saritha,

The restriction you are talking about is not with FOR ALL ENTRIES. It is the restriction with JOINS.

You can not use JOINS with Cluster or pooled table. BSEG is a cluster table.

You can use FOR ALL ENTRIES whenever you want to fetch a data from the DB table based on the data from the internal table. just make sure that your internal table is not blank, otherwise it will fetch all the record from DB table.

Reward points if useful.

Regards,

Atish

[Former Member]

Joins - do not use more than 4 tables at a time ..( if you use then it will be performance issue )

do not use joins - in case of pooled and cluster table

for all entries will be using all tables

some times you need to get duplicate values from tables ,if you use for all entries then it will not get duplicates

always maintain primary key in for all entries condition.

[Former Member]

Saritha,

You can not use the joins for cluster and pool table.

You can use for all entries when ever you want to join internal table and database table(transporant tables ).

Don't forget to reward if useful.