Re: Ruh Roh, STRSQL -- MIDRANGE-L

David,

AFAIK, the "WHERE key=key" is valid only when the SELECT--- TABLEA, TABLEB
form is used. Any time you use a JOIN (inner, outer, etc.) the ON clause is
needed. You can also substitute ON with USING if your variable names are the
same in both tables, as in:

SELECT a.*, b.* from Orders A INNER JOIN Client_Info B Using (CustNumber);

rEGARDS,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--

On Tue, Jan 18, 2011 at 9:54 AM, David FOXWELL <David.FOXWELL@xxxxxxxxx>wrote:

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.