Re: stupid SQL message...

But that's kinda my point Paul.  I rarely need the other functionality
(read bloat) that comes with opening Navigator so it's an unnecessary
resource hog.  Since I rarely use any of the application why fire it up
daily "just in case"?  I almost always have a telnet session up so it's
just faster for me.  To each his/her own, the only real nice thing about
using scripts is the ability to copy/paste without having to modify the
statements so they fit STRSQL's command/statement line.

Thanks,
Tommy Holden



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



Now Tommy - not an issue if you already have Navigator already fired up
and ready to go. Click on the Navigator icon after you click on your
5250 icon :-)

Seriously, I much prefer Scripts to STRSQL.

Regards

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





Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx wrote:

I can have my queries run and results returned minutes before Navigator
even fires up...but thanks for the grin ;)

Thanks,
Tommy Holden



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



Tommy,

Surely it would just be simpler to use Run SQL Scripts <g>

Regards

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





Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx wrote:

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.