Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

Views don't have index, read can not predict the order, but indexes can be created with all or some fields from the table, and some rows can be selected in the index. Almost like a view.


On 01/17/2017 11:00 AM, Justin Taylor wrote:

READxx? But views have no key.

-----Original Message-----
From: Nathan Andelin [mailto:nandelin@xxxxxxxxx]
Sent: Monday, January 16, 2017 11:01 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Road Map to move a home grown application from RPG to DB2 SQL or to any other data base platform

Views can't be accessed by RLA and indexes are limited with their
definitions.

RPG "F" specs and READxx opcodes CAN reference SQL Views... No problem. For some reason I just had a deja-vu moment - like I answered this question once before.

My recommendation is: first change your access method from RLA to SQL -

it's rather easy.

My recommendation is to use SQL for use cases that call for "sets" (i.e.
dynamic queries), and use RLA for when you need to insert, update, delete, find, and check the existence of just one record.

if you introduce a functional data access layer. Then you have all
prerequisites to switch your data definition from DDS to SQL DDL and
redesign your database, without any harm fro your applications.

I'd suggest that functional data access layers can provide wrappers around RLA in addition to SQL.

-- Este e-mail fue enviado desde el Mail Server del diario ABC Color -- -- Verificado por Anti-Virus Corporativo Symantec --