Archives of the TeradataForum

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

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

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>>