Re: Ruh Roh, STRSQL

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

I don't remember anyone saying SQL will be "stabilized". But to some 
extent, development has stopped on STRSQL. At least so far as I can tell.

STRSQL - that has not been updated in years to support prompting new 
features of SQL on i. The same interface and support is used in SEU when 
prompting embedded SQL, as well as RDP, I believe - haven't tried that 
in a long time. And it is the same interface in STRQM.

I do wish they'd make a proper wrapping interface there - each line 
being a single field - well, it's the ultimate in clumsy.

And not supporting JOIN syntax? It has been at least a decade since that 
was available on what has become the i. Really!!

To be clear, STRSQL will run any of the new stuff - and even get field 
lists in prompts from JOIN syntax - it's just so blasted limited!

The other area I wish IBM updated is RTVQMQRY from a *QRUDFN - 
ridiculous that the various join options are not properly retrieved. Sheesh!

OK, off to work now!
Vern

On 1/18/2011 7:42 AM, rob@xxxxxxxxx wrote:
> 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