Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: SPL Cursor compilation fails in NT
From:   Michael Larkins

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.


Michael Larkins

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020