Archives of the TeradataForum

Message Posted: Wed, 06 Nov 2002 @ 12:10:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

What do you mean by a record set - recordset from a programming language perspective or are you looking for something where in you could loop through the result of a query performing some data manipulation on every row that you retrieve from the result set - if it is this then you could make use of the cursors.

i.e for < cursorname > as < alias > for
        query
    do
       < Your business logic here to manipulate each row
         from the query result set>
    end for;

Narayan.

	<Prev	Next>		<<First	<Prev	Next>	Last>>