× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. November 2010

Re: stupid SQL message...

... I like STRSQL too, its not so bad - and with ArdGate (Open Source) you could access MySQL, Oracle, MS SQL Server and any other JDBC capable database with STRSQL.
If people would like to change, IBM would have put a message at startup from Database Navigator: "Congratulations, you have choosen the great alternative...

D*B


--------------------------------------------------
From: <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx>
Sent: Thursday, November 11, 2010 6:37 PM
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Subject: Re: stupid SQL message...

Ironic...I post a question on how to remove an annoying message about
STRSQL alternatives and I get tons of replies about other alternatives???
I've use FROG, Navigator (haven't used squirrel but i've heard people
going nuts (pun intended) about it). I still prefer STRSQL though. But
feel free to continue offering other alternatives...I need more annoyance
about SQL alternatives LOL

Thanks,
Tommy Holden



From: Jim Steil <jim@xxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/11/2010 11:30 AM
Subject: Re: stupid SQL message...
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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.


--
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.