Re: RLA & SQL was (Re: SQL database object names longer than 10charactersand mixedcase?)

Actually Vern, I can think of times to combine the two.  Reading data from
one system and posting it to your local.  Might you be able to do this
with DDM files?  Perhaps.  But, using an SQL CONNECT TO and processing
that cursor to post to your local data with RLA is certainly an
alternative.

But perhaps you are one of those "If you are using a cursor, you are doing
SQL wrong" camp.


Rob Berendt
--
Group Dekko
Dept 1600
Mail to:  2505 Dekko Drive
         Garrett, IN 46738
Ship to:  Dock 108
         6928N 400E
         Kendallville, IN 46755
http://www.dekko.com





From:   Vern Hamberg <vhamberg@xxxxxxxxxxx>
To:     Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date:   11/01/2010 01:50 PM
Subject:        Re: RLA & SQL was (Re: SQL database object names longer
than    10charactersand mixedcase?)
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



Comment below

On 11/1/2010 11:00 AM, dieter.bender@xxxxxxxxxxxx wrote:

... shudder

Almost everything here is incorrect.  You do not loose positioned

updates

when using RLA, everything is positioned.  You loose set based

operations.

using SQL for data retrieving and writing with RLA you would have to
reposition and so loose direct positioned update (update... where

current

of...)

What you suggest here is something I would never even consider -
retrieve with SQL and update with RLA? That's crazy! Of course you have
no positioning - that's what RLA does for you.

If I work with a table with SQL, I don't think I will EVER have an
F-spec for it - utterly wrong.

Now if this is what you mean when you talk of using only one of the
technologies, I have to agree. In each local situation, do NOT combine
the 2. Use one or the other.

But that does not say, never use RLA anywhere! Sometimes that is the
tool to use, sometimes SQL is. Just don't mix them over the same file or
table or logicals or views or indexes thereof.

So I think you bring up a practice that no sane person would take up -
and none of Joe's posts suggest this practice, of using one technology
for reading and the other for writing or updating - to that I also
shudder. But it is a straw man - no one is saying to do that.

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


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