sap-iq
Sybase IQ: Converting a string to NUMERIC without error/exception
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[详细]
2023-04-06 21:24 分类:问答attempting to connect to sybase but resolving to mssql adapter
require \'rubygem开发者_开发百科s\' require \'jdbc/jtds\' require \'activerecord-jdbc-adapter\' config = {[详细]
2023-04-03 12:55 分类:问答is there any faster way to populate a resultset from a database query?
i have the following code that queries a db and populates a datatable. private DataTable Run(string sql)[详细]
2023-03-19 05:54 分类:问答Operation failed on file due to file permissions,hos_clientfileio.cxx 142
When i execute SQL \"LOAD TABLE ...USING CLIENT FILE...开发者_运维问答\" to Sybase IQ database in tomcat\'s apps,[详细]
2023-02-22 20:35 分类:问答Why is this Sybase IQ Update Statment So Slow?
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).[详细]
2023-02-18 18:55 分类:问答Sybase BCP - include Column header
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.[详细]
2023-02-11 12:24 分类:问答Length of Bind host variable exceeds MaxLength
I\'ve encountered a cryptic error message thrown by Sybase IQ server. com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -1001019: Function[详细]
2022-12-23 20:58 分类:问答