Mark,
We have and use Synon 2E, but without SQL option.
Database generation options
YDBFGEN Database implementation . . . : *DDS
YDBFACC Data access method . . . . . . : *DBFGEN
YFRFVNM Field reference file . . . . . : *NONE
YFRFPFX Field ref. prefix . . . . . . : $$
YFRFTXT Field reference file text . . :
ICOMSMDL - Field Reference File
YOLDDBS Use old DBF names . . . . . . : *YES
YSQLVNM SQL naming . . . . . . . . . . : *DDS
YSQLLEN SQL naming length . . . . . . : 10
YSQLLIB SQL collection library . . . . : *NONE
We are considering enabling the SQL option, but it requires the additional SQL collection library and will require significant changes with how we have our environments setup.
I'm not familiar with the RLA generator, is this something outside of the CA 2E product?
Thanks
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark Murphy/STAR BASE Consulting Inc.
Sent: Thursday, June 01, 2017 11:11 AM
To: Midrange Systems Technical Discussion
Subject: Re: Performance - RPG vs Cobol
The SQL generator for Synon2E wasn't quite as good as the RLA generator when I used it. I don't know if that is still the case or not.
Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx
-----Nathan Andelin <nandelin@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Nathan Andelin <nandelin@xxxxxxxxx>
Date: 05/31/2017 05:10PM
Subject: Re: Performance - RPG vs Cobol
It could use SQL, it could use RLA, depends on how you configure the
model. I have only used RLA.
Not to prejudice one over the other, but would you mind explaining your
rationale for using RLA instead of SQL?
midrange.com
