[Info-vax] CRTL and RMS vs SSIO

[chris]

On 10/14/21 01:46, Lawrence D’Oliveiro wrote:
> On Thursday, October 14, 2021 at 9:44:56 AM UTC+13, Dave Froble wrote:
>
>> A simple loop processing an RMS file looking in each record in the field
>> Name for "Dave" can be an open and a couple lines of code.
>>
>> Not such a big difference.
>
> Even on a single table, SQL allows for ORDER BY clauses so the records get returned in an order more suited to the application’s needs. And the ordering can be an expression, not necessary a simple field. Try doing that in RMS.
>
> But beyond that, SQL allows lookups using JOINs on multiple tables, plus of course subqueries -- try implementing that in RMS!

I come here to bury Caesar, not to praise him :-) ?. RMS is a Record
Management System, not a database, not the same thing at all. As a
foundation, or set of system services, yes, but not the complete
product.

Comparing Apples to Oranges is rarely productive...

Chris