Questions tagged as 'informix'

Tagged questions
1
answer

Update a field in the database

I have the following table in informix: CREATE TABLE eh_user ( user_key serial NOT NULL, borrado boolean DEFAULT f NOT NULL, fecha_alta datetime DEFAULT current NOT NULL, propietario varchar, fecha_modificacion datetime,...
asked by 05.10.2018 / 11:38
0
answers

Rename stored procedure columns Informix 7.x

I have a procedure stored in informix 7.x, it is called in Nhibernate using the CreateSQLQuery method. The problem is that all the columns returned by the stored procedure have the same name "expression" and when the procedure is called you c...
asked by 15.08.2018 / 17:53
1
answer

Problem to reference keys in IBM informix [closed]

My situation is as follows. Structure: Grupo (GrupoId, GrupoNombre) Asignatura (AsignaturaId, AsignaturaNombre) GrupoTieneAsignatura (GrupoId, AsignaturaID) Planilla(GrupoId(de grupotieneasignatura), AsignaturaID(de grupotieneasignatura), otro...
asked by 03.11.2016 / 22:12
1
answer

Assert Failed: yield_processor: Stack overflow in thread ... in informix [closed]

Assert Failed: yield_processor: Stack overflow in thread .... in informix. How do I prevent this from happening so that I do not download the informix engine?     
asked by 11.11.2016 / 20:48
2
answers

Informix PDO and XAMPP

Greetings to all and in advance thanks to any answer and / or help you may receive. I have problems connecting PHP 5.6.24 of XAMPP to an INFORMIX server that is not on my local machine. Install the Informix CSDK, I made the respective conf...
asked by 03.02.2017 / 14:06
1
answer

How to read resource (2) of type (stream) with PDO_INFORMIX?

I have a problem with the return of the information I perform with PDO_INFORMIX , then I show you my case: 1. Database: INFORMIX 2. Schema: -Table: cartas -Campos: |id | codigo | titulo |cont...
asked by 27.12.2017 / 23:32
1
answer

SQL query that returns dates that do not exist in the result of the query itself

I am working with a database in Informix. I access it from a web application developed with C #. In a table called MC_turnosAgenda I have several records, of which I want to obtain only the date field, using DISTINCT to obtain only once each...
asked by 10.07.2017 / 20:07
1
answer

Perform a query in SQL avoiding multiplicity [closed]

I have a table Producto and a table Proveedor (are related by campoidProducto ). In this particular case I want a query that results in all the products, and for each product show a provider (a product can have several p...
asked by 13.06.2017 / 07:03
0
answers

Divide data obtained from the database

I have a problem when I get the data from the database, I get 4500 rows or more depending on the search and this data is distributed among 8 people trying to be fair. This is the data I get: The important column is codi_zona s...
asked by 01.06.2017 / 22:38
2
answers

Error printing a text type record in php using pdo and informix

Friends please, I need help, Until yesterday, I did not have a problem printing records that I have in my informix database from php using pdo. But yesterday I came across a type registry (text), and it printed me (resource id #) As I said any o...
asked by 08.12.2016 / 15:18