Re: Ruh Roh, STRSQL

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

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