IBM Support

GET DATA fails with error "Optional Feature Not Implemented"

Technote (troubleshooting)


Customer is trying to GET DATA TYPE ODBC from his Oracle database using the last IBM SPSS OEM 7.1 drivers but it is failing with the following error:

Warning. Command name: GET DATA
SQLExecDirect failed :[IBM SPSS][ODBC Oracle Wire Protocol driver]Optional feature not implemented.

Resolving the problem

In the select statement, you are importing some variables of TYPE NVARCHAR2.

Checking the "Enable N-CHAR Support" option in the advanced tab of the ODBC configuration solved the issue:

Windows Startup > Administrative tools > Data Source ODBC > Select the right DSN and click on Configure > Advanced Tab

Related information

Need more help? Our Statistics forum is Live!

Document information

More support for: SPSS Statistics

Software version: 21.0, 22.0

Operating system(s): Windows

Reference #: 1653237

Modified date: 07 September 2016

Translate this page: