Re: stupid SQL message...

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.