Re: stupid SQL message...

Sweet I found this little nugget thanks to an earlier suggestion
http://www.code400.com/forum/showthread.php/5158-Run-SQL-Scripts-Without-Starting-iSeries-Navigator
maybe that'll give me more of an inclination to use it...but that still
doesn't give me the answer to what I was asking to begin with lol

Thanks,
Tommy Holden



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



Vern, I've never known you to be anything but serious <vbg>

There is a built in prompter in Scripts (from the Edit Menu take SQL
Assist or just press F4 on a blank line). It is a little slow to start
up (Java I assume) and the prompt is only for DML statements. The
assumption is that you would be using all the other GUI stuff in the
database option for the DDL.

The Examples option is a very good idea - just not very good examples :-)

Regards

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





Vern Hamberg wrote:

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.