Hi, this is so silly... I've not done this in a while and must be making a very basic but not obvious mistake. I've written a stored procedure. I do understand that it has to be compiled to make it executable but my recollection is that simply CREATEing the procedure will do the syntax checks for me. I'm trying to store my procedure but continue to get the error message - "Failure 3706 Syntax error: Invalid SQL Statement." I've looked this up but apparently 3706 is a "catch-all" so that didn't help either.
Trying to isolate the error, I've dumbed it down to the most basic syntax but the error remains.
I'm hoping somebody can help me recall how to do this.
I hope you would have connected to database before creating the procedure. If so, place the definition in Teradata SQL Assistant and Press F5. It will check the syntax. REPLACE PROCEDURE TEST() BEGIN END;