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



No wonder I feel like it takes forever to accomplish something!

DOH!!!!!!!!!



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dennis Lovelady
Sent: Friday, November 12, 2010 8:59 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: stupid SQL message...

You don't stop/start 5250 in between each
command,
do you?


Yipes! Are you telling us we don't need to do that?!?!?! :)

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"I am an old man and have known a great many troubles, but most of them
never happened."
-- Mark Twain


I just leave iNav up. You don't stop/start 5250 in between each
command,
do you?


Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 11/11/2010 12:27 PM
Subject: Re: stupid SQL message...
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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.


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