Re: stupid SQL message...

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

More like:
try:

CHGMSGD MSGID(SQL6789)
        MSGF(QSYS/QSQLMSG)
        MSG('How to I kill this frigging message?')
        SECLVL('Cause . . . . . :   because IBM dropped the ball on this 
one!')

Thanks,
Tommy Holden



From:   <dieter.bender@xxxxxxxxxxxx>
To:     "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Date:   11/11/2010 11:19 AM
Subject:        Re: stupid SQL message...
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



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.