Re: Ruh Roh, STRSQL

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