Right... I've got a program I'm doing some maintenance on. Urgh. Even describing it makes me shudder... Right, okay. Every night, a database running on what we think is SQL Server 2000 hooks up to an Informix database and copies it over into SQL Server. The Informix/SQL data is accessed by the program I'm maintaining, which then store...
I have a table (2 million rows) in Informix v11.10, replicated (50+ node) environment Basic layout is like so: ID (PK) (int) division (int) company (int) feature1 char(20) feature2 int ... feature 200 char(2) There are several issues I have with the current layout: There are 200 "features" associated with this record but may...
I want to change MULTISET column of the table, and my code looks something like this: PreparedStatement pstm = preparedStatement("UPDATE table SET mc = MULTISET{?, ?} WHERE ..."); pstm.setString(1, "..."); pstm.setString(2, "..."); pstm.execute(); And I get error: "Illegal attempt to convert a collection type into another type.". Wha...