RE: embedded sql session error in subfile

On Tue, 2005-07-26 at 21:07, Douglas W. Palme wrote:
> I have a logical file which is built across four physical files.....they are 
> joined files....the sql statement works in the sql interactive mode, I do 
> not see how the query optimizer is going to figure out from four separate 
> physical files which logical file I am using, not to mention that the reason 
> I used a LF was to exclude certain records at the file level, instead of 
> having the query system do it.

But that's what the Query Engine does...

You should perform your JOINs as part of your SQL, I'm not sure how the
Engine would handle such a logical file.  If it is something you are
going to use a lot, create a view out of the appropriate JOINs and use
that for your SQL.

Joel Cochran
http://www.rpgnext.com