Questions tagged [informix]
Informix is an SQL-based object-relational, OLTP/OLAP, NoSQL DBMS produced by IBM. This tag is appropriate for questions about any of the products with Informix in the product name.
informix
2,252
questions
0
votes
0
answers
31
views
first 2 makes query slower than when I use first 1 in sql query in informix database
I have a query on a huge table (126738484 records) on an informix database server;
this query returns only one record.
when I use "first 1 " in the select statement, it runs quickly but ...
0
votes
0
answers
45
views
ASP.Net - query Informix Database without client installation
Looking to connect to an IBM Informix database from a ASP.Net application. Is this possible with nugets/references without any SKU or client package installation?
I see that this is possible with JDBC ...
0
votes
0
answers
41
views
Issue in deploying Spring boot 3.3.1 App on Payara 6.2024.6 after adding JNDI configuration with Informix DB
I had created one hello app without JPA I deployed it on Payara, it worked but when I added JNDI name to it and configured properly JNDI in Payara also added all the drivers to payara lib directory, I ...
0
votes
1
answer
45
views
Unable to (re)connect to Informix DB: Failed to get Connection.Connector(NOT CONNECTED: Driver=NO_JDBCDRIVER_PROVIDED;))
I hope someone can shed some light on this pretty old informix DB connection problem running on a very outdated Cisco Call manager 6.1 server (the PUB machine with one functional SUB machine). After ...
0
votes
0
answers
31
views
Xampp Php Informix jdbc
I need help to get result from informix server through xampp.
I installed Xampp 3.3.0 on windows 11.
I used
$conn= osbc_connect (DSN, username, password);
and also used
$dbo = new pdo (odbc:dsnname,...
1
vote
0
answers
11
views
Using Informix in Python [duplicate]
I'm trying to develop an API in Python using Informix, but I can only install IfxPy (the driver I found to use with Informix) on Linux, but I would need to install it or another driver on Windows.
...
0
votes
0
answers
33
views
Informix PDO assoc_id error SQLSTATE=HY000, SQLDriverConnect: -25546
It has been about half a year that we have been facing an error on our production server. At the beginning it happened every 2-3 months, but last Friday it happened again and today once again. We have ...
0
votes
0
answers
61
views
Informix C++ Client SDK multi-thread connection issue
I'm developing an application multi-thread that needs to connect to an Informix DB.
I'm working with the CSDK 4.50 and C++ libraries.
I'm encountering issues with the connection. I didn't find the way ...
0
votes
1
answer
32
views
ROUND_HALF_DOWN in informix
i tried the round with mode syntax but it's giving me an error in informix (3.50).
Can you help me please or give me other alternative if mode is not supported in this version?
Thank you in advance
0
votes
0
answers
36
views
Croatian characters in SQL for Informix database, using R
When I use a command such as the following:
DBI::dbGetQuery(my_connection,
"SELECT * from my_table WHERE prezime IN ('Kovač', 'Šokač')")
I get the following error:
[Informix][Informix ...
0
votes
2
answers
75
views
Which Expression in Postgresql is same as "MATCHING" in Informix
I am working on a project for migrating database from Informix to Postgresql and not able to find a replacement of "MATCHES" in Postgresql. Below is the sql query which I am trying to make ...
1
vote
1
answer
75
views
Informix PrepareStatement throws error - "A character to numeric conversion process failed" when LIMIT clause is added to query
I have a sql query which works fine until a LIMIT clause is added to the end of the query.Below is the query:
String query = SELECT * FROM customer
WHERE acct = ?
AND cust_id = ?
AND call_status ...
0
votes
1
answer
82
views
Informix python package :pip install ifxpy error in IfxPy setup command: use_2to3 is invalid
pip install ifxpy
Collecting ifxpy
Using cached IfxPy-3.0.5.tar.gz (155 kB)
Preparing metadata (setup.py) ... error
error: subprocess-exited-with-error
× python setup.py egg_info did not run ...
1
vote
1
answer
45
views
How To add Index on DATETIME column in Informix
I have a query like
SELECT
patient_id, patient_name
FROM
patient_details_tbl
WHERE
date(generated_time) between '2024-01-01' and '2024-04-30';
I know if I simply create an index on the ...
0
votes
1
answer
47
views
Connect to legacy Informix Server using .NET Data Provider
I am creating an IfxConnection to connect to the legacy Informix server
IfxConnection con = new IfxConnection("Host=localhost;Server=myserver;UID=user;Pwd=pswd;Service=9088;Database=sysmaster&...