RE: Ruh Roh, STRSQL

Until recently I never even noticed that you COULD prompt in STRSQL. I
guess I just never really saw the point, seems faster to just type the
statement. Though, I hardly use STRSQL except for 1 off scripts I need to
make DB fixes while I'm already in the green screen. I either use iNav
for testing script performance or FROG for script development. Go ahead,
Sunset the baby :D


Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777



David FOXWELL <David.FOXWELL@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/18/2011 09:24 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Ruh Roh, STRSQL






I do find the lack of prompting very annoying on the green screen.
Particularly as I use ANSI joins (I think that was something I learnt on
this thread. Does that mean JOIN on key=key instead of WHERE key = key?
But is there an advantage other than it being more intuitive?) The
prompting in iNav is good but slow. I hate having to indicate library
names and I don't know how to access a multimember file like I can on the
green screen with an ovrdbf.
I mainly use it when I want to save my sql scripts for later use.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de rob@xxxxxxxxx
Envoyé : mardi 18 janvier 2011 14:42
À : Midrange Systems Technical Discussion
Objet : Re: Ruh Roh, STRSQL

SQL on the i has not been "stabalized" despite certain bear
baiting comments from individuals who have some pet thing
they wish it did. Has this person submitted a DCR to get it done?
STRSQL is not the only extent of SQL on the i. It is just a
5250 command line to SQL statements with some limited prompting.
If you limit your SQL usage to that you can only prompt from
within STRSQL you are really losing out! I suggest you get a
book on SQL and read that.
We have a developer that works wonders with it and he's
learned a bulk of his from the IBM manuals.

I can't imaging them doing away with STRSQL in the
foreseeable future. I think it is just a recommendation to
try and look at the iNav interface into SQL. For simple SQL
I like the prompter in STRSQL versus the 'examples' in iNav.
But I have stored some scripts from iNav and use them on
occasion. Like, disk analysis and whatnot.


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: Jack Kingsley <iseriesflorida@xxxxxxxxx>
To: Midrange Systems Technical Discussion
<midrange-l@xxxxxxxxxxxx>
Date: 01/17/2011 04:55 PM
Subject: Re: Ruh Roh, STRSQL
Sent by: midrange-l-bounces@xxxxxxxxxxxx



Is that on 7.1??

On Mon, Jan 17, 2011 at 3:22 PM, Joe Pluta
<joepluta@xxxxxxxxxxxxxxxxx>wrote:

Remember when we started getting messages about "Have you tried the
modern alternative to PDM?" It wasn't terribly long after

that message

that SEU was "stabilized". Well, I was using SQL today and

I noticed

this message on the bottom of the screen:

"Have you considered using System i Navigator's Run SQL

Scripts instead

of STRSQL."

Time perhaps to start preparing for a stabilized STRSQL?

Joe
--
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 message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us and destroy this message immediately. ---