Re: stupid SQL message...

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

I use the index advisor from time to time but for day-to-day adhoc queries 
the green screen is still my preference...I do use GUI interfaces etc but 
having every possible tool I might need loaded taxes my PC when I can do 
90% on the green screen using very little PC resources. 

Thanks,
Tommy Holden



From:   Paul Tuohy <tuohyp@xxxxxxxxxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   11/11/2010 11:56 AM
Subject:        Re: stupid SQL message...
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



Frog and Squirrel are both excellent (I use Squirrel a lot)...

But the big advantage Scripts has is that little button for Visual 
Explain.

Regards
 
Paul Tuohy
ComCon
www.comconadvisor.com 
www.systemideveloper.com 
 




Jim Steil wrote:
> I prefer Frog
>
> http://www.innovativesys.net/?page_id=8
>
> Requires client access installed on the client machine.  Both are great 
> alternatives to STRSQL or Navigator.
>
>      -Jim
>
> On 11/11/2010 11:15 AM, dieter.bender@xxxxxxxxxxxx wrote:
>
> > try:
> >
> > CHGMSGD MSGID(SQL6789)
> >          MSGF(QSYS/QSQLMSG)
> >          MSG('Have you considered using Squirrel instead of System i
> > Navigator''s Run SQL')
> >          SECLVL('Cause . . . . . :   its Open Source, faster, more 
stable,
> > more powerfull and could access
> >                  any JDBC Database. To find out more, look here:
> > http://www.squirrel-sql.sourceforge.net/'
> >                 )
> >
> > D*B
> >
> >
> > --------------------------------------------------
> > From:<Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
> > Sent: Thursday, November 11, 2010 5:28 PM
> > To: "Midrange Systems Technical Discussion"<midrange-l@xxxxxxxxxxxx>
> > Subject: RE: stupid SQL message...
> >
> >
> > > I did and the full message text is what is pasted into the original
> > > email...
> > >
> > > Thanks,
> > > Tommy Holden
> > >
> > >
> > >
> > > From:   "Harman, Roger"<Roger.Harman@xxxxxxxxxx>
> > > To:     "'Midrange Systems Technical Discussion'"
> > > <midrange-l@xxxxxxxxxxxx>
> > > Date:   11/11/2010 10:27 AM
> > > Subject:        RE: stupid SQL message...
> > > Sent by:        midrange-l-bounces@xxxxxxxxxxxx
> > >
> > >
> > >
> > > Have you tried HELP on the message?  The similar one for SEU tells you 
to
> > > disable that one via PDM defaults.  Maybe same option for STSQL?
> > >
> > >
> > > -----Original Message-----
> > > From: midrange-l-bounces@xxxxxxxxxxxx [
> > > mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jack Kingsley
> > > Sent: Thursday, November 11, 2010 7:02 AM
> > > To: Midrange Systems Technical Discussion
> > > Subject: Re: stupid SQL message...
> > >
> > > Tommy, gonna guess on this, does this message id show up in your 
QSQLMSG
> > > message file??  If it does could you change it
> > > there??
> > >
> > > On Thu, Nov 11, 2010 at 9:25 AM,<Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
> > > wrote:
> > >
> > >
> > > > I should have mentioned i'm running v7.1
> > > >
> > > > Thanks,
> > > > Tommy Holden
> > > >
> > > >
> > > >
> > > > From:   Jeff Crosby<jlcrosby@xxxxxxxxxxxxxxxx>
> > > > To:     Midrange Systems Technical 
Discussion<midrange-l@xxxxxxxxxxxx>
> > > > Date:   11/11/2010 08:24 AM
> > > > Subject:        Re: stupid SQL message...
> > > > Sent by:        midrange-l-bounces@xxxxxxxxxxxx
> > > >
> > > >
> > > >
> > > > I don't know how to turn it off, but I don't get the message either. 
I'm
> > > > at
> > > > V6R1.
> > > >
> > > >
> > > > On Thu, Nov 11, 2010 at 8:10 AM,<Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
> > > > wrote:
> > > >
> > > >
> > > > > Does anyone know where exactly I can turn off this stupid message?
> > > > >
> > > > > Message ID . . . . . . :   SQL6789       Severity . . . . . . . : 00
> > > > > Message type . . . . . :   Information
> > > > > Date sent  . . . . . . :   11/11/10      Time sent  . . . . . . :
> > > > 07:07:20
> > > >
> > > > > Message . . . . :   Have you considered using System i Navigator's 
Run
> > > > >
> > > > SQL
> > > >
> > > > >   Scripts instead of STRSQL.
> > > > > Cause . . . . . :   System i Navigator is packaged within the IBM I
> > > > Access
> > > >
> > > > > for
> > > > >   Windows (57xx-XE1) product. To find out more, look here:
> > > > >   http://www.ibm.com/systems/i/software/access/get_started.html
> > > > >
> > > > > Every time I use STRSQL and return to the command line I get that
> > > > message.
> > > >
> > > > >   Unlike the one spit out from PDM I can't find where to turn this
> > > thing
> > >
> > > > > off.  I know it's a minor nuisance but anytime a message comes up I
> > > have
> > >
> > > > > to do a "double take" to make sure something hasn't gone
> > > > catastrophically
> > > >
> > > > > wrong (call it OCD if you wish lol)
> > > > >
> > > > > Thanks,
> > > > > Tommy Holden
> > > > > --
> > > > > 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.
> > > > --
> > > > Jeff Crosby
> > > > VP Information Systems
> > > > UniPro FoodService/Dilgard
> > > > P.O. Box 13369
> > > > Ft. Wayne, IN 46868-3369
> > > > 260-422-7531
> > > > www.dilgardfoods.com
> > > >
> > > > The opinions expressed are my own and not necessarily the opinion of 
my
> > > > company.  Unless I say so.
> > > > --
> > > > 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.
> > > -- 
> > > 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.
> > >
> > >
> > > -- 
> > > 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.