Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 10 Feb 2008 @ 22:40:42 GMT


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


Subj:   Re: How to write procedure in teradata
 
From:   McCall, Glenn David

  how to write procedure in teradata..and how to write the print statement i.e in oracle it is dbms_output.put_line(...);  


There isn't an equivalent to print. What most people do is create a table and insert the messages into the table. To ensure they are sorted correctly you should put a timestamp in the table.

Example:

     Create table sp_log (
          Ts timestamp(6) default current_timestamp;
          Msg varchar(200)
     )

  what is in Teradata i've tried with *DBC.SysExecSQL(..);*  


Try:

     exec DBC.sysexecsql ("some sql");

Hope this helps

Glenn Mc



     
  <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: 27 Dec 2016