Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 16 Jan 2002 @ 11:15:47 GMT


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


Subj:   Re: Arrays in Stored Procedures
 
From:   Mat Ginman

Hi,

  How to use arrays in Stored procedures?  


You cannot used arrays in stored procedures. Instead you could use a temporary table.


  How to direct query result into a txt file with in the stored procedure?  


You can not. You could write rows to a table instead.


  Where should i see the output of debug statement "print" present in stored procedure? If I execute the stored procedure from queryman can I see the output of debug statement?  


The "print" goes to the DBWindow only, a program you can start at the server.

Note that if you plan to use stored procedure for massive data operations use the stored procedures as shell layer only and do the actual operations inside SQL statements to take advantage of the paralellism of Teradata. E.g cursors should not be used.


Mats



     
  <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