Archives of the TeradataForum
Message Posted: Sun, 10 Feb 2008 @ 22:40:42 GMT
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
|