RE: Implement SQL in logical files

One other thought - since the fields from the 2nd file are going to be null
anyway why not leave those fields out of the record format of the Join File.


Paul


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Paul
Therrien
Sent: Sunday, August 22, 2021 10:37 AM
To: 'Midrange Systems Technical Discussion' <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: RE: Implement SQL in logical files

ALWNULL

My typing skills are not the best (especially on a Sunday morning!)


Paul

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Patrik
Schindler
Sent: Sunday, August 22, 2021 10:34 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Implement SQL in logical files

Hello Paul,

Am 22.08.2021 um 16:21 schrieb Paul Therrien
<paultherrien@xxxxxxxxxxxxxxxxxx>:

When you remove the OMIT specs from the joins do you get data?

Yes, I wrote that implicitly in my text, mentioning one of the two screen
shots.

When you include the OMIT specs you are asking the database to return
NULLs in xxx_IST fields.

Wild ass guess:
Do you need to specify ALLNULL on the fields in the record layout?

I cannot find the term ALLNULL neither in my DDS reference, nor in my ILE
RPG reference documents. I have older ones for matching my OS version on the
150, V4R5. From a Google search, it seems to be a H spec (in newer releases
only?).

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

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com

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

Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com