I connect to Teradata using ODBC and I would like to create very simple stored procedure. When I call SQLPrepare I receive error "[Teradata][ODBC Teradata Driver][Teradata Database] Syntax error: Invalid SQL Statement.", but when I call the same CREATE PROCEDURE... statement using SQLExecDirect then it works. It also works using SQL Assistant with .NET Provider. I tried using ODBC driver 12 and 13.
Is it normal that SQLPrepare doesn't work with CREATE PROCEDURE and SPL?