Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
21 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 ...
0
votes
1answer
38 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 ...
0
votes
0answers
25 views

Informix - where clause with merge into

I am using Informix Dynamic Server Version 12.10.FC9W1X2. I need to update a table with fields from a different table. I am attempting to use the MERGE INTO statement, but I am not able to use a ...
0
votes
1answer
23 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....
0
votes
0answers
52 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 ...
1
vote
1answer
126 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 ...
1
vote
1answer
38 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 ...
1
vote
0answers
35 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 ...
0
votes
0answers
119 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,...
2
votes
1answer
43 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 ...
0
votes
0answers
203 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 ...
0
votes
1answer
221 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/...
1
vote
0answers
184 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 ...
1
vote
1answer
103 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 ...
1
vote
0answers
83 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.
0
votes
1answer
81 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 ...
1
vote
0answers
862 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....
0
votes
1answer
231 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 ...
-3
votes
2answers
2k 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"....
5
votes
1answer
922 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 ...
2
votes
0answers
27 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 ...
7
votes
1answer
4k 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 ...
0
votes
1answer
569 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 ...
4
votes
1answer
437 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 | +----+-----------+ |...
1
vote
1answer
827 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....
3
votes
1answer
1k views

How to check if a table exists in Informix

What would be the query to check that a table exists in Informix ?
0
votes
1answer
306 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 ...
1
vote
1answer
659 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/...
1
vote
1answer
102 views

Informix Migrate Schema

I'm busy trying to migrate an informix database schema (with no data) to an informix database running on a different server. I have exported the schema from the database using dbschema -t all -d ...
-1
votes
1answer
546 views

How to migrate an Informix database from IBM AIX to MySQL on Linux [closed]

I have a migration activity where I have to migrate an Informix database which is running on an IBM AIX machine to MySQL running on a RedHat Linux machine. How can I do that?
2
votes
1answer
50 views

Informix help - SQL DBA

I am a SQL Server DBA with minimal Informix 11 experience. I'm tasked with extracting an entire Informix database (circa 8GB according to systables in Informix) into a SQL Server database. I plan to ...
1
vote
0answers
71 views

Joining and combining MySQL tables from Informix

I previously asked this in StackOverflow, But I couldn't find a solution, so I thought I'd share my problem here too. I have an old system that uses Informix for data storage, and I'm working on ...
1
vote
0answers
21 views

Is it possible to index serial8 type column for BTS in Informix

Trying to Index an Informix Database for Basic Text Search. One of the columns is of type Serial8. Is there a way or is it possible to index serial8 column for BTS, without changing the type of the ...
2
votes
2answers
505 views

32 bit vs 64 bit system - Informix Client SDK

If I create an Informix SSIS package in my 32 bit system using 32 bit Client SDK and deployed it in 64 bit server. Will it create issue?
1
vote
1answer
567 views

Extract SYNONYM and SEQUENCE from Informix metadata

We are migrating Informix database to oracle. Please help us to extract SYNONYM and SEQUENCE from Informix metadata using query.
1
vote
1answer
522 views

SSRS and Informix connection

I have the IBM drivers installed, created a data source that successfully tests from SSRS front end. Create a report from my machine which also has the drivers installed and the ODBC testing ...
0
votes
1answer
1k views

Informix Server Rejected Connection

What are possible causes for the following error? DB Error: connect failed [nativecode=08004 [unixODBC][Informix] [Informix ODBC Driver [Informix]Server rejected the connection.] I have doubled ...
1
vote
1answer
202 views

Informix: is it necessary to update statistics on views?

In Informix I have a partitioned table for performance reasons. One contains the latest data and another the historical data. Also, there is a view which contains data from both. When I update ...
2
votes
3answers
2k views

Creating a MySQL db from an Informix database

There is an existing database that was created in Informix. I would like to export it and then import it into MySQL. I tried to export it using dbschema and it created the dbase.sql file and several ...
1
vote
1answer
29 views

Retrieve one of two possible values from 1 table in INFORMIX

I have a table which for the same key, it will always have one record with value 'P' but sometimes that same key could have two records one with value 'P' and one with value 'L'; I need to create a ...
2
votes
4answers
6k views

How to join the latest previous record with SQL

I have a table whose schema is like this: CREATE TABLE product_shipping( product_id CHAR(10), product_name CHAR(10), deal_dt DATETIME, deal_reason_no SMALLINT, cancel_dt DATETIME, ...
1
vote
1answer
127 views

How can I control the order of a query regarding to inner join

I have 3 tables. They have table_a 5m records table_b 20m records table_c 20m records I'm performing the query below. SELECT * FROM table_a a INNER JOIN table_b b ON a.a_id = b.a_id AND b....
1
vote
2answers
5k views

Multiple table rows in one row Informix

I have problem just like this one but in Informix. I have table with 2 attributes ID, email like this one: ID email 1 my_mail1@mail.com 2 my_mail2@mail.com 2 my_mail3@mail.com 2 my_mail4@...
1
vote
1answer
771 views

Moving the IBM Informix IFMXDATA directory to another machine

I'm a total newbie when it comes to Informix DBs, and I'm stuck with what looks like files that contain an Informix database. I'd like to know if it's possible to add or import these files into an ...
1
vote
1answer
4k views

How to know what index is set on the table with command line in informix?

I'm using the Informix DB. I want to detect what index the table has using command line. I used dbschema -d dbName -t tableName | grep index to detect the index. What's my problem is that the ...
2
votes
4answers
5k views

Filter Stored Procedure Result (Informix)

IBM Informix Dynamic Server Version 11.50.UC5XA. I have a Informix database. This database contain a stored procedure with name of 'sp_agent_details' that get two DateTime Parameter. This stored ...
2
votes
1answer
848 views

Can't Select a View on Informix

I'm using Informix IDS 11.50 Innovator-C edition running on Slackware Linux 12.0. I've been running a very small Database on it(less than 10000 records on the biggest table). I'm trying to select a ...
1
vote
3answers
1k views

Why can't I create a database in a 107GB dbspace I created for my instance?

11.70.FC6 Developer Edition on Windows 7 Pro 64-bit: Downloaded via IIUG link and installed it. I created a custom DSS instance named "server" with a 128GB dbspace named "datadbs". Install wizard ...
6
votes
2answers
1k views

How should I best design the tables and relationships, given the following rules?

In a Pawnshop business, customers pawn, sell or buy items. A contract which specifies the customers information, the items, and the terms and conditions is created whenever customers pawn, sell or buy ...
1
vote
1answer
1k views

connection to Informix still active despite closing?

I have a small C# utility connecting (via the IBM Data Server Provider for .NET) to a Informix DBS (version 11.7) and sending one or two queries to several databases. Even though I close each ...