informix
How can I conditionally construct a table name for an SQL CREATE TABLE statement?
Within an SQL stored procedure, I would like to have the ability to construct a table name and create it.[详细]
2023-01-24 03:18 分类:问答Access 2010 Inside Out
I recently acquired this book from Microsoft Press. I currently have Office Enterprise 2007 (Access included) and have firmly decided to convert my Informix-SQL app to Access 2010. However, I\'m not e[详细]
2023-01-23 14:04 分类:问答How to make connection from Crystal Reports to Informix?
I am new to Crystal Reports.I want to make a connection to an Informix database.Can anyone help? Connection to Oracle 开发者_Python百科may also help.You will need to know the name of the Informix data[详细]
2023-01-22 20:17 分类:问答Type casting in Hibernate for column in Informix database
I am using Informix for a OR database and Spring + Hibernate on the backend of my application. The thing is, I make in a String variable the query that inserts data in the database table. In this quer[详细]
2023-01-22 18:34 分类:问答SQL moving to vertical records
I have a table (2 million rows) in Informix v11.10, replicated (50+ node) environment Basic layout is like so:[详细]
2023-01-22 15:28 分类:问答Informix JDBC PreparedStatement UPDATE Multiset
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 ...\");[详细]
2023-01-22 10:57 分类:问答Communicating with Informix from SQL Server
Right... I\'ve got a program I\'m doing some maintenance on. Urgh. Even describing it makes me shudder... Right, okay.[详细]
2023-01-21 04:08 分类:问答Informix: procedure with output parameters?
I searched a lot, but couldn\'t find anything.. I just want to ask if there\'s any way to create and call a procedure (Informix) with out parameters. I know ho开发者_Go百科w to return one or more valu[详细]
2023-01-19 14:18 分类:问答Error compiling ACE report with multiple SELECT INTO statements
INFORMIX-SQL 4.10: OK, So after fixing the INTO TEMP syntax and using AS aliases, the ACE compiler complained about not having every single alias in a GROUP BY clause so I added it to each SELECT sta[详细]
2023-01-19 03:49 分类:问答C#: How do I get the ID number of the last row inserted using Informix
I am using the Informix.NET driver (C#) to insert a row into a database table. This works fine, except I have no idea how to get the ID of the last inserted row:[详细]
2023-01-18 21:26 分类:问答