Re: RUNSQLSTM

[Charles Wilt <charles.wilt@xxxxxxxxx>]

There isn't a different...

If all you're doing is a SELECT, then the override should be honored.

If you're trying to do DDL statments, ALTER TABLE, LABEL ON,
ect...then the override is not honored.

Charles

On Wed, Mar 31, 2010 at 9:29 AM, Vern Hamberg <vhamberg@xxxxxxxxxxx> wrote:
> But RUNSQLSTM is not embedded SQL - is there a difference there? Perhaps
> F1 can help - I'm not at a machine, so can't say.
>
> Vern
>
> Charles Wilt wrote:
> > I think you meant to say SQL _DOES_ honor OVRDBF.
> >
> > http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzajp/rzajprunningoverride.htm
> >
> > Running a program with embedded SQL: Override considerations
> >
> > You can use overrides (specified by the OVRDBF command) to direct a
> > reference to a different table or view or to change certain
> > operational characteristics of the program or SQL Package.
> >
> > HTH,
> > Charles
> >
> > On Wed, Mar 31, 2010 at 7:52 AM, Dennis Lovelady <iseries@xxxxxxxxxxxx> wrote:
> >
> > > > Are there any issues with OVRDBF and RUNSQLSTM?
> > > It's been well established on this list that SQL does not honor OVRDBF
> > > settings.  Search archives (SQL OVRDBF) for specifics.
> > >
> > > Dennis Lovelady
> > > http://www.linkedin.com/in/dennislovelady
> > > --
> > > "Appeasers believe that if you keep on throwing steaks to a tiger, the tiger
> > > will become a vegetarian."
> > >        -- Heywood Broun
> > >
> > > --
> > > 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.
> --
> 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.