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
0answers
3 views

Execute informix content from file

I need to execute a script (informix code) in a .sql file for migration purposes. The thing is, I want to load it from a function to be able to use the exception, therefore being able to do a rollback ...
1
vote
1answer
26 views

The data value could not be converted for reasons other than sign mismatch or data overflow

I have recently migrated an application from .NET Framework 2.0 to .NET Framework 4.5. It is using Informix version 3.50 as a database. After migration, when it is fetching from the database and the ...
0
votes
1answer
25 views

Microsoft Access equivalent of OPENQUERY()

We use multiple SQL databases of various types; one of them is an Informix database. Some of our analysts are having issues pulling data from it, especially when using dates. Years ago I'm sure I saw ...
0
votes
0answers
39 views

Informix error on read: could not do a physical order read

Problem in nutshell executed data updates on couple of tables using dbeaver later reads from these tables started failing looks like the rows/pages in these tables are locked by the session where ...
1
vote
0answers
33 views

Delete file after load

I'm preparing a migration on an Informix database and I'm wondering if it's possible to delete a file after loading its information to a table. I mean, in theory it should be possible, since you can ...
1
vote
0answers
42 views

Euro symbol not allowed

I have a problem with the euro (€) symbol insertion (or update, or load, or unload... anything) on informix. When I try to insert/update it just throws the error: "SQL Error (-79716): System or ...
0
votes
0answers
50 views

How to speed up a query using function and indexing on Informix

