topic Re: select stmt condition in Application Development and Automation Discussions

select stmt condition

Former Member — Wed, 20 Jun 2007 01:56:34 GMT

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.

Re: select stmt condition

RichHeilman — Wed, 20 Jun 2007 02:01:24 GMT

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

Re: select stmt condition

Former Member — Wed, 20 Jun 2007 02:01:49 GMT

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

Re: select stmt condition

Former Member — Wed, 20 Jun 2007 02:29:16 GMT

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.

Re: select stmt condition

Former Member — Wed, 20 Jun 2007 02:58:05 GMT

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.