Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 02 Sep 2003 @ 15:57:02 GMT


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


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



     
  <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