Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Apr 2005 @ 13:23:51 GMT


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


Subj:   Re: Updatable cursors via CLI
 
From:   Geoffrey Rommel

  I am trying to use updatable cursors via CLIv2 library but I cannot find how to do it. Could anyone give me a clue?  


I can't answer your question, but this statement from the Database Design manual may be of interest: "Cursor updates must be performed within the same transaction as the SELECT statement that defined the cursor." So, if you're in Teradata mode, you will have to have BT ... ET around your select/update; if in ANSI mode, a COMMIT after all updates.



     
  <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: 23 Jun 2019