Re: Fitzle

[furgalj@xxxxxxxxxxxxxxxx]

Joe asked:

>P.S. Jeff, I'd be interested to see how SQL is non-procedural.  I'm not
>doubting you, I'm just intrigued.  I have to believe that hybrids like
>embedded SQL are certainly procedural.  How is "pure" SQL
>non-procedural?

My understanding of this classification makes it pretty simple. SQL 
specifies "what" not "how". To elaborate, in SQL you make no attempt to 
tell the system how to achieve the results you want. You simply specify a 
relational predicate. The DBMS pulls together the tables and views needed 
and figures out how best to run the query. The real clue is that there are 
no looping constructs (at least not in plain old SQL '92, or whatever).

In a procedural language you are able to control, or at least influence, 
the sequence of execution of the code.

_________________________________________________________________
Jeff Furgal / MIMIX User Interface Product Architect / Lakeview Technology

furgalj@xxxxxxxxxxxxxxxx / 630-282-8360

LAKEVIEW TECHNOLOGY CONFIDENTIAL

This e-mail may contain SECRET, PRIVILEGED AND/OR CONFIDENTIAL INFORMATION 
intended only for the use of the addressee.  If you are not the addressee, 
or the person responsible for delivering it to the person addressed, you 
may not copy or deliver this to anyone else.  If you received this e-mail 
in error, please immediately notify Lakeview by returning the original 
message to the sender via e-mail.