CODEWITHSUNDEEP
teradata
user3838835
user3838835

Reputation: 51

Teradata Row size Error

When I query Teradata for a specific table in bteq , I get the following error. How to query this table in BTEQ or any other TD SQL Client using JDBC or ODBC.

 *** Failure 9804 Response Row size or Constant Row size overflow.
                Statement# 1, Info =0 
 *** Total elapsed time was 1 second.

Upvotes: 3

Views: 9266

Answers (2)

dave
dave

Reputation: 306

My Teradata Studio already uses charset and I still get this error, so I have taken extra steps to look into the column length as a root cause of this issue.

After you reduce the column size, such as cast a large column size to Varchar(100), for instance, this error will go away.

Remedy: Change the SQL and/or reduce the data field sizes and/or number of fields being returned and resubmit the request. Limit the projection list and order by clause to approximately 64k bytes of data each.

Upvotes: 1

rogue-one
rogue-one

Reputation: 11577

The following should work. do this before .logon i.e. before establishing the session with TD.

.set session charset 'ascii';

For ODBC and JDBC clients the connection parameter called CHARSET should be used to resolve this issue.

Upvotes: 0

Related Questions