Archives of the TeradataForum

Message Posted: Fri, 27 Apr 2001 @ 16:10:20 GMT

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

Hi Mats:

I am not sure what you mean by "refers to more than one local variable." But, the cursor should only be used to qualify the name of a column named in the SELECT.

You should be able to do something like the following within your FOR / END FOR loop that defines the cursor:

/* MyCursor_name established in the FOR statement */
SET LOCAL_VAR1 = MyCursor_name.column_name1;
set LOCAL_VAR2 = MyCursor_name.column_name2;

as well as:

INSERT into my_other_table values (Mycursor.column_name2, Mycursor.column_name1);

I hope this helps. Otherwise, you might want to post that portion of your procedure.

Regards,

Michael Larkins

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