What is the difference between a logical file and view in DB2/400?

1215 pts.
Tags:
DB2/400
Logical Files
What is the difference between logical file and View in DB2/400?

Answer Wiki

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

a Logical file can be updated, but a view once it is created can not be updated, unless you update the file that the view was created and then re-create the view. Hope this helps.

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
    Logical files with the default setting for MAINT(*IMMEDIATE) provide an up-to-date map of the data by updating the map with every add/delete or key change in the file(s). Logical file with maint(*REBUILD) is very much like a view, it contains the rules and when used will build the required index on the fly. No overhead when it's not in use, significant when it is. The logical file can be keyed which is useful in native languages, the view can be sorted. An SQL Index resembles the logical file MAINT(*IMMEDIATE) in that it maintains a map of the data, however, an index does not provide alternate formats or joins. I'm sure there is more. Phil
    49,970 pointsBadges:
    report
  • tjgm88
    Just to add to the discussion. Logical Files are just a set of indixes providing an ordered access as per the key(s) defined. The data still resides in the physical that the logical is built over. Howerever, any updates/deletes done via the logical updates teh physical. Logical files are very useful to reorder the data, but bead in mind the response implications when too many logicals are built ove the same physical. Any update to the physical will trigger updates to all the logicals (especially if *IMMED is specified) and can have an impact on response times. Cheers!
    995 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