Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 15 Sep 2004 @ 16:27:48 GMT


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


Subj:   Re: Create Stored Procedure from inside a BTEQ Script
 
From:   Judge, James A

check out the BTEQ reference manual for the COMPILE command, but here is the essentials:

The following rules apply:

1 You must log on to the Teradata RDBMS before executing this command.

2 The source text for a stored procedure must be written in an input file. You cannot issue the CREATE/REPLACE PROCEDURE SQL statement at the BTEQ prompt.

3 One file can contain source text for only one stored procedure. It cannot contain any other BTEQ commands.

4 The COMPILE command must be the last statement in an open transaction. If there are no compilation errors, then the entire stored procedure source text is stored in the specified database. It can be retrieved later using the SHOW PROCEDURE SQL statement.



     
  <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