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



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.



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.