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.


Regards,

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: 15 Jun 2023