Path: utzoo!mnetor!uunet!husc6!ut-sally!ut-emx!lad-shrike!chris
From: chris@AUSTIN.LOCKHEED.COM (Chris Wood)
Newsgroups: comp.databases
Subject: Re: Informix query
Message-ID: <67@coot.AUSTIN.LOCKHEED.COM>
Date: 6 Jan 88 23:00:56 GMT
References: <3072@ihlpf.ATT.COM> <3890001@hpcmmb.HP.COM> <3216@ihlpf.ATT.COM> <2318@cup.portal.com>
Organization: Lockheed Austin Div.
Lines: 13
Summary: step 2

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