RE: Implicitly hidden column & EXTNAME D/S

[Justin Taylor <JUSTIN@xxxxxxxxxxxxx>]

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.