It is possible to create logical file on join logical file?
No, not if it's a native DDS logical file. If it's a join logical file that's a SQL VIEW, then yes, you can create another logical file that is also a SQL VIEW over it.
not possible, bcoz join file is one of the logical file then how could u build the lf on another lf, so it’s not possible
thank you sir
You create a new logical based on the actual physicals.
you cannot create a Logical File based on another Logical File. You can do it based on Physical Files.
You can however, create a SQL view over a logical (though not the best for performace), or a SQL view over another SQL view.
In most cases, a SQL view will work as well as an unkeyed logical. Depends what you are trying to accomplish.