Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
19 views

Configuring Informix to access data on another server

I have inherited an Informix installation that contains a large amount of business logic in the form of procedures. The company also uses SQL Server, MySQL and Postgres for various roles. We're very ...
Hut8's user avatar
  • 101
0 votes
1 answer
77 views

Convert Column multiple rows to single row output sql

I have an example query below that I am running that is only on one column, but multiple rows can be displayed: SELECT dbspace FROM tab_info_script WHERE database = 'dwh_vodac' AND tabname = '...
Christopher Karsten's user avatar
1 vote
0 answers
124 views

In Informix, is it possible to copy a database within the same server/host?

Assuming a user has sufficient privileges on the server, is it possible to copy a database in its entirety within the same server/host, using SQL only (i.e. without having shell access to the Linux ...
user3243135's user avatar
0 votes
1 answer
639 views

How to update multiple records using records from another table with join

I'm going to explain this scenario in such a way that it is easy to understand. For example I have 3 tables that I need to join in order to get the value I need for the age. See below table structure ...
Christopher Karsten's user avatar
1 vote
2 answers
690 views

Rownum equivalent in Informix SQL?

I want to explore (=looking at the first 100 rows) databases using the Informix SQL dialect. In Oracle SQL I would use SELCT* FROM table_name WHERE ROWNUM < 100 In Postgress SQL I would use SELCT* ...
Qaswed's user avatar
  • 121
0 votes
1 answer
29 views

Are the Informix and Lucene analyzers similar?

Is the analyzer discussed here same as Lucene analyzers? I am confused because most of them show similar properties to Lucene analyzer but the blog posts don't say a word about Lucene; instead they ...
bomtirgom's user avatar
3 votes
2 answers
2k views

What are the various Informix column data types?

I am writing a query where I need to know if a column is of the "BLOB" type of column. According to this documentation 41 is the number for "BLOB" types of columns, in general. ...
Vanity Slug - codidact.com's user avatar
1 vote
0 answers
81 views

Informix onunload/onload between different arch

I have some necro-project using Informix Dynamic Server Version 7.31.UD1. I need to backup-restore database between servers. The thing is, the onload just silently exits and doesn't create a database, ...
drookie's user avatar
  • 228
1 vote
3 answers
333 views

count duplicate records and select first 2

I have troubling issue where I want to only select the first 2 chunks of every dbspace created. query used: SELECT a.dbsnum, b.chknum, a.name, b.fname FROM sysdbspaces a, syschunks b where a.dbsnum = ...
Christopher Karsten's user avatar
3 votes
2 answers
734 views

Convert seconds into HH:MM:SS in Informix

How is it possible to convert a float number of seconds to HH:MM:SS in Informix. I have a column that has a run duration of 1449.448520410. I want to convert this to a human-readable format. There are ...
Christopher Karsten's user avatar
1 vote
1 answer
156 views

Informix onunload/onload to take a snapshot and then restore

I have an Informix database. I want to take a snapshot, make some changes, then restore the database from that snapshot. (If Informix supported nested transactions, I would be using transactions.) ...
spraff's user avatar
  • 213
1 vote
2 answers
708 views

case statement using characters for sum value

I have a table that I am trying to pull a single return value on a select saying that either compressions on table is enabled or disabled by using a sum calculator for column value compressed must be ...
Christopher Karsten's user avatar
0 votes
1 answer
737 views

Informix JDBC login fails, local login succeeds

I'm troubleshooting a "sudden" issue on our somewhat old Informix server (11.50.UC9GE). After years of running without issue (and connecting w/o issue), suddenly today we can't connect to the server ...
MT.'s user avatar
  • 101
0 votes
2 answers
93 views

Informix v12 substitute for query using multiple with statements

I am trying to convert some PostgreSQL into Informix and factor out the WITH statements in the query below. I have been unable to locate a solution to factoring out multiple with statements. The ...
nstillwell's user avatar
1 vote
0 answers
212 views

IBM Informix - cast decimal to time format

My customer uses an IBM Informix environment to track production information. In the current SharePoint 2013 he was able to show those infos with this query: Select stillst_grund,sum(charge_bis-...
airliner's user avatar
2 votes
1 answer
911 views

How do I convert a BIGINT to a DATETIME in Informix 12.1

I'm new to Informix, and I'm trying to convert a bigint to a datetime. SELECT sdatetime FROM CallDetail; Results: sdatetime ---------- 1572509662678 1572518550704 1572519033540 This seems to be the ...
Leezard's user avatar
  • 123
2 votes
1 answer
540 views

Group records with same value in one row informix

I have 3 records in a table below called systables_growth: tabname aactn total_size_kb 32 date_added 2019-08-26 13:00:00 tabname aactn total_size_kb 37 date_added 2019-...
Christopher Karsten's user avatar
1 vote
1 answer
593 views

Informix create procedure to query records and drop if value does not exist using select

I am trying to create a procedure that will query a table column to retrieve table names and using this in proc to run a query to do a select if it exists. If it does not exist, delete row(s) from ...
Christopher Karsten's user avatar
1 vote
1 answer
658 views

Informix trigger to delete records before insert

I am trying to create a trigger to simply delete records from systables_growth table before an insert happens based on the where clause used on the date_added column for records older than a certain ...
Christopher Karsten's user avatar
2 votes
1 answer
6k views

How to get all tables in informix database and their sizes in GB?

I can get a crude estimate of table sizes with SELECT tabname, (rowsize*nrows)/1024/1024/1024 AS tabsize FROM informix.systables ORDER BY tabsize DESC Is there a way to get a more accurate ...
stevec's user avatar
  • 123
1 vote
1 answer
2k views

Create column for values between a range sql

What I want to achieve is to create a new column based on the num_extents between a range and only print the table name below. This is what I have [table1]: This is what I want [table2]: I used a ...
Christopher Karsten's user avatar
0 votes
1 answer
226 views

How to rename an index in informix using numbering

I am currently facing issue of renaming an index to a number. I have tried the below: RENAME INDEX 584_1973_tmp TO '584_1973'; RENAME INDEX 584_1973_tmp TO ' 584_1973'; RENAME INDEX 584_1973_tmp TO "...
Christopher Karsten's user avatar
0 votes
0 answers
606 views

How to connect Informix to SQL Server as a linked server?

We got to the point that we can see the tables, but we can't see the columns. For the record, all of the tables are called "root.". I don't know what that means in Informix speak. Based on the ...
Scott Wood's user avatar
0 votes
1 answer
1k views

how to search for a table across catalogs of informix database?

I would like find schema in which a table exists in Informix database. I know that we can use below query. But that searches only with a schema. select tabname from "informix".systables where ...
Bhukailas's user avatar
0 votes
1 answer
1k views

Informix - dbaccess vs dbexport to export tables to text files

Currently, we are using the dbaccess utility to export all tables in the Informix database to text files. These are used to "mirror" the database multiple Windows machines running MSSQL Server on a ...
RightCoaster's user avatar
0 votes
1 answer
183 views

Consume data from other database motor from stored procedure in Oracle 12c

I have a project in which you must develop services in Oracle OSB which will call a procedure stored in Oracle 12c. The issue is that I also need data from an Informix database to build those services....
Andres Carvajal's user avatar
0 votes
0 answers
217 views

Query with LVARCHAR performance in Informix DB

In a maintenance project that it's working with IBM Informix Dynamic Server Version 11.50.FC6 we have to improve the performance of some queries. One of this queries to the Informix DB fetches a ...
Lubco's user avatar
  • 1
2 votes
2 answers
3k views

Connection Issues with Informix OLEDB Provider

I've been trying to establish a OLEDB Connection to an Informix Dynamic Server. (Version IBM Informix Dynamic Server Version 12.10.FC12WE) Background Info: A program, which will be used by my ...
kastner_bsa's user avatar
1 vote
1 answer
74 views

Insert constraint issue

Using IBM Informix database. If I specify order_no manually, the statement works but if I try to increment it within the query, it fails. Table structure patkey serial notetype char(4) order_no int ...
Tsukasa's user avatar
  • 319
1 vote
0 answers
204 views

Most effective way of logging user query activity

We are logging and permanently storing all the queries performed about private persons in our database. Due to GDPR we need to be able to show all the entities who have requested personal data and the ...
Karl Märka's user avatar
0 votes
0 answers
379 views

Linked server Informix driver mismatch error on driver and applciation

I tried to read all the questions here that has been asked before, but could not find any clue on my problem. I'm trying to setup a linked server to connect on INFORMIX server, I installed the driver,...
Mel Cuya's user avatar
2 votes
1 answer
182 views

informix rest api not startable

I am currently trying to configure the informix REST API, as specified here. Overall, I came across two error messages: Unsupported listener type of rest specified OP Code is not valid: Check ...
Martin's user avatar
  • 23
0 votes
0 answers
385 views

Confusion in Informix when selecting dates with JOIN

I am trying to run a query in Informix, doing a join in a table of logs where we save the record of insertion of the rows. Notice that the query below brings two results, with different insertion ...
Rafael Lima's user avatar
0 votes
1 answer
626 views

Using character set en_us.364 in Informix database DB_LOCALE

I am trying to change my db_locale to en_us.364 which is an ASCII character set. It says on IBM's Knowledge Center that 364 is a valid character set: https://www.ibm.com/support/knowledgecenter/en/...
michael.moyer's user avatar
1 vote
0 answers
868 views

Converting and/or enforcing an Ascii Character Set in Informix database from 819 or ISO Latin 1

Overview: In Informix is it possible to enforce ASCII for a database or instance. Details: I am trying to enforce ASCII in an instance of informix for a while. This is to help have a smooth ...
michael.moyer's user avatar
1 vote
1 answer
221 views

Microsoft Distributed Transactions from Informix with Linux

I need to create an extraction job from an Informix database, the requirement is that I need to enable transactions in SSIS. All of the MSDTC settings of the target machine and the SQL Server database ...
Rafael Lima's user avatar
1 vote
0 answers
241 views

Is there such a thing as result cache for Informix

Informix has SSC (SQL Statement Cache), but that doesn't seem to cache the result of the query. Is there something else to activate to also cache the result ? I am using Informix 12.1 on Redhat.
Stéphane Gerber's user avatar
0 votes
1 answer
170 views

What are the pitfalls of using "Preserve" for Cursor Behavior in Informix ODBC DSN?

I am converting an Informix SE to an IDS database. The programs I have use ODBC System DSNs to communicate with the database. For SE, we use the sesoctcp protocol. The program code, would open a ...
kttii's user avatar
  • 101
4 votes
0 answers
3k views

How to declare and use variables in Informix

How can I declare and use variables in Informix Database. I'm using version 9.40uc7 and I would like to create two date variables read values into them then compare them using an if statement. eg....
Kefash's user avatar
  • 175
0 votes
1 answer
3k views

How to display values excluding maximum value based on column that is duplicated

I am facing a challenging issue where I need to print all fields from a specfic column based on a duplicate column that excludes the maximum value My query plan: select event_no, bs_id from ...
Christopher Karsten's user avatar
-2 votes
2 answers
9k views

How to create a stored procedure that can insert a record into two tables [Informix]

I need to create a stored procedure that can insert a record into the two tables I have the two tables below: create table "sacro".doc_submitted ( doc_id serial not null constraint "sacro"....
Christopher Karsten's user avatar
5 votes
1 answer
3k views

Informix DB export to Microsoft SQL Server 2016

I have an Informix Database and a Microsoft SQL Server 2016. My task is to dump the whole Informix Database and export it to the Microsoft SQL Server Database. I installed the Informix SDK 4.5. I ...
Daniel's user avatar
  • 61
2 votes
0 answers
47 views

Informix Innovator-c and SAN storage: How can we increase Innovator-C parallelism in high latency disk IO situations

When using Innovator-C against SAN storage (which is unavoidable in some cloud infrastructure situations) on a Linux (CentOS 6.x) system, write latency becomes the bottleneck in performance (we've ...
user3546411's user avatar
11 votes
1 answer
11k views

SQL Server --> Informix DB Linked Server

After about 3 days of trying, I am unable to create a linked server from SQL Server 2016 to Informix 11.5. I haven't tried this with other versions (2008R2, etc) since I wanted to set up the ...
S3S's user avatar
  • 3,578
1 vote
1 answer
2k views

Informix Older than 15 Minutes

How can I do this MySQL statement in an IBM Informix? select type, channel, teilnr, starttime, endtime, usedtime, host from online_time where starttime < DATE_SUB(NOW(),INTERVAL 15 MINUTE) order ...
LStrike's user avatar
  • 149
4 votes
2 answers
960 views

Informix - Getting all descendants of a parent

I have a table with two columns, Parent and Child. Need to get the list of all descendants associated with the parent records. Source Table: +----+-----------+ | Parent | Child | +----+-----------+ |...
Zoran's user avatar
  • 43
1 vote
1 answer
2k views

Informix instance not starting

When I tried to start the Informix instance in Linux using oninit, it says WARNING: server initialization failed, or possibly timed out (if -w was used). Check the message log, online.log, for errors....
Manohar S's user avatar
2 votes
1 answer
3k views

How to check if a table exists in Informix

What would be the query to check that a table exists in Informix ?
Developer Marius Žilėnas's user avatar
0 votes
1 answer
881 views

Informix DBDELIMITER tab

I'm using the Informix DBEXPORT to dump my database however it uses | as its default delimiter. I know I can specify the delimiter I'd like to use using the DBDELIMITER environment variable but how ...
TheLovelySausage's user avatar
1 vote
1 answer
2k views

Informix Specific Table export

I'm busy trying to migrate data between informix databases using the dbexport and dbimport utilities. I know that in PostgreSQL I can use the following pg_dump –a –t table database > /destination/...
TheLovelySausage's user avatar