Re: SQL statements for physical and logical files

On 2/14/2017 3:39 PM, Rob Berendt wrote:

But it is perfectly acceptable to access a DDS table with SQL and it is
perfectly acceptable to access a DDL table with RLA. And, it is

perfectly

acceptable to access many DDL indexes with RLA.

First: I do all of these things now. But why? Because I'm
transitional. I don't have the new stuff fully up and I don't have the
old stuff fully replaced. So it's... expedient to pop in an F-spec in
order to grab one row here and there.

But.

That's A Bad Thing.

By using an F-spec, and unit record I/O, I am once again locking myself
away from the ability to do ALTER TABLE at will. Argh! I'm not going
to do that any more. For me, from now on, it's SQL access for
DDL-defined tables. If I really need to access a DDL-defined table from
RLA I'm going to write a sub-procedure instead of an F-spec. And that
sub-procedure is going to use SQL.

--
--buck

Try wiki.midrange.com!

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