IBM Support

DataStage Job fails with Error message UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

Troubleshooting


Problem

A DataStage job that accesses SQL Server using ODBC receives error: [IBM (DataDirect OEM) ][ODBC SQL Server Driver][SQL Server]UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct

Symptom

A DataStage job that accesses SQL Server using ODBC receives error

[IBM (DataDirect OEM) ][ODBC SQL Server Driver][SQL Server]UPDATE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct

Cause

When the configuration was made for the ODBC database connection, one of the following options was not set:
Windows: Enabled Quoted Identifiers
Unix: QuotedId

Resolving The Problem

Windows:

Edit the ODBC database configuration through the Administrative Tools, ODBC Data Sources

check Enabled Quoted Identifiers

Unix:

Determine the location of the .odbc.ini by examining the Environment Variable Settings Log entry in the DataStage job log. Look for System Variable ODBCINI

Edit the .odbc.ini and set QuotedId=Yes

example:

[DsodbcM]


Driver=#BRANDED_ODBC_DIR#/lib/VMmsss24.so
Description=DataDirect 6.0 SQL Server Wire Protocol
Address=193.128.90.32,1433
AnsiNPW=Yes
Database=Dsodbc
LogonID=dsqa
Password=dsqa
QuotedId=Yes

[{"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"8.7;8.5;8.1;8.0.1;7.5.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21587480

Page Feedback