datastage错误之 ODBC_Connector_0: ODBC Info: SQLSTATE = 42000: Native Error Code = 7,405:

 

 

报错信息 

ODBC_Connector_0: ODBC Info:  SQLSTATE = 42000: Native Error Code = 7,405: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]异类查询要求为连接设置 ANSI_NULLS 和 ANSI_WARNINGS 选项。这将确保查询语义一致。请启用这些选项，然后重新发出查询。

修改方式:

修改 .odbc.ini 文件中 AnsiNPW的值为YES

 

[TEST]
Driver=/ds/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so 
Description=DataDirect SQL Server Wire Protocol driver
Database=***
LogonID=***
Password=***
Address=***
QuotedId=No
AnsiNPW=YES