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.


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

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


     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: 28 Jun 2020