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