Re: Ruh Roh, STRSQL

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Uh.

Was this directed to me?  I never said anything about SQL being 
stabilized.  SQL on the i is one of the best implementations available 
and SQL has received arguably the most attention of any single component 
of the IBM i OS over the last decade.  I use it constantly, both ad hoc 
and in programs.  I couldn't live without it, frankly.  I was just 
commenting on the possible sunsetting of the 5250 tool, a trend we've 
been seeing from IBM over the last several years at least.

Joe

> 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