Declaring variables in TERADATA BTEQs

Tools

Declaring variables in TERADATA BTEQs

Hi all,

I want to know if there is any provision in TERADATA BTEQ scripts to use variables, just as we use the variables in SQL SERVER stored procedures.

If not then tell me an alternative....

thanx
2 REPLIES
Enthusiast

Re: Declaring variables in TERADATA BTEQs

You can define variables inside a Teradata's Stored Procedure, just like SQL Server's Stored Procedures.
BTEQ is not a Stored Procedure, is a tool to submit SQL statements (e.g.: "call MyStoredProcedure();")...
Enthusiast

Re: Declaring variables in TERADATA BTEQs

Normally in unix client platforms, a combination of shell variables and HERE documents are used to accomplish this.

I am not sure if other platforms have something similar.