Question & Answer
Question
What should I do if I receive the following error? The error returned with CDA is: java.sql.SQLException: The SQLDA is too small. The error returned with DataStage is: main_program: [WS Classic][ODBC/CLI Driver][Data Server] SQLPrepare - Error code: x000B0024. The SQLDA is too small. SQLEXT(x000229fc, x002a03a4)
Cause
It appears that the FETCHBUFFERSIZE in JDBC isn't big enough to handle the request.
Answer
Add the FETCHBUFFERSIZE to the connection URL following the steps below.
1. First. select EDIT CONNECTION
2. Then add to the following to the end of Connection URL
:FETCHBUFFERSIZE=1000000
and click FINISH.
NOTE: Now, Classic is capped at a 5000 column definition, so check to see how many columns there are. With such a large definition, there may be other downstream issues as the server configuration. You may need to increase MESSAGEPOOLSIZE, along with other sizes to allow this to work.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21606281