informix
join issue, what are the best alternatives?
Q: I have 5 or 6 tables , and i need data from these tables : i make the following join statement to accomplish my query.[详细]
2023-03-06 19:36 分类:问答Delete / backspace within dbaccess will not delete characters
Usin开发者_Python百科g dbaccess via SSH into a fedora server.When I go to Query - New, both backspace and delete do not have an effect.[详细]
2023-03-06 17:24 分类:问答Cannot add an ORDER BY command to a stored procedure
I\'m converting a stored procedure in some software I\'m maintaining from SQL Server SQL to Informix SQL, and problems are abundant.[详细]
2023-03-06 17:13 分类:问答How to use PHP to connect to an Informix database?
First, I would like to introduce the problem. I have a Informix database that is currently used by 300 staffs (average is around 100,000 records/query) that make this server work slowly. Current arc[详细]
2023-03-05 05:44 分类:问答XML Serializer skipping over rows
I have an application that reads records from the database and exports it out to an xml file.There is a xsd in place that draws out the schema of the xml file.I am using the xsd proxy classes to then[详细]
2023-03-04 19:38 分类:问答2 queries that should return the same data but don't
I have 2 Informix queries that I believe should return the same data but do not. The first query uses a subquery as a filter and improperly returns no rows. The second is performed using a left outer[详细]
2023-02-28 04:12 分类:问答Is Informix-SQL supported under Open SuSE?
Is Informix-SQL supported under Ope开发者_如何转开发n SuSE or under Novell\'s SuSE Enterprise?ISQL is supported on Novell\'s SuSE Enterprise (and Redhat Enterprise Linux, RHEL), but there\'s no obviou[详细]
2023-02-20 09:41 分类:问答Get max one result of each value in a column
I\'m working with a Informix DB and with a table like this: Col1 Col2 Col3 aaa bac cba dcd Is it possible from the SQL statement to just display ONE of the first 2 rows by just specify only unique[详细]
2023-02-19 05:33 分类:问答Executing multiple statements in a single roundtrip with Informix
Is it possible to run multiple DML statements开发者_如何学编程 in a single roundtrip using Informix and .Net?[详细]
2023-02-18 19:21 分类:问答Does an ORM for C++ (Object Interface) for Informix exist?
We use Informix only in our company, there is an old self-made OR mapper, but it\'s hard to dive into and buggy.[详细]
2023-02-16 06:26 分类:问答