Hello,

Is it possible to pass the subquery as a filter(WHERE clause) in the master file?

Thankyou

The only thing you can do in the master file is add DBA information that will perform the filtering for you. Mind you, this is a fixed filter and can't be made variable. It can be put in the master file for either certain named users, as well as for all users.

The FILTER FILE and related SET FILTER commands may offer a possible solution for you.

The other option is to use a cross reference file.

You would have to populate the cross reference file, and it would have to be a FOCUS file.

In the main Master it would effectively be a multi segment file.

Thanks everyone for replying.

I am wondering if the correlated subquery is supported in WF or is there any silimar stuff in WF.
My subquery has no filters and it would be bringing back millions of rows, when queried seperately.

In that case, the SET FILTER or cross reference file would NOT be an effective solution.

Can anyone suggest me how to approach this (or sql pass-thru is the only solution)