Re: stupid SQL message...

Hi Paul

Serious question - if you can believe that!

I've not found the Run SQL Scripts interface to be very helpful in prompting statements - have I missed something? I've seen various examples you can load, but not a nice statement builder. Like, there's no way to drag column names and all into the edit window. Or functions. Is there?

Similarly, the STRSQL interface is, first of all, awful with all those individual fields for the statements - can't insert and wrap, etc. And it does not support recent - or even not so recent - things, even JOIN is not promptable. It IS honored, but...the prompting it DOES support is what helped me learn SQL at all - decades (well not exactly) ago.

Sigh!

Off to sunny balmy Rochester for a couple days!

Vern

On 11/11/2010 10:59 AM, Paul Tuohy wrote:

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.