Path: utzoo!utgpu!water!watmath!clyde!rutgers!ukma!psuvm.bitnet!uh2
From: UH2@PSUVM.BITNET (Lee Sailer)
Newsgroups: comp.databases
Subject: Re: Informix query
Message-ID: <29074UH2@PSUVM>
Date: 7 Jan 88 19:48:06 GMT
References: <3890001@hpcmmb.HP.COM> <3216@ihlpf.ATT.COM> <2318@cup.portal.com> <67@coot.AUSTIN.LOCKHEED.COM>
Organization: Penn Sate Erie--School of Business
Lines: 25

In article <67@coot.AUSTIN.LOCKHEED.COM>, chris@AUSTIN.LOCKHEED.COM (Chris Wood) says:
>
>In article <2318@cup.portal.com>, truett@cup.portal.com writes:
>> 1.  Create a view comprised of the table to be processed with a column added to
>>     indicate if a row has been "processed".
>> 2.  Perform the processing on successively fetched rows from the view.  The
>>
>>      WHERE clause includes a condition that the "processed" column be NULL.
>
>>
>Please give me a sample of SQL syntax to perform the above, especially
>the second step.
>
>Thanks,
>Chris Wood
     
I think it would be helpful if you offer some context.  What kind of
transactions are you trying to model here?  Maybe your approach is wrong.
There is a general rule in declarative programming that if it is hard
to do, then you are likely taking the wrong approach.  But since we don't
know what you are trying to do, (only HOW you plan to accomplish it) we
cannot help.
     
            lee