How i can create LF View To More than One Library?

5 pts.
Tags:
AS/400 DB2
LF View
Logical Files
how i can create LF View To More than One Lib.

Software/Hardware used:
iSeries (AS/400) OS/400 V5R2
ASKED: September 1, 2010  7:47 PM
UPDATED: September 2, 2010  1:01 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

An LF is a view over one or more PF.
The LF can be created in any library.
What is it you are trying to do?
Have a view over a single file or multiple files?
If it is multiple, your LF you would need to have some value(s) to JOIN the PFs.
You could have multiple formats.
If you need a more detailed answer, please let us know exactly what you are trying to accomplish.

Discuss This Question: 2  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
  • philpl1jb
    Are you refering to an SQL view to be used with SQL commands or a native Ligical file which would be used in RPG/COBOL reads. If its SQL then you would do it with a union statement As Create view myview as Select flda, fldb from lib1/file1 union Select flda, fldb from lib2/file1 while this can be done in a native lf with multi-formats. The native LF over multiple libraries can lead to some serious backup and restore issues. Phil
    48,575 pointsBadges:
    report
  • TomLiotta
    It can be done as a native DDS JOIN LF, a multi-format LF or simply as a normal LF over multiple data members. Or it can be done as a SQL DML VIEW that JOINs or UNIONs multiple underlying TABLEs and/or VIEWs or as a simple cross-product "join". There are multiple possibilities with native or SQL methods. The appropriate technique might require seeing a sample of the tables and a description of final result. 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