Home > IT Answers > AS/400 > AS/400 query for logical file
anupsshelke
420 pts.
 AS/400 query for logical file
AS/400 logical file, as400/DB2
I have one join file and one logical file. It is possible to create logical file on join logical file?

Software/Hardware used:
s/w
ASKED: May 18, 2012  8:21 AM
UPDATED: June 14, 2013  6:15 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by anupsshelke (Question Asker)

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.

Tom

ANSWERED:  May 25, 2012  6:38 AM (GMT)  by anupsshelke
 
Other Answers:
Last Wiki Answer Submitted:  June 14, 2013  6:15 pm  by  Michael Tidmarsh   14,060 pts.
Latest Answer Wiki Contributors:  Michael Tidmarsh   14,060 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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

Raja7rays
 10 pts.
 

thank you sir
Raja7rays

anupsshelke
 420 pts.
 

You create a new logical based on the actual physicals.

philpl1jb
 44,630 pts.
 

you cannot create a Logical File based on another Logical File. You can do it based on Physical Files.

sudheer794
 315 pts.
 

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.

graybeard52
 3,115 pts.