Xref: utzoo comp.sys.sgi:7185 comp.databases:8082
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!rutgers!uwvax!mycella.cs.wisc.edu!lieuwen
From: lieuwen@mycella.cs.wisc.edu (Dan Lieuwen)
Newsgroups: comp.sys.sgi,comp.databases
Subject: Looking for code for my Ph.D thesis
Message-ID: <1990Dec6.203007.2011@spool.cs.wisc.edu>
Date: 6 Dec 90 20:30:07 GMT
References: <11762@spool.cs.wisc.edu> <1990Dec3.032935.19235@oracle.com>
Sender: news@spool.cs.wisc.edu (The News)
Organization: U of Wisconsin CS Dept
Lines: 40


I'm a Ph.D student with Dr. DeWitt of the University of Wisconsin-Madison.
I'm looking for some code of a particular style.  You can modify it
so I can't tell what it does and still have it be useful to me though
not as useful.  Being able to see the form of the code is useful in and
of itself.  Being able to understand it helps, but isn't essential.

Do you have any embedded SQL with "master-detail" layout?
Basically, I'm looking for code with the following form:

   loop while cursor1 not empty {
        ...
        loop while cursor2 not empty {
        ...
        }
        ...
   }

If I could take a look at it, I would be most appreciative.
I'm working on optimizing such code as part of my current research,
and would like to see if the ideas I've come up with work on any real
code (ie anything other than the code I cook up by hand in examples).


In addition to nested cursors, I would love to get my hands on code that
has a call from within a cursor to a procedure that contains a query.

Also very desirable are procedures containing queries that call other
procedures containing queries.

Thanks for your help.

Dan
-- 
	
--Dan Lieuwen--
When people talk of "separation of church and state", they often merely
mean that those they disagree with should keep their values out of politics.
However, no one believes that they themselves should keep their own values
out of politics.


Brought to you by Super Global Mega Corp .com