Re: Help solve an argument: Reading a SQL index in RPG?

[Buck Calabro <kc2hiz@xxxxxxxxx>]

On 2/22/2016 9:33 AM, Rob Michaels wrote:

> We are in the process of modernizing our code base ... part of which
> involves incrementally converting our database from DDS to SQL.  We
> haven't gotten around to changing our database access to SQL yet, so
> we're reading the SQL objects using native RPG methods (read, chain,
> setll, etc.).
>
> One of my co-workers insists on using the SQL indexes we've built as
> if they are tables and reading them directly.

When you write 'converting our database from DDS to SQL' do you mean:
1) Mechanical column by column exact recreation of the DDS using DDL
2) Redesigning the database from the ground up to use normalised tables