Re: Looking for file structure details

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

IIRC, Run an SQL Script in the thick client does have a wizard for 
building some SQL statements - SELECT, INSERT, UPDATE, & DELETE are the 
only options in the wizard.

There are (as you know, so this is for others) sample statements - I 
don't use these much - either of these, actually.

I see that if you have entered something like

select * from qiws.qcustcdt

and press F4, it does pre-fill the wizard with the components of that 
statement - so that's nice enough.

But when I entered this -

with xx as (select * from qiws.qcustcdt) select * from xx

and pressed F4, got a dialog saying the statement was not supported.

This is even less useful, for me, than F4 in STRSQL. I risk overstating 
that, so someone please help me find better stuff there.

I hope the same feature in the web Navigator is more robust - have not 
tried it yet.

HTH
Vern

On 6/29/2015 9:39 AM, Kurt Anderson wrote:
> Our machine apparently gave up on that message.  (Maybe it went away with v7r2?)
>
> I tried the alternative, but with STRSQL right there, Run SQL Scripts was simply a pain to get to.  And all of our users use STRSQL and getting them to use Run SQL Scripts will be a bear.
>
> Currently the only time I go to Run SQL Scripts is when I want to test a stored procedure.  I've used Visual Explain a couple times as well.  It's Index Advisor was neat for 5 minutes, but accessing the tables manually is a much better experience IMO.
>
> Kurt Anderson
> Sr. Programmer/Analyst - Application Development, Service Delivery Platform
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Yeung
> Sent: Friday, June 26, 2015 4:41 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Looking for file structure details
>
> On our machine, we get the nudge messages for STRSQL, implying that it's deprecated; but no such messages for RUNQRY or WRKQRY!
>
> John Y.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.