Unable to create array type UDT in Teradata SQL assistant 13.10

Database
Enthusiast

Unable to create array type UDT in Teradata SQL assistant 13.10

I am trying to create an UDT array variable using the syntax as suggested in the forum before

https://developer.teradata.com/database/reference/array-data-type-scenario

I am getting the error below :

CREATE TYPE FAILED. [3706] Syntax error.Expecting FINAL keyword.

I tried giving the FINAL keyword but still it getting the error.It is something related to the version?

 

I am using Teradata Sql assitant 13.10 although I am able to create the below  UDT fine:

CREATE TYPE dollar
AS DECIMAL(8,2)
FINAL;

 

 

Any assistance would be helpful.

Regards,

Indranil Roy

 

 

2 REPLIES
Teradata Employee

Re: Unable to create array type UDT in Teradata SQL assistant 13.10

What version of Teradata database? ARRAY was introduced in TD14.0.

Enthusiast

Re: Unable to create array type UDT in Teradata SQL assistant 13.10

Hi @Fred
We are using sql assistant 13.10 Is there a way to implement array in teradata 13.10