Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: How to convert oracle pl/sql to teradata code
 
From:   Aldrin, John

(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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023