×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hello James,
Am 27.08.2024 um 02:25 schrieb James H. H. Lampert via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>:
It's been a while since I've set up a DB2 join-logical.
Suppose in my master file, I have two fields that refer to an employee roster file: "Tech. Advisor" and "Tech. Supervisor."
I'm guessing there's a way to join the master file to the employee roster file twice, but I don't know that for sure, and neither do I recall exactly how.
Wasn't a similar question popping up just recently? Maybe even from me?
[…]
Yes, but there hasn't been a definitive answer.
I'll have time to RTFM tomorrow.
I think I found the answer in the classic "DB2 for AS/400 Database Programming", SC41-5701, chapter about logical files. One of the missing documentation gems I discovered just a couple of Months ago. This extensively describes how to handle PFs and LFs and their associated capabilities.
I take it that nothing substantial has changed since then — in the last two decades — because it's all about classic files and not about SQL.
Highly recommended reading as a refresh, maybe? ;-)
:wq! PoC
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
