× 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.



Gad

That manual is still to be found in every release of IBM i - I found it at 7.3 and just posted what looks like the technique Patrik mentioned. I googled for "ibm db2 for i database programming" and found the manual there, in a Bulgarian version of Knowledge Center - the manual is still in English. But you can also get there using any version of Knowledge Center.

Regards
Vern

On 8/27/2024 6:59 AM, Gad Miron wrote:
Hello Patrik

Couldn't find this "DB2 for AS/400 Database Programming", SC41-5701

Can you post a link to it?

TIA
Gad



from: Patrik Schindler <poc@xxxxxxxxxx>
subject: Re: Quick join-logical question

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





------------------------------

Subject: Digest Footer

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) digest list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.



------------------------------

End of MIDRANGE-L Digest, Vol 23, Issue 736
*******************************************


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.