IBM Support

Information Server DataStage ODBC fails updating AS400 with arrays

Question & Answer


Question

DSD.BCIPut call to function SQLExecute failed. SQL statement:UPDATE <

> SET <> = ? WHERE (<> = ?) SQLSTATE=S1C00, DBMS.CODE=30058 [DataStage][SQL Client][ODBC][IBM][System i Access ODBC Driver]Driver not capable.

Cause

This is an issue of the ODBC AS400 driver from System i Access.
This occurs when the array size is greater than one row.

Answer

Check the following APAR :

http://www-01.ibm.com/support/docview.wss?uid=nas2SE20631

SE20631 - CA400EXP-ODBC-INCORROUT BLOCK UPDATE FAILS WITH NO MESSAGE

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.1;8.5;8.7;9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21675848