Re: Ruh Roh, STRSQL

Even so I'd like to be able to get rid of the "nag" message...unlike PDM
there's not one that I know of and i've looked believe me...

Thanks,
Tommy Holden



From: rob@xxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/18/2011 07:43 AM
Subject: Re: Ruh Roh, STRSQL
Sent by: midrange-l-bounces@xxxxxxxxxxxx



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