IBM Support

37000[1018] [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.=

Troubleshooting


Problem

I am running a Clementine Server using Clementine 12.0.2 or above using the SQL Server Wire Protocol Driver on a UNIX platform. When I run a stream that creates a table and inserts data into it, where one of my columns is called "Index" I get the following error: 37000[1018] [DataDirect][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Index'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.= Why is this?

Resolving The Problem

By default the SPSS OEM SQL Server Wire Protocol Driver will not quote table and column names. To enable this in the SPSS OEM SQL Server Wire Protocol ODBC driver, change the "QuotedId=No" parameter in the DSN definition in the odbc.ini to "QuotedId=Yes", then save the odbc.ini and reconnect from Clementine. The table and column names in the create table statement should then be quoted and you should not see this eror on table creation

[{"Product":{"code":"SS3RA7","label":"IBM SPSS Modeler"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Modeler","Platform":[{"code":"PF033","label":"Windows"}],"Version":"13.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Historical Number

79530

Document Information

Modified date:
16 June 2018

UID

swg21482091

Page Feedback