Studio 16.20 Stored Procedure with commetns above error has returned

Teradata Studio
Enthusiast

Studio 16.20 Stored Procedure with commetns above error has returned

Hi Comments above the CREATE/REPLACE
2 REPLIES
Enthusiast

Re: Studio 16.20 Stored Procedure with commetns above error has returned

Hi

Previous post posted before complete :(

 

Comments above the CREATE/REPLACE PROCEDURE statement give the error:

 

   Executed as Single statement.  Failed [3706 : 42000] Syntax error: Invalid  SQL Statement.
   Elapsed time = 00:00:00.038 
    STATEMENT 1: Create Procedure failed.

 

This previously occurred in Studio 15.10, and was resolved in 16.00 from memory, however looks to have returned in 16.20.

I checked the patch server and there are no patches released after 16.20.00.00

 

Can anyone advise when this can be resolved.

 

Cheers

Steven

Teradata Employee

Re: Studio 16.20 Stored Procedure with commetns above error has returned

With Teradata JDBC Driver, you cannot specify a comment before the CREATE PROCEDURE keywords.

Instead, you can specify a comment elsewhere in the SQL request text after the CREATE PROCEDURE keywords.

The Teradata Database requires a CREATE PROCEDURE statement, or a REPLACE PROCEDURE statement, to be transmitted to the Teradata Database
using a different wire protocol than all other SQL requests.

Because of that Teradata Database limitation, the Teradata JDBC Driver must examine the SQL request text to determine
whether the SQL request is a CREATE PROCEDURE statement or a REPLACE PROCEDURE statement.

The Teradata JDBC Driver does not contain a SQL parser. Instead, the Teradata JDBC Driver simply examines the
first two keywords of the request text to determine whether the SQL request is a CREATE PROCEDURE statement or a REPLACE PROCEDURE statement.

If the SQL request text contains a comment before the CREATE PROCEDURE statement or REPLACE PROCEDURE statement,
then the Teradata JDBC Driver does not recognize the special statement, and the Teradata JDBC Driver transmits
the SQL request to the Teradata Database using the normal wire protocol instead of the special wire protocol,
and then the Teradata Database rejects the SQL request with the 3706 error.

In Studio 16.00, we are removing comments and submitting the SQL. But with IDE-17888 change ,we are submitting with comments.