Teradata procedure creation || Aquadata studio

Tools
Enthusiast

Teradata procedure creation || Aquadata studio

Hi all,

I am using Aquadata studio and was trying to create Procedure and everytime it can not compile and gives error. While that works with "Teradata Studio Express" does any one know or faced similar issues and potential fix? Any help will be greatly appreciated.

Regards,

Chandan

4 REPLIES
Teradata Employee

Re: Teradata procedure creation || Aquadata studio

What kind of stored procedure are you trying to create? SQL stored procedure, Java external stored procedure, C external stored procedure?

What is the complete error that you are getting?

Enthusiast

Re: Teradata procedure creation || Aquadata studio

I am trying to create SQL stored procedure.

Enthusiast

Re: Teradata procedure creation || Aquadata studio

CREATE PROCEDURE db.CP_test()

BEGIN

    DECLARE lt_prcs_start_tm Integer;

    Sel 10 Into :lt_prcs_start_tm;

END;


>[Error] Script lines: 173-175 ----------------------

 [Teradata Database] [TeraJDBC 14.10.00.17] [Error 5526] [SQLState HY000] Stored Procedure is not created/replaced due to error(s).

 

 More exceptions ... [Teradata Database] [TeraJDBC 14.10.00.17] [Error 5526] [SQLState HY000] SPL1027:E(L3), Missing/Invalid SQL statement'E(3706):Syntax error: expected something between ';' and the end of the request.'.

 

 [Executed: 4/27/2016 10:52:41 AM] [Execution: 0ms] 

 

>[Error] Script lines: 176-176 ----------------------

 [Teradata Database] [TeraJDBC 14.10.00.17] [Error 3706] [SQLState 42000] Syntax error: INTO clause is not allowed.

 

 [Executed: 4/27/2016 10:52:41 AM] [Execution: 0ms] 

 

>[Error] Script lines: 177-177 ----------------------

 [Teradata Database] [TeraJDBC 14.10.00.17] [Error 3707] [SQLState 42000] Syntax error, expected something like a name or a Unicode delimited identifier or a 'TRANSACTION' keyword or a 'FASTEXPORT' keyword or a 'LOADING' keyword between the 'END' keyword and ';'.

 

 [Executed: 4/27/2016 10:52:41 AM] [Execution: 0ms] 


Senior Apprentice

Re: Teradata procedure creation || Aquadata studio

There must be a way in Aquadata Studio to submit the CREATE as a single request, currently it splits it into three seperate requests.