Loading into sql server table column issue

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
VIDHATHA
Participant
Posts: 11
Joined: Fri Aug 24, 2012 1:57 am

Loading into sql server table column issue

Post by VIDHATHA »

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)
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Enable use of quoted identifiers and wrap FUNCTION in double-quote characters.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
VIDHATHA
Participant
Posts: 11
Joined: Fri Aug 24, 2012 1:57 am

Post by VIDHATHA »

Thanks ray
Post Reply