Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!uwvax!mycella.cs.wisc.edu!lieuwen
From: lieuwen@mycella.cs.wisc.edu (Dan Lieuwen)
Newsgroups: comp.databases
Subject: I'm looking for embedded database/4gl/persistent PL code
Message-ID: <11687@spool.cs.wisc.edu>
Date: 9 Nov 90 14:31:24 GMT
References: <1990Oct25.081639.14155@abblund.se> <1990Nov1.144502.18208@pds3> <1990Nov5.191125.3008@wdl1.wdl.fac.com>
Sender: news@spool.cs.wisc.edu
Organization: U of Wisconsin CS Dept
Lines: 44

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).
I prefer code (fragments) as written so I can get some intuition as to what is
going on, but could even use it with global renaming of fields, tables,
etc...  At least then, I'd have some idea as to what goes on in real
code sequences, even if I can't determine what the code sequences do.

Do you have any embedded SQL (or some other embedded query language)
with "master-detail" layout? Basically, I'm looking for code with the 
following form:

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

Do you have any persistent PL code in a language with sets and code like:
      
    for X in Set1 {
      ...
      for Y in Set2 {
        ...
      }
      ...
    }

Either sort would be great.

The 4gl code that would be desirable is of two forms.
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 Lieuwen, Ph.D student University of Wisconsin-Madison
--
	
	--Dan