DSXchange

Hi,

while iam loading data into SQL server table using ODBC connector,getting below error message, my columname FUNCTION, its reserved sql name so getting the below one,please suggest how to handle this


ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 156: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Incorrect syntax near the keyword 'FUNCTION'.
ODBC function "SQLExecute" reported: SQLSTATE = 42000: Native Error Code = 8180: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]Statement(s) could not be prepared. (CC_OdbcDBStatement::executeInsert, file CC_OdbcDBStatement.cpp, line 829)

Enable use of quoted identifiers and wrap FUNCTION in double-quote characters.

Thanks ray