How to create a stored procedure in Teradata

Database
Enthusiast

How to create a stored procedure in Teradata

Hi,

I am quite new to Teradata utlities. I would like to know how I can create the stored procedure. I need step-by-step. For example, i tried to create the file (say test.spl and write my procedure there). My understandning is after that I need to compile that file. Where should I put my stored procedure file (test.spl)? Can I store under my local drive or it must be in server?

Thnx in advance,
JMM

1 REPLY
Teradata Employee

Re: How to create a stored procedure in Teradata

I assume you have access to BTEQ.

Here are the steps in BTEQ:
1- Logon to Teradata
2- Type ".HELP BTEQ" without the double quotes in BTEQ; the COMPILE command is at the very top.
3- Use COMPILE command: for example ".COMPILE FILE=MyStoredProcedure.SQL"
4- For additional information refer to BTEQ manual. You can download it from www.info.teradata.com.