[Info-vax] VMS Software: New US Mailing Address

[Arne Vajhøj]

On 10/12/2022 5:33 PM, Arne Vajhøj wrote:
> On 10/12/2022 4:20 PM, Bill Gunshannon wrote:
>> Using a compatibility layer and trying to make PostGres look like
>> RDB (or Oracle) would be a major mistake. Better to bite the bullet
>> and move into the current century.
> 
> It is a tradeoff.
> 
> There are benefits from doing things the standard way instead of
> doing it the compatibility way.
> 
> But there are also huge cost of changing the client applications.
> 
>>                                  I have never used RDB (I have
>> used Oracle) but I assume it supports EXEC SQL and the usual SQL
>> syntax.  If so, moving could be fairly easy.  If not, could be a
>> problem.  Of course, probably also depends on the language being used.
> 
> It will indeed depend on the language and the API used.
> 
> embedded SQL/C => relative easy (PgSQL has precompiler)
> 
> embedded SQL/Cobol => maybe easy (an open source precompiler supposedly 
> exist and work)
> 
> embedded SQL/Pascal, Fortran ... => major rewrite (precompilers are not 
> available)

Also note that moving to the current century implies
moving from embedded SQL even if a precompiler is available.

Embedded SQL is a 80's & 90's technology.

Not what would be chosen if starting from scratch today.

Arne