|
|
Archives of the TeradataForum
Message Posted: Tue, 02 Sep 2003 @ 15:57:02 GMT
Subj: | | Re: Creating stored procedure.. |
|
From: | | Glen Blood |
I know of two methods.
1. Using Queryman (or I assume any ODBC connetion), you can simply replace the procedure. However, if there are any errors,
all I get back are "**********"
2. Using bteq with the .compile file= on Windows or UNIX (probably mainframe as well). There can be only one stored procedure
per file. Uset .set width 254 or you may not be able to read the message. This works pretty well.
Glen
| |