×
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.
I think...you can use logical file names. Haven't tried it though.
Can you create a LF over the PF and then join the PF & LF?
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Patrik Schindler
Sent: Monday, July 15, 2024 5:11 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Translate SQL Join to DDS LF
Hello,
I'm searching for the DDS equivalent of the following SQL JOIN statement:
SELECT … FROM table1name
LEFT JOIN table2name join_name ON ( … )
The join_name is required when one needs to join the same table2name multiple times but interrelate the same field in table2name to different fields within table1name.
These are referred in the field list as SELECT join_name.field_name FROM …
The DDS compiler naturally complains about the same PFs being referred multiple times if just adding them multiple times but with different join fields. According to the DDS Reference, it's not allowed to name join specifications in pos. 19.
Hints welcome.
:wq! PoC
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 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.
midrange.com
