2,259 questions
0
votes
0
answers
28
views
How to Connect Email System with Informix 4GL Database Using Shell Script for Automation?
I am using Shell Script for automation in an AiX environment, working with the Informix 4GL database. I have written an automation script that sends an email to the user. The user needs to reply to ...
1
vote
0
answers
35
views
Assign Unique Identifier to one complete Hierarchy of datasets [closed]
I have a huge dataset of hierarchies, (multiple levels in single hierarchy), want to assign a unique identifier to the hierarchies, so that i want compare the values in between those hierarchies.
...
- 19
0
votes
0
answers
34
views
Query two SQL databases in the same Jupyter instance using jaydebeapi
I need to query two different databases in the same Jupyter notebook. The code below works great for each individual database section (Informix V Oracle), but when I run all commands, I get an error ...
- 1
0
votes
0
answers
25
views
Informix DB " -556 Cannot create, drop or modify an object that is external to the current database "
I have created a simple procedure in Informix
Database.
I am able to run this procedure from Data Studio (Informix Development Tool) and the procedure is executed successfully.
But, when i try to ...
- 81
1
vote
1
answer
72
views
Cannot connect to Informix database using NodeJS API
I am trying to build an API using NodeJS 20.15.1 to our Informix 12.10.FC16 Databases, but can't get it to work. I tried using "npm install ibm_db" but it won't connect.
I've been trying for ...
- 53
1
vote
1
answer
88
views
Execute Prepared Statement in a Stored Procedure in Informix
I am using Informix 12.10 on most of my systems, and I am trying to run this using dbaccess on a Windows server. I am trying to understand how to work with stored procedures and prepared statements. ...
- 49
0
votes
1
answer
50
views
ASP.NET CORE 6.0: Informix Connection: Error Connecting
I am trying to connect to an Informix database using the Informix.Net.Core.dll in an asp.net core 6.0 web api. I have set the path to InformixDir\bin directory on my machine and have used setnet32 to ...
- 707
0
votes
1
answer
76
views
Trying to connect to Informix db with Python + Ibm-db
I am trying to access my Informix database with Python via the ibm_db module.
I am running with:
Python 3.12 64bits locally
Windows 11 Home
Here my code so far:
import os
# apparently I need to add ...
- 41
1
vote
1
answer
39
views
within a procedure how to know if i am in a transaction
In Informix, from within a procedure, how do I know if the caller is calling me from within a transaction.
- 113
0
votes
1
answer
36
views
Write a message to the log
Inside of stored procedure, is it possible to write a message to the standard log file? Trace goes to a separate file, but I would like to note something that isn't really an error in the main log ...
- 49
0
votes
3
answers
76
views
Combine rows values based on same date sql
In the example I am providing, I am trying to combine time_taken for the month where a value overlaps to 2 days for a month.
SELECT
run_date,
max(end_time) - min(start_time) as time_taken
from ...
0
votes
0
answers
59
views
Python script executable single file selecting from INFORMIX database Unspecified System Error SQLCODE=-23101
If I run IsOverUzivNoODBC.exe compiled from Python script runs fail with message
IfxPyDbi::Error: Exception('[OneDB][OneDB ODBC Driver][OneDB]Unspecified System Error = -23101. SQLCODE=-23101')
...
0
votes
0
answers
96
views
How to connect to informix database using jdbc jar file in python
Any ideas how to connect to informix database using jdbc jar file in python?
I tried jaydebeapi:
conn = jaydebeapi.connect('com.informix.jdbc.IfxDriver',
myurl,
...
- 1
0
votes
0
answers
54
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
57
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 ...
- 510
0
votes
0
answers
103
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
67
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 ...
- 11
0
votes
0
answers
44
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
1
vote
0
answers
13
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
63
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
81
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
43
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
- 171
0
votes
0
answers
46
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 ...
- 433
0
votes
2
answers
90
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 ...
- 377
2
votes
1
answer
127
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 ...
- 377
0
votes
1
answer
158
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
70
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 ...
- 81
0
votes
1
answer
105
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&...
- 1,509
0
votes
1
answer
452
views
A problem connecting to the Informix database using DataGrip
I am using a Windows 11 system and DataGrip 2024.1.2 client to connect to the Informix server with the Informix JDBC 4.50.10 driver.
The following connection parameters were used.
jdbc:informix-sqli://...
- 1
0
votes
0
answers
122
views
Couldn't user Informix.Net.Core package
I want to user Informix.Net.Core package to insert data into Informix.
connection.Open() throws exception like below:
Unable to load DLL 'iclit09b.dll' or one of its dependencies: The specified module ...
- 23
0
votes
0
answers
88
views
How Capture ISAM error returned by Informix Db in C#.NET
I am currently using .NET provider for Informix to connect and work with Informix db. I have seen in Informix documentation that in an ODBC application we can use GetSQLDiagField function to get ISAM ...
- 15
0
votes
1
answer
301
views
Hikari - Driver does not support get/set network timeout for connections. (Method not supported : IfxSqliConnect.getNetworkTimeout())
Connecting to an Informix Database through Hikari in Java 8 to create a connection pool I run into the following error message:
10:22:44.180 [main] INFO com.zaxxer.hikari.pool.PoolBase - HikariPool-1 -...
- 1,854
0
votes
0
answers
71
views
Table or column matches object referenced in triggering statement
I have a table contract(id, employee_id, date_from, date_to, status) and trigger contract_ins. I need to be able to update a same table but other records.
INSERT INTO contract(0, 'A001', '01-01-2024', ...
0
votes
1
answer
241
views
Looking for PDO Informix extension for PHP 8.3 [closed]
I'm trying to connect my Php 8.3 (x64) to IBM Informix database.
I have found pre-compiled versions of the extension for PHP 8.0 and 8.1 but it doesn't work with PHP 8.3.
Does anyone have this ...
- 21
1
vote
0
answers
189
views
Informix Golang client package
I am new to Informix and I want to establish a connection to Informix in golang. I have come across 2 approaches.
The ifxgo package: The github doc "https://github.com/OpenInformix/IfxGo" ...
0
votes
0
answers
69
views
How to resolve this error when using OpenQuery in SQL Server to extract data from an Informix database
We are able to extract data from the Informix database as long as the pull is working on recent data, for example:
FROM OPENQUERY (uccx_node1, 'SELECT * FROM contactcalldetail WHERE extend ( ...
- 427
0
votes
0
answers
61
views
Trigger/Stored Procedure causing sql error 127 Informix 12.10.FC10
I have a table that has a trigger to capture old and new details for every field in the table every time an application user makes an update. A SP is then executed to capture details (user ID, session ...
0
votes
1
answer
146
views
Update a huge number of rows without lock entire table in Informix
I need to update an huge number of rows in Informix, but when a run the update statement, it locks everyone works with the table for the entire updates process.
The sql statement:
UPDATE informix....
- 1,241
0
votes
1
answer
190
views
Informix ODBC Driver][Informix]A character to numeric conversion process
I have a simple Data Factory in Azure that reads from a CSV file and writes to an Informix table. I have a problem with decimal columns in Informix database. I can save integers but when I try to save ...
0
votes
1
answer
82
views
Update rows in an Informix database by incrementing serial numbers
I have a table in an Informix database, let's say it is called store, that looks like:
serial_num
store_seq
381-15
82600
381-15
82610
381-15
82640
381-15
82650
381-15
82680
381-114-1
82690
I ...
- 108
1
vote
0
answers
156
views
Informix - get DB Server Name / Alias for connected Session
I'm running an Informix Dynamic Server Version 11.50 on AIX with multiple DB Server Aliases listening on different tcp ports.
This is basically what I have in my sqlhosts file:
# dbservername ...
- 21
1
vote
1
answer
87
views
How can get full name from INFO TABLES at Informix DB
I'm not very good with cli and I need help getting the full names of restricted tables +
, for example: aardialprefixmatr+
> info tables;
Table name
aardialprefixmatr+ aarneighborhood ...
- 13
1
vote
1
answer
43
views
Is there a way to get the sql statement about the creation of the row type?
Example:
create row type custom_type string(street VARCHAR(20), city VARCHAR(20); getDDl(custom_type);
I think the server should store information about row type fields. However, I did not find ...
- 37
0
votes
0
answers
203
views
How to connect to informix DB using data direct informix driver and python on Linux
What I am trying to do: I am trying to connect to an Informix DB from Linux (RHEL 8.9) using Python. The python module I am using is pyodbc. The driver is data direct informix driver - ddifcl28.so
I ...
- 1,031
0
votes
0
answers
114
views
IBM VS.NET SE Integration & Extensions package did not load correctly
VS 2022 ver 17.8.4 send me error "IBM VS.NET SE Integration & Extensions package did not load correctly "
"The problem may have been caused or by the installation of another ...
- 31
1
vote
1
answer
217
views
IBM Informix Error "-556 Cannot create, drop or modify an object that is external to the current Database"
I have create a procedure. In that automatically a "New Table" will be created on the "First Day Of the Year" And "New Table" will be created during the first time ...
- 81
1
vote
1
answer
90
views
Find opaque types in the Informix database
I want to get a list of custom types (opaque types). Type information is stored in the sysxtdtypes system table, but opaque type is defined as basic (https://help.hcltechsw.com/hclinformix/1410/sqr/...
- 37
0
votes
1
answer
97
views
Informix: SQL does not accept double quote to surround a string
Is there any configuration that enforce only single quote allowed to surround a string in SQL? Problem occurs after a dbimport.
Database and OS
IBM Informix Dynamic Server Version 14.10.FC8AEE
Red Hat ...
- 113
0
votes
1
answer
93
views
Update a table in informix (an entire field)
I know SQL fairly well but I'm now working on informix and I don't think I know SQL at all any more.
I have the orders table called "cde" and the article table called "art" which ...
- 77
0
votes
1
answer
36
views
RJDBC dates all get returned as NA (Informix)
I'm using a RJDBC connection and can get most data fine. However, if I run a simple query like:
SELECT * FROM dimDates,
all column that are of type Date are full of NAs, even though they have concrete ...
- 433