Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 19:31:00 GMT

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

(1) Treat the nested cursor as the right handed table in a left outer join to the main cursor.

(2) You do your join using the columns that are normally passed as parameters in the nested query.

(3) You can determine the presence/absence of nested data by determining if a NOT NULL column is being returned as a NULL, you can use case logic to provide the data your "NOT FOUND" exception would have generated.

John....

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