PM71226: Extracting data from DB2 and saving as a CSV file fails with ERRORCODE=-4476
A fix is available
Closed as program error.
Abstract: Attempts to extract data from DB2 and save as CSV fails with ERRORCODE=-4476 when using IBM Rational Application Developer v8.5. Problem: When connecting to DB2 10.1 database (default SAMPLE database) from data perspective, and right click one of the table ? Data ? Extract ? save as csv, it will fail with error below. If connecting to same database from Rational Application Developer v8.0.4 and follow the same steps, the error doesn't occur and the data is saved as CSV as expected. !ENTRY org.eclipse.datatools.sqltools.data.core 4 0 2012-07-12 11:33:41.803 !MESSAGE [jcc][4.8.86] Method executeQuery cannot be used for update. ERRORCODE=-4476, SQLSTATE=null !STACK 0 com.ibm.db2.jcc.am.SqlException: [jcc][4.8.86] Method executeQuery cannot be used for update. ERRORCODE=-4476, SQLSTATE=null Local fix: There is no known workaround at this time
After connecting to a DB2 database in the Data Source Explorer. Right Click on the table > Data > Extract > Save as csv. This action will fail with "Method executeQuery cannot be used for update. ERRORCODE=-4476"
In some cases the query used to read the table text from the catalog is not generated properly causing the query to fail. The fix for this APAR is included in Rational Application Developer v8.5.1.
Reported component name
RATL APP DEV WI
Reported component ID
Last modified date
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fixed component name
RATL APP DEV WI
Fixed component ID
Applicable component levels