Re: Exclude a field from an SQL View

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Pipe dream I'd say...

Charles

On Thu, Jun 2, 2016 at 3:30 PM, Dan <dan27649@xxxxxxxxx> wrote:

> As far as I can tell from the documentation, I am unable to exclude from a
> View definition just one field from the table on which the view is
> created.  I.e.:
>
> create view  testlib/testtrv001
>    as select a.* EXCLUDING FIELD123 from testtrg001 a
>
> "EXCLUDING FIELD123" is my pseudocode to indicate that I want all of the
> fields in testtrg001 *except* FIELD123 included in the view definition.
>
> I know I can just list all 423 fields (less FIELD123) from the testtrg001
> table in the select, but taking a poker in the eye seems preferable.
>
> Pipe dream?
> --
> 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.