SQL Selection Set Questions

From: Gordon E. Hooker <gordonh_at_thehub.com.au>
Date: 1996/12/30
Message-ID: <32c7cef9.726218_at_news.thehub.com.au>#1/1


WebMaster_at_HyperNetUSA.com (Larry W. Berman) wrote:

Using cursors is covered fully in the Informix Documentation

>After performing a SQL select on a table, I need to then know how to work
>with the selection set to:
>
>1. Step through each record (row)
>2. Retrieve the value for a specific field in each row
>3. Set the value of a specific field in each row
>4. Run another SQL select with an "order by" parameter against the first
>selection set to create a new sorted set.
>
>Thanks for your help.
>
>Larry Berman

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP
25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555
Email gordonh_at_thehub.com.au
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year

Pink Floyd Received on Mon Dec 30 1996 - 00:00:00 CET

Original text of this message