Re: parameterised SQL views

From: Bob Badour <bbadour_at_golden.net>
Date: Sat, 21 Oct 2000 23:07:54 -0400
Message-ID: <8stlrv$cr$1_at_cougar.golden.net>

Hi Paul,

Some databases will allow one to store an SQL command in the database. SqlBase does this. I believe that DB/2 does this as well.

These are different from stored procedures because they are straight SQL.

As far as knowing whether a table or view is still in use for configuration management, doesn't putting queries in stored procedures just create the same problem "one step removed" ? How does one know whether anything still uses the stored procedure?

Stored procedures are very non-portable. Each is essentially a database specific, proprietary programming language. Tables and views are much more portable -- even with the dialect differences among SQL implementations. Using stored procedures defeats the whole purpose of using an "open system" language like SQL.

Regards,
Bob Received on Sun Oct 22 2000 - 05:07:54 CEST

This message: [ Message body ]
Next message: Bob Badour: "Re: Normalization and N-ary relations"
Previous message: Bob Badour: "Re: parameterised SQL views"
Maybe in reply to: Paul Singleton: "parameterised SQL views"
Next in thread: Bob Badour: "Re: Normalization and N-ary relations"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message