Posts by ceinmart • 860 points
16 posts
-
1
votes2
answers213
viewsA: Insert multiple lines into Informix
Unfortunately Informix does not have a DML command for insert on-mode batch/Bulk as in mysql . Batch load options are from TXT file using delimiters (which by default, in Informix is pipe "|" but…
-
1
votes1
answer246
viewsA: Calculation of hours in Informix bank
When it comes to database, regardless of which database is always informed version, it makes a lot of difference because the BD has evolved a lot and has a lot of database installed with extremely…
-
1
votes1
answer160
viewsA: Authentication difficulty in BD Informix
Apparently you are giving the wrong password to the Informix user. If you want to free access, "no password", you need to set your host to reliable. This can be done in some ways, but it depends on…
-
0
votes1
answer579
viewsQ: How 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
answer579
viewsA: How to transform a query output into xml in Informix?
From Seat 11.10 it is possible yes. To find out which version of the database you are using, run this SQL: select dbinfo('version', 'full') from systables where tabid = 1; There are some specific…
-
1
votes1
answer341
views -
1
votes1
answer341
views -
-1
votes3
answers4703
viewsA: How do a select pick up 8 lines in a row or more where there are common values?
This code is ugly but simple and functional under the data passed as example. Uses variables to control repeat record Qtde. I didn’t try to vary the data, but I believe I should meet your need,…
-
2
votes2
answers1414
viewsA: How to give automatic permissions in shell script
Alternative to option -p in the @asfelix response is to use the command rsync for copying. rsync copies and keeps Owner, group, permissions and file dates equal to the original (with the option -a)…
-
4
votes3
answers9148
viewsA: Query in two tables without INNER JOIN
This answer may not be correct for this case, but I think it valid to share knowledge. What is my knowledge and experience, using the INNER JOIN in fact you are tying the search and filter method…
-
6
votes2
answers3573
viewsA: Competing transactions in Mysql
I agree with @mlemos, you should never work with LOCK TABLES in applications, except for very specific situations. For situations like this, you need to know a little bit about the bank’s…
-
3
votes8
answers26648
viewsA: How to backup Mysql Database Diaries?
I am not an expert in Mysql, but here is my answer, being a little more simplistic, and I believe more correct too. To perform a backup with the online bank it is necessary to have the Binary log…
-
9
votes1
answer584
viewsQ: Difference 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
answer584
viewsA: Difference in Indice Unique and Unique Constraint usage in Informix?
Many may think that it makes no difference in the database, but it does! And not only for the DBA/Administrator, but also for the developers because it can influence how a code is written. I work a…
-
16
votes2
answers2309
viewsQ: Difference in Indice Unique and Unique Constraint usage in Sql Server?
I would like to know the behavior/differences between a Indice Unique and Unique Constraints to the Sql Server ? Many may think that it makes no difference in the database, but it does! And not only…
-
20
votes3
answers17226
viewsQ: Difference in Index Unique and Unique Constraint usage in Mysql?
I would like to know the behavior/differences between a Indice Unique and Unique Constraints to the Mysql ? Many may think that it makes no difference in the database, but it does! And not only for…