Questions tagged as 'informix'

Tagged questions
1
answer

Difference in use Unique and Unique Constraint index in Informix?

I would like to know what behavior / differences between a Unique Index and Unique Constraints for Informix ?     
asked by 21.12.2013 / 21:39
1
answer

Authentication Difficulty in InformDisk BD

I need to develop a small report on a legacy basis with Informix database (this is the first time I work with Informix). But I'm having trouble connecting. I'm getting the following error:    Connection failed: Incorrect password or user c...
asked by 03.04.2014 / 14:07
2
answers

Insert multiple rows in Informix

I use an Informix database and I have to do 3500 inserts. Informix runs line by line and this is impractical. How do I insert all the rows at once? Example: insert into tabela (coluna1, coluna2, coluna3) values (valor1, valor2, valor3) insert...
asked by 05.04.2018 / 17:12
1
answer

Define the size of the field return

I have a sql: Select a.nome From tabela a I want to return the name, but suppose my name field has Varchar size (100), but I want to return the first 50 characters. Edit: Is for IBM Informix     
asked by 28.05.2015 / 16:44
0
answers

Exporting informix data

I'm developing an application based on data from an ERP. This ERP uses the INFORMIX database whose file export pattern is DELETED BY PIPES AND WITHOUT TEXT QUALIFICATION. I need to import the data from Informix to MySQL, but must have all fie...
asked by 14.09.2017 / 16:03
1
answer

Add multiple fields from the same table in the same query

I have an "X" table with several fields and one of the fields is "date" and the other is "type". In the same query I need to return the following: - Number of registrations in April - Number of records in April with type 1 - Number of reco...
asked by 20.05.2015 / 17:36
1
answer

Informix bank hours calculation

I am a beginner in bank Informix , and I am having difficulty calculating the difference between hours in a query. For the calculation, the fields hrinicio and hrfim should be used Query I tried: select *,((DATE...
asked by 15.08.2017 / 22:17
1
answer

RANDOM function in IBM Informix BD?

I need to use a random () function in SQL in an Informix database version 11.50. However in the select below it returns syntax error: select random(), codigo from minha_tabela; 674: Routine (random) can not be resolved. Error in line 1 Near...
asked by 29.03.2014 / 22:35
1
answer

Connect Informix .NET via DSN

Good afternoon, I've been trying to connect an application to an Informix database for some days, but I can not do it at all. I'm using Visual Studio 2017 using ASP.NET Framework 4.6. I tried to find solutions on the IBM site, but that sit...
asked by 05.11.2018 / 14:58
1
answer

______ qstntxt ___

I'm doing this query, and I need to check the cost value of a product using a subquery, because the note table is the same as input and output. Products do not repeat. What sets sales apart and cost. It's the note series. It is returning the cost as null. But if I include a product code manually. It works.

Structure: %code%

%pre%

How it works:

%pre%     
______ azszpr247706 ___

You must specify the resultset fields. Please try the modification below:

%pre%     
___

I'm doing this query, and I need to check the cost value of a product using a subquery, because the note table is the same as input and output. Products do not repeat. What sets sales apart and cost. It's the note series. It is returning the cos...
asked by 20.10.2017 / 01:10