I keep the Schemas table view open anytime I have Run Sql Scripts open.
Pick a table, right click, and select definition. Once in there, I
select browse. That lets me click around to files and instantly see the
columns. I'm sure there is a faster way to get there (or if there isn't
there should be), but it works for me.




Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of Bill Reed
Sent: Thursday, August 10, 2017 2:40 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: STRSQL

I prefer ACS, and find that if I can't remember names (which is most
of the
time), I'll just do a "select * from...." and the column names are
displayed
with the first data to come up (instead of the DDS defined COLHDG
text).
Perhaps it's because my files are all DDS defined, not DDL... I don't
know if
that makes a difference. So even though defined column headings are
normally preferable, the way this works out makes it handy.

Bill Reed


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of John R. Smith, Jr.
Sent: Thursday, August 10, 2017 3:30 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: STRSQL

I find I still use STRSQL because I never remember the field names and
I can't
prompt in ACS.

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf
Of Vernon Hamberg
Sent: Thursday, August 10, 2017 3:25 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: STRSQL

In addition, STRSQL does not support a lot of the new stuff in SQL,
anyhow.
For prompting, that is - things like WITH ___ AS are not promptable.

I cut my teeth on STRSQL starting 25 years ago (Yikes!). I still use
it
occasionally, there are options (F13) I'm more used to, but I'm
finding them
in ACS as well.

Cheers
Vern

On 8/10/2017 1:46 PM, Rob Berendt wrote:
I agree that Run SQL Scripts (from ACS)does not have the field
prompting which is nice. However, even for "quick and dirties" I
will
rather use Run SQL Scripts. I've found that the prompting does just
get in the way for all but the most basic queries.
Using prompting is a crutch. Many people will not step out of their
comfort zone on queries which go past prompting.

The ability to "Insert from examples", and to write your own, in ACS
is very nice.


Rob Berendt

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].