Non join logical file in DB2/400

5 pts.
Tags:
AS/400
What is the use of multiple record non join logical file in DB2/400?

Software/Hardware used:
as400

Answer Wiki

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

Main use of Logical File is creating the index or view for a physical file for ease in accessing data.
I think it would be useful, if you can post the scenario which made you to think of this question. That might help you to get the required answer.

Pradeep.

Discuss This Question: 11  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
    Obviously, you didn't google this. Phil
    49,940 pointsBadges:
    report
  • TomLiotta
    I assume that you are asking about a "multi-format" logical file rather than a "multi-record" logical file. A physical file can have only a single record format. A multi-format logical file (LF) provides a way of accessing different record formats through a single file object. The LF isn't a "join" but more like a "union". As for what the uses are, I have no good idea. I don't think they should be used at all in a relational database. If knowledge of them can sometimes be useful due to the chance (or is that "risk"?) of running into them in old applications. Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    Another interview / homework question?
    49,940 pointsBadges:
    report
  • pdsathishkumar
    multi-format logical file prepare for reduce the declare in rpg/400 program... becoz in rpg/400 program contain limited declaration database only..... in that time we can use the multi format logical file........
    3,790 pointsBadges:
    report
  • Sureyz
    rpg/400 program contain limited declaration database only….. I'm not clear with this.. Can anybody Explain ? Surey..
    2,405 pointsBadges:
    report
  • philpl1jb
    Yes, there was a limit on the number of files that could be declared in F spec's in RPG/400 (not in the current RPG-IV ). Since the multi-format could present the records from a number of files with 1 F spec it provided a work around for this issue. this can only be used with files where appropriate key fields exist. Actually, this was developed to simulate processing from a card reader. Cards would be sorted in correct processing order prior to the process. Phil
    49,940 pointsBadges:
    report
  • TomLiotta
    rpg/400 Note that there is very little reason to use RPG/400 nowadays. RPG IV should be used instead for new objects. Even when maintaining old RPG/400 programs, serious consideration should be given to converting the source to RPG IV format and compiling as RPG IV. RPG IV has been available for 15 years or so. Since i 7.1 (or was it 6.1?), the RPG/400 compiler is a separately chargeable item. It is one of the "Heritage Compilers" that is no longer being enhanced. Tom Tom
    125,585 pointsBadges:
    report
  • Splat
    Multi-format logicals were to some degree a concession to those coming to the S/38 and the AS/400 from the S/34 and S/36. Without them legacy applications would have had to be completely re-designed, an expense that few businesses would willingly bear.
    7,215 pointsBadges:
    report
  • TomLiotta
    ...those coming to the S/38 and the AS/400 from the S/34 and S/36. Minor detail -- the System/38 preceded the System/36. S/38 was perhaps more intended to replace the whole System/3 line. In any case, the S/38 began some 33 years ago. Are we talking about the "purpose" of multi-format LFs originally or their purpose in today's world? To me, they no longer have a purpose except that they haven't been eliminated yet. It seems odd to discuss elements like this. In a Windows forum, how often are questions seen like "What's the purpose of the SUBST command?" Sure, it still works more or less like it always has; but who recommends its use today? What is its purpose today? If a thing is obsoleted by newer things, how should 'purpose' be described? Tom
    125,585 pointsBadges:
    report
  • philpl1jb
    I hope Tom doesn't get to switch me off, I may have historical significance but purpose??? Ar well, maybe the issue should be the purpose of the original question. "Another interview / homework question?" Phil
    49,940 pointsBadges:
    report
  • TomLiotta
    I may have historical significance but purpose??? I started with wiring logic boards for unit-record machines, then made the jump to 1401 machine language and then Autocoder. Our mutual 'purposes' might not be too different. 'Historical' discussions can be fine and fun. They can even provide some justification of things at times -- "Why are screens 80 characters wide?" It's not unusual for someone to be hired into an entry-level, maybe off-shift operator position. Over time, simple CL coding begins. Then curiosity or basic drive to go farther starts pushing into RPG and various methods. Spending 8 hours doing little but flipping through manuals or trying to make sense of an Information Center can lead to a lot of questions. But some questions may be a waste of time for the asker. If no one points out that something may be ignored (at least until a better foundation is built when it can make sense), a lot of time of those who ask -- and those who answer -- is gone. Also, this site is global. When English is a second language, the asker's definition of "homework" might be "work I do at home on my own time". Or "interview" might be taken to mean "I'm part-time and studying for a full-time interview that I hope will come if I can learn enough, and the manual is confusing". Would a valid interview use the term "multiple record non join logical file"? (If one did, should the interviewee decline an offer of employment from them?) Internet access might only be available through a connection at work, especially in many parts of the global community. Numerous simple questions get asked here with followups coming a week or two later. That could indicate highly restricted availability of connections. Work places may have blocks against Google or similar sites while allowing access to technical forums. (That's exactly how it is when I'm in the office that I work in -- Websense.) If I lived in some areas of Mumbai, I might have no option but to ask here. Answers here should not substitute for legitimate academic homework. That's something can't be disputed, but it's not always straightforward when determining when it is 'homework'. It seems to me that a 'local yokel' is perhaps most likely to come up with a plausible excuse that sidesteps the question of "Is this homework/interview" and weasels an answer out of someone. 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