Teradata Response Row size or Constant Row size overflow error
Problem:
When we query Teradata for a specific table in bteq , we get the following error;
\n\n *** Failure 9804 Response Row size or Constant Row size overflow.\n Statement# 1, Info =0 \n *** Total elapsed time was 1 second.\n
Solution:
The following should work. do this before .logon
i.e. before establishing the session with TD.
.set session charset 'ascii';\n
\n\nFor ODBC and JDBC clients the connection parameter called CHARSET
should be used to resolve this issue
dan-irving
posted onEnjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment