Re: Select * into an external DS, and then adding columns

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Hmm...that's interesting...

Only thing I can figure is that the code generated by the pre-compiler
switch the * to an explicit column list.

You should get an error if you use dynamic SQL.

Charles

On Fri, Feb 5, 2016 at 1:45 PM, <rob@xxxxxxxxx> wrote:

> Scenario:
>
> You have something like this:
>      D RCODS         E DS                  EXTNAME(RCO)
>      C/EXEC SQL
>      C+ DECLARE C CURSOR FOR
>      C+ SELECT * FROM RCO
>      C+ WHERE CMPNY BETWEEN :
>      C+ W1LWCO AND :W1UPCO AND CRSTS = 'A'
>      C+ ORDER BY CMPNY FOR FETCH ONLY
>      C/END-EXEC
>      C/EXEC SQL
>      C+ OPEN C
>      C/END-EXEC
>      C/EXEC SQL
>      C+ FETCH C INTO :RCODS
>      C/END-EXEC
> You add a column to the table, and do NOT recompile this program.
> Therefore the external DS doesn't match.
> ALTER TABLE RCO
> ADD COLUMN ...
>
> I thought (many releases ago) that this used to generate a mild warning.
> Then it became a hard halt.
> I just tried it with seclvl 0 logging and STRDBG running and no warning
> whatsoever.  The data came from the cursor and worked just fine.
>
> Rob Berendt
> --
> IBM Certified System Administrator - IBM i 6.1
> Group Dekko
> Dept 1600
> Mail to:  2505 Dekko Drive
>           Garrett, IN 46738
> Ship to:  Dock 108
>           6928N 400E
>           Kendallville, IN 46755
> http://www.dekko.com
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.