Re: Implicitly hidden column & EXTNAME D/S

My belief is that adding columns will make no difference to SQLRPGLE using
SELECT * via static SQL.


-----Original Message-----
From: Vernon Hamberg [mailto:vhamberg@xxxxxxxxxxxxxxx]
Sent: Monday, May 04, 2020 10:20 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Implicitly hidden column & EXTNAME D/S

An interesting thought, Justin - the evidence of the I-specs that the
pre-compiler adds suggests you are right.

Now that also suggests to me that, if one uses SELECT *, then, if columns
are added, they will not be seen - no I-spec for the new columns.

Or is this just a Monday-morning fancy I'm going through?

Cheers
Vern

On 5/4/2020 10:15 AM, Justin Taylor wrote:

Unless I'm mistaken, the pre-compiler resolves the SELECT * at

compile-time, so the result is the same as explicitly listing the columns.

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-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