Column name contain special character(/) !!!
Posted: Tue May 24, 2011 9:06 pm
Hi,
I have a SQL server database where my table contains columns name like
Byte_Received/sec ,Byte_sent/sec etc.... so while selecting these columns in query using ODBC Enterprise stage in datastage i have only selected either through select * from table or select \"Byte_Sent/sec" from table .... but due to this in column metadata i have written both of the option Byte_Sent/sec or Byte_Sent_sec but it fails the jobs and doesnt recognize the / character
Error Description:
main_program: Syntax error: Error in "export" operator: Error in operator arg: In field "Bytes_Total": Expected ";", got: "/", line 15
In field "Bytes_Received": Expected ";", got: "/", line 16
In field "Bytes_Sent": Expected ";", got: "/", line 17
In field "Packets": Expected ";", got: "/", line 18
Also possible things i have tried
1-Use ascii value of this character also
2-tried select * from table that not working
3-using escape charater also
4-use enable quoted identifier but that also not working.
5-I havent a plugin of SQL Server stage so that i will not tried yet.
If anyone facing similar kind of situation and get the solution plz share with us or have any possible solution throughwhich it get done plz share
I have a SQL server database where my table contains columns name like
Byte_Received/sec ,Byte_sent/sec etc.... so while selecting these columns in query using ODBC Enterprise stage in datastage i have only selected either through select * from table or select \"Byte_Sent/sec" from table .... but due to this in column metadata i have written both of the option Byte_Sent/sec or Byte_Sent_sec but it fails the jobs and doesnt recognize the / character
Error Description:
main_program: Syntax error: Error in "export" operator: Error in operator arg: In field "Bytes_Total": Expected ";", got: "/", line 15
In field "Bytes_Received": Expected ";", got: "/", line 16
In field "Bytes_Sent": Expected ";", got: "/", line 17
In field "Packets": Expected ";", got: "/", line 18
Also possible things i have tried
1-Use ascii value of this character also
2-tried select * from table that not working
3-using escape charater also
4-use enable quoted identifier but that also not working.
5-I havent a plugin of SQL Server stage so that i will not tried yet.
If anyone facing similar kind of situation and get the solution plz share with us or have any possible solution throughwhich it get done plz share