Most voted "informix" questions
Informix is a RDBMS is owned by IBM. However, it has a range of development products that are part of the Informix family. RDBMS has hybridized capability of OLTP and OLAP (In Memory), SQL and Nosql accesses (Mongodb-compatible accesses), all in the same configuration. In addition to other features of clustering, replication, timeseries, Geodata, text search, among other resources.
Learn more…20 questions
Sort by count of
-
9
votes1
answer584
viewsDifference in Indice Unique and Unique Constraint usage in Informix?
I would like to know the behavior/differences between a Indice Unique and Unique Constraints to the Informix ?
-
3
votes1
answer160
viewsAuthentication difficulty in BD Informix
I need to develop a small report on a legacy basis with Informix bank (this is the first time I work with Informix). However I am having difficulty connecting. I am getting the following error:…
-
2
votes1
answer221
viewsAdd 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…
-
2
votes1
answer258
viewsSet the field return size
I have an sql: Select a.nome From tabela a I want to return the name, but imagine my name field is size Varchar(100), but I want to return the first 50 characters. Edit: It’s for IBM’s Informix…
-
2
votes2
answers213
viewsInsert multiple lines into Informix
I use a Informix bank and I have to do 3500 Inserts. Informix runs line by line and this is impractical. How do I insert all lines at once? Example: insert into tabela (coluna1, coluna2, coluna3)…
-
1
votes1
answer341
viewsFunction RANDOM in IBM Informix BD?
I need to use an Random() SQL function in a Informix version 11.50 database. But in select below returns syntax error : select random(), codigo from minha_tabela; 674: Routine (random) can not be…
-
1
votes1
answer246
viewsCalculation of hours in Informix bank
I’m a beginner in banking Informix, and I’m having difficulty calculating the difference between hours in a query. For the calculation, the fields hrinicio and hrfim should be used Query I tried:…
informixasked 7 years, 4 months ago Eduardo Santos 754 -
1
votes0
answers77
viewsExport data from Informix
I’m developing an application based on the data of an ERP. This ERP uses the INFORMIX database whose file export standard is BOUNDED BY PIPES AND WITHOUT TEXT RATING. I need to import Informix data…
-
0
votes1
answer579
viewsHow to transform a query output into xml in Informix?
It is possible to take any output of a query directly from the bank and bring the result already formatted in XML text ? This using IBM Informix v11.50 database and natively in the database. Where…
-
0
votes1
answer82
viewsCreate ODBC Informix data source
Problem: I need to register a INFORMIX data source and I’m not getting it. I enter the parameters, but always error occurs. What should I do?…
-
0
votes0
answers66
viewsSyntax error in Informix database query
I made a prototype of a database informix in the Access to optimize the construction of my queries. I use with the Mysql and through some adaptations in the syntax I get a good. But in the…
-
0
votes3
answers1209
viewsSum hours of an array
I need to total the column hora_agente of the kind time. And I need the return value to be in hours. May be greater than 24 hours. In the example I did, it’s returning 5:55, and it should return…
-
0
votes1
answer30
viewsQuery does not return setted WHERE
I am trying to perform a query to the Informix Database, and it is bringing the data in normally, but it is ignoring the search criteria. SELECT cnnfcapa.id_nfcapa, cnnfcapa.filial,…
-
0
votes0
answers52
viewsSubquery in Informix Bank
I have an appointment that seeks sales of a period: SELECT cxpdvend.filial, cxpdvend.dtpedido, cxpdvend.pedvenda, ciendere.nro_endere, cipessoa.nomepessoa, ciendere.celular, cxpdvend.codagente,…
-
0
votes1
answer47
viewsSubquery returning null value
I am doing this query, and I need to query the cost value of a product using a subquery, because the note table is the same as input and output. The products do not repeat. What differentiates sale…
-
0
votes1
answer19
viewsConsult a field with datetime year to Second format, asking to bring only today’s records?
I would like to know how to fetch a date record, but bring this dat_entrada only with the current date? Follow the query: select a1.cdg_filial Filial, a1.cdg_fornecedor Fornecedor, a2.dcr_fornecedor…
-
0
votes1
answer89
viewsConnect Informix . NET via DSN
Good afternoon, I have been trying for days to connect an application to a Informix database, but I can not at all. I am with Visual Studio 2017 using ASP.NET Framework 4.6. I tried to find…
-
0
votes1
answer156
viewsSql Father and Children in the Same Table
I have the following question, I have a table in the bank that cannot be changed to facilitate the process. In this table I have records parents and children with the possibility of up to 8 levels.…
-
0
votes1
answer39
viewsList Database Result by Rows and Columns
I have the following problem, I need to create a report with data coming from the database, listed by rows and columns, in the format below: +----------+-----------+-----------+-----------+ | |…
-
-1
votes1
answer123
viewsHow to give Count up to a limited value, "countar up to 90 on a table that has 100"
I assembled the following Query - "INFORMIX" SELECT COUNT(1) FROM (SELECT * FROM NOTA_FISCAL_NFE LIMIT 90); Which returns me the following error: An error occurred when executing the SQL command:…