Re: RUNSQLSTM

[Bruce Hoffman <bruce.hoffman@xxxxxxxxxxxxxxxxx>]

you might want to check out the SET SCHEMA statement.

On 03/31/2010 09:50 AM, David FOXWELL wrote:
> Well, I've narrowed things down to find the part that won't work.
>
> The program that runs the RUNSQLSTM does an ovrdbf on myfile then the program crashes on SQL0204.
> The funny thing is, if I make an empty copy of myfile in my CURLIB, the program works, and the ovrdbf are respected also.
>
> I will get rid of the ovrdbf and use CHGCURLIB.
>
>
> CREATE TABLE QTEMP/RRN AS (
> with t as (
> SELECT fld1, fld2, fld3, MAX(fld4) lmax FROM myfile GROUP BY
> fld1, fld2, fld3)
>
> select rrn(a) from myfile a join t on
> a.fld1=t.fld1 and
> a.fld2=t.fld2 and
> a.fld3=t.fld3 and
> a.fld4=t.lmax
> join otherFile m on m.fld1= a.fld1 and m.fld2=a.fld2
>          where a.fld4 ='.'  ) with data
>
>
>
>
>
>
>
>
>
> > -----Message d'origine-----
> > De : midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Dennis Lovelady
> > Envoyé : mercredi 31 mars 2010 14:51
> > À : 'Midrange Systems Technical Discussion'
> > Objet : RE: RUNSQLSTM
> >
> > > I think you meant to say SQL _DOES_ honor OVRDBF.
> > http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzajp/rzaj
> > > p
> > > runningoverride.htm
> >
> >
> > No, I meant to say, "SQL doesn't ALWAYS honor..."
> > http://archive.midrange.com/midrange-l/200807/msg00591.html
> >
> > Dennis Lovelady
> > http://www.linkedin.com/in/dennislovelady
> > --
> > "All progress is based upon a universal innate desire on the
> > part of every organism to live beyond its income."
> >          -- Samuel Butler
> >
> > --
> > 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.