Path: utzoo!attcan!uunet!lll-winken!lll-tis!ames!amdahl!rtech!llama!wong
From: wong@llama.rtech.UUCP (J. Wong)
Newsgroups: comp.databases
Subject: Re: INGRES/EQC and SQL/C ...and general notes...
Message-ID: <2400@rtech.rtech.com>
Date: 25 Aug 88 18:35:37 GMT
References: <24546@bu-cs.BU.EDU>
Sender: news@rtech.rtech.com
Reply-To: wong@llama.UUCP (J. Wong)
Organization: Relational Technology, Inc. Alameda, CA
Lines: 22

In article <24546@bu-cs.BU.EDU> berlin@buita.bu.edu (David Fickes- Einstein Project) writes:
>
>One other question. What's so hard about supporting NESTED EQUEL
>statements in the EQUEL/C processor???  I've got some code that looks like 
>this:
>
>## ingres "einstein"
>## range of d is dukasfin3
>## retrieve (c_uid=d.uid) where d.date=" " and
>##      squeeze(d.doc_date)="00/00/??";
>##{
>##      retrieve (c_year=right(squeeze(d.doc_date),2)) where d.uid=c_uid;
>##      replace d(date=date(01/01/c_year)) where d.uid=c_uid;
>##}
>

Actually, this can be written as a single QUEL REPLACE statement!

##	replace d (date = date("01/01/"+right(squeeze(d.doc_date),2)))
##		where d.date=" " and squeeze(d.doc_date)="00/00/??";
J. Wong		wong@rtech.com
****************************************************************
S-s-s-ay!