Re: Database Access Path Question

[Paul Tuohy <tuohyp@xxxxxxxxxxxxx>]

Not quite sure I follow, Chris. If you use the READE method, then the 
DYNSLT is redundant - actually, I think it would get in the way!

Paul

Chris Bipes wrote:
> Awh but DYNSLT and the field as the first key would fly.
>
> Chris Bipes
>
> -----Original Message-----
> From: Paul Tuohy [mailto:tuohyp@attglobal.net]
>
> This is really one of those "it all depends". By using the READE 
> approach you are tackling the requirement through an application program 
> - which means that the same solution has to be "coded" in every program 
> that would require that selection path.
>
> By using the DYNSLT approach, it is being done by the database manager 
> ans all an application (RPG, SQL, Java etc.) has to do is open the file 
> and process it.
>
> As Steve pointed out, the use of DYNSLT can be quiet an overhead 
> depending on the number of row returned.