I\'m using Sybase IQ and nee开发者_运维百科d to convert a field from string to NUMERIC. The field sometimes has characters other than digits. In those cases I want it to return 0 instead of raising ex
require \'rubygem开发者_开发百科s\' require \'jdbc/jtds\' require \'activerecord-jdbc-adapter\' config = {
i have the following code that queries a db and populates a datatable. private DataTable Run(string sql)
When i execute SQL \"LOAD TABLE ...USING CLIENT FILE...开发者_运维问答\" to Sybase IQ database in tomcat\'s apps,
I have one table (Table1) with some info and a string ID I have another table (Table2) with some more info and a similar string ID (it is missing an extra char in the middle).
Sybase BCP exports nicely 开发者_如何学运维but only includes the data. Is there a way to include column names in the output? AFAIK It\'s a very difficult to include column names in the bcp output.
I\'ve encountered a cryptic error message thrown by Sybase IQ server. com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -1001019: Function