|
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 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.
midrange.com
