AS/400 query for logical file

420 pts.
Tags:
AS/400 DB2
AS/400 logical file
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

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 6  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Raja7rays
    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
    10 pointsBadges:
    report
  • anupsshelke
    thank you sir Raja7rays
    420 pointsBadges:
    report
  • philpl1jb
    You create a new logical based on the actual physicals.
    50,385 pointsBadges:
    report
  • sudheer794
    you cannot create a Logical File based on another Logical File. You can do it based on Physical Files.
    315 pointsBadges:
    report
  • graybeard52
    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.
    3,115 pointsBadges:
    report
  • TomLiotta
    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
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following