Error 3738 String is longer than 31000 characters

Database
Enthusiast

Error 3738 String is longer than 31000 characters

Hi,
I am trying to insert a string of length approx 32000 into a table with the definition as shown below:

Request Text
CREATE SET TABLE file_storage ,FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
version_id DECIMAL(10,2),
file_data VARCHAR(60000) CHARACTER SET LATIN NOT CASESPECIFIC)
PRIMARY INDEX ( version_id );

This is giving me the following error:
Failure 3738: String is longer than 31000 characters.

If the field 'file_data' is defined with length 60000 then why is this failing?
Thanks.
3 REPLIES
Teradata Employee

Re: Error 3738 String is longer than 31000 characters

Teradata Database Messages manual states:

Explanation: Quoted strings cannot be longer than 31000 physical characters.
Notes: To insert longer strings, the user must have a USING clause and a DATA parcel that contain the characters.

Are you using a Character Literal (e.g. Insert into file_storage(1.0, 'xyz')) to insert the data?
Enthusiast

Re: Error 3738 String is longer than 31000 characters

Hi

It depends on the version of Teradata you are using.
May be yours support only maximum of 32000 characters..

Cheers:-)
Enthusiast

Re: Error 3738 String is longer than 31000 characters

Can anyone please suggest me also solution of this problem..