Under Informix Dbms I need to speed up this query: set isolation to dirty read; SELECT NVL(hr_dati1, '---'), NVL(cm_t_stoc, -1) as type, LPAD(cm_mod,3, 0)||LPAD(cm_col,3, 0) as coord, NVL(cm_segmento,...
0
votes
0answers
29 views

Can we have same columns for Indexing and primary key - Informix DB

Is possible to add an Indexing columns in a table that already have a primary key - Informix DB? I have done inserted the indexing, then i drop it, it shown errors" Index does not exist" - DROP Index....
0
votes
1answer
31 views

Informix Stored Procedures with Entity Framework Issue

I am trying to import stored procedure into the entity model using database first approach and import fails due to the following warning. I am using Visual Studio 2015 update3 Error 6005: The funtion ...
0
votes
0answers
25 views

Fill a specific column of datagridview from Informix vb.net

I'm filling a DataGridView but I cannot find how to fill an specific column of the datagridview. The connection string and filling the table works fine. I'm getting ID,Name,Surname,Country,Age from ...
0
votes
1answer
43 views

Decimal data not stored correctly in database by doctrine

Within one of my Symfony applications I encountered a strange behavior of the doctrine ODM. What I'm trying to do is simply saving decimal typed data to our Informix database. Whenever I try to do so ...
0
votes
0answers
32 views

Get a Text data type in stored procedure

I need to have a Text data type column (instead of an Lvarchar, for space reasons) in a table. But I have a problem. If I pass the insert/select statement from C#, with the parameter being a string, ...
0
votes
0answers
51 views

Informix Stored procedure with Entity Framework

I am new to Informix stuff and I have a legacy database (IBM Informix) and there are thousands of stored procedures written. Now I am trying to create the model class using Entity framework database ...
0
votes
0answers
34 views

Informix varchar to text

I'm new to informix and I was asked to make some necessary changes to some tables. I'm modifying a table column type. The current column is varchar(255) and I need to modify it to text. I was told to ...
1
vote
1answer
20 views

Close Informix connection in scheduler

I built a scheduler who can get data from Informix database. My scheduler is triggered every 30 seconds. But I have a question about the connection close. Do you recommend me to close the connection ...
1
vote
1answer
44 views

Informix JDBC ISO-8859-2 encoding problem

I have a problem with string encoding in my Java application. My Informix database has ISO-8859-2 encoding. I have set DB_LOCALE in a connection string. My connection URL looks like: jdbc:informix-...
1
vote
0answers
40 views

Identity in Informix

I'm using Informix and I want to create a table like this: CREATE TABLE increment_table ( id SERIAL NOT NULL, increment_column INTEGER IDENTITY (START WITH 2000, INCREMENT BY 1), name ...
1
vote
0answers
30 views

Unable to import data from Informix non transactional database to HDFS

I'am trying to import a table from an Informix DB to HDFS. I'am using Cloudera distribution. I have made sure that the jars are correctly placed under /var/lib/sqoop folder on the host where I'am ...
-1
votes
0answers
31 views

What are the major differences between using SQL with informix and other database languages e.g. MySQL SQLite

I've been learning SQL via hackerrank (using MySQL) and codeacademy (which I believe runs off SQLite). At work we use an Informix database. Are there any major pitfalls I should look out for - for ...
1
vote
1answer
42 views

Sql error in manage a select to search for sequential hexadecimal number with hole after post join filter

I want to insert a hexadecimal sequential number in ad_code char(5) field and handle / fill its holes. In order to speed up the query from initial table table1 Column name Type ...
1
vote
1answer
66 views

Is it possible to generate a unique random alphanumeric code consisting of 5 characters using Informix or standard sql?

I'm using informix IDS server, and I have this table table1 : Column name Type Nulls ad_code char(5) yes ...
1
vote
2answers
54 views

MS SQL/OPENQUERY call to Informix — too many single quotes? too few?

I am trying to communicate with an external Informix datasource from an MS SQL 2016 database instance to issue a date bound query. To do this, I am doing the following: --enter code here declare @...
1
vote
1answer
25 views

Squirrel can not find an informix drivers

This is my first question in this program, but I really can't find a drivers for squirrel SQL client. When I try to connect to INFORMIX I get error like this "Could not find class com.informix....
0
votes
1answer
35 views

Informix db error while creating stored procedure “SQLState: 42000 ErrorCode: -201 Position: 167”

I am trying to create a stored procedure in informix database, but when I try to run the create procedure code the following error appears on the very first line: Error: A syntax error has occurred. ...
1
vote
2answers
102 views

How can i make image with php 7.2 and pdo_informix in Docker?

I am trying to create an image in docker with apache2, php7.2 with pdo_informix, but I have not been successful, I just do not see the extension enabled and I do not know if I'm doing a wrong step. I ...
0
votes
0answers
24 views

Stuck on Robbiblubber and Informix

Im trying out this Nuget package Robbiblubber. Trying to get a connection to an informix db which I have a jar from. Added the jar to the project but when I try and execute a read command it just ...
1
vote
1answer
30 views

Informix - Default permissions when creating table

So, Im using Informix DB engine to create my database. I have noticed something peculiar I cannot find information about in the official IBM page. If you check the definition of my table, there is a ...
0
votes
0answers
25 views

TO display record in one row

I have this sql statement as to retrieve one row only, but I am not sure how to do it. select pav_employee,pav_name,pas_paycode, pas_amount,pav_paynettamt from m_advhdr,m_payshthdr,m_payshtline ...
0
votes
1answer
36 views

Name columns on store procedure informix 7.x

I have a store procedure on informix 7.x, this store procedure is called on Nhibernate using CreateSQLQuery method. The problem is all columns retrieved by store procedure have the same name "...
1
vote
1answer
35 views

C# .Net integration with Informix DB. Can it be done without the extra installation of the CSDK?

Is it possible to connect to an Informix database without having to run the Informix SDK installer to get the driver? I want to avoid any extra installation steps and was hoping there would be a ...
1
vote
0answers
38 views

Informix External Tables DROP

I am trying to unload data from an internal Infomix table into an external file using the following stored procedure. create table table_name( column1 int, column2 int ) insert ...
0
votes
1answer
37 views

Informix - Efficiently find 10 most recent calls

I have a table that has data like calling number and timestamp. I'd like find the ten most recent unique calls. This SQL query works: SELECT first 10 t.originatordn FROM (SELECT DISTINCT a....
1
vote
1answer
69 views

Connecting to a legacy informix database with django

I'm trying to connect to an existing Informix database with Django, I'm using django-pyodbc-azure to handle the connection via odbc, the connection work fine when trying in the python interpreter: &...
0
votes
0answers
43 views

Connect Informix with Laravel

I have php 5.4 with codeigniter 3.1.9 installed on my windows 10. I have suse linux 10 which has informix server. I created odbc connectivity in my windows 10 client for informix link and i ...
2
votes
1answer
46 views

Creating a temporary table in informix 4gl using prepare statement

I've been trying to create a function to load some files insert them into a temp table based on an existing table, then verifying that there are not duplicated rows on the files loaded and then ...
0
votes
0answers
46 views

Create a Trigger to change values before insert in Informix

We have a table with a date field. Also there are some old apps we can't modify whose inserts that date field with string ("yyyy-mm-dd") (Yeah, SQL Injectión Party!!). Now it's needed to change that ...
0
votes
1answer
41 views

Unspecified System Error using nodejs driver to connect to informix

I have this connection below. Works well in windows server but when in linux it doesnt. It provides this erro msg :an error occured:> Error: [Informix][Informix ODBC Driver][Informix]Unspecified ...
1
vote
1answer
64 views

How do you pass a boolean data type as a parameter for a stored procedure?

Say you have an existing stored procedure that accepts a single parameter, which happens to be of the BOOLEAN Informix data type: test_bool_param(BOOLEAN) What would the EXECUTE PROCEDURE statement ...
0
votes
1answer
78 views

Apache Ignite vs Informix Warehouse Accelerator vs Infinispan?

What's difference between Apache Ignite and IWA (Informix Warehouse Accelerator) and Infinispan ? I have an application that accept large volume of data and process many transaction in per second. Not ...
0
votes
1answer
51 views

Get list/multiset from informix to C#

I'm making a library for connecting an Informix database with a C# extension for use in Outsystems. So, now I've hit a wall. I need to receive a list/multiset from the db. How can I do that? I'm ...
1
vote
5answers
108 views

How do I convert key value paired list into table with columns using AWK?

I need to convert a dataset from a key value paired list (informix dbaccess output) into a columned csv. I'm fairly certain this can be done easily with awk or sed. UPDATE The solution needs to be a ...
1
vote
1answer
51 views

Where can I download the Informix ADO.NET Provider? [closed]

We have decided to add Informix support to our application. I wrongly assumed there would be an Informix package on NuGet then I wrongly assumed that IBM would have a download link for the software on ...
1
vote
1answer
94 views

Connect to Informix via C#

I need to connect to Informix but what seemed to be an easy task is turning to be a bit annoying. I downloaded the Client SDK and added the reference to the DLL. Here's the code: using System; using ...
0
votes
0answers
40 views

Informix Error to insert –32,768

i have issue while converting large value into short int in java using .shortValue() and inserting into informix column which is of type smallint . The small int ranges from -32767 to ...
0
votes
1answer
36 views

Informix - Syntax error on CREATE TABLE

I keep having a cryptic "Syntax error" in this statement for an Informix database. CREATE TABLE Historial ( id_evento SERIAL PRIMARY KEY CONSTRAINT Historial_claves_primarias, ...
0
votes
0answers
28 views

DATETIME arithmetic in Informix

I have this piece of code in our Informix stored procedure. if (last_date + 2 units second) > CURRENT then raise exception -746,0, "Please try later"; end if I am struggling to understand ...
0
votes
1answer
51 views

Is there a way to connect ODBC datasource in Knexjs

I have my windows 10 pc with ODBC datasource as my_odbc This will connect to my remote informix server. So for I am using this odbc for my local as well as php website development. I want to use ...
1
vote
1answer
159 views

How to connect Informix server using Node js with ODBC connectivity?

I have Linux Enterprise Server 10 SP2(x86_64) - Kernel 2.6.16.60-0.21-smp. I have IBM Informix Dynamic Server Version 11.10.FC1 installed in the above linux server. I have windows 2008 server with ...
0
votes
0answers
48 views

Informix generate query from other query (eval results to SELECT) - PHP and Informix

First, just simple question: Is there something as "EVAL()" function in Informix? And now if anyone is interested there is real world problem where I need EVAL() function: So, I have two tables in ...
-1
votes
1answer
99 views

I have a issue with chart.js, php and infomix database?

Helloi have a problem with chart.js, php and informix database. first i test the script with easy mysql database and they works good. but when im using informix database with pdo he show me on chart ...