IBM Support

SQLExecDirect failed :[520][ODBC 20101 driver][UDB DB2 for Windows, UNIX, and Linux]1402

Troubleshooting


Problem

I'm using IBM SPSS Statistics to access a DB2 database and am attempting to query a particular table using a Data Source built with the DataDirect DB2 Wire Protocol driver. I can see the table in the list in the Database Wizard, select it, and continue on through the Wizard, but when I try to execute the GET DATA command I receive the following error: Warning. Command name: GET DATA SQLExecDirect failed :[520][ODBC 20101 driver][UDB DB2 for Windows, UNIX, and Linux]1402 [520][ODBC 20101 driver][UDB DB2 for Windows, UNIX, and Linux]1489

[{"Product":{"code":"SSLVMB","label":"IBM SPSS Statistics"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF033","label":"Windows"}],"Version":"18.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

90872

Document Information

Modified date:
16 April 2020

UID

swg21487523