Reputation
474
Top tag
Next privilege 500 Rep.
Access review queues
Badges
5 12
Newest
 Excavator
Impact
~15k people reached

Apr
21
answered Informix help - SQL DBA
Mar
3
revised Joining and combining MySQL tables from Informix
Fix trivial typos
Mar
3
suggested approved edit on Joining and combining MySQL tables from Informix
Dec
18
answered 32 bit vs 64 bit system - Informix Client SDK
Dec
2
comment Extract SYNONYM and SEQUENCE from Informix metadata
No current version of Informix uses syssynonyms; it is a relic from the days of yore — Informix 1.10, 2.00, 2.10 — and has not been used since version 4.00 (there never was a version 3.00 for various good enough reasons at the time, and the time under discussion is 1986-1988).
Nov
4
comment Multiple table rows in one row Informix
@ErnestoCampohermoso: what do you mean "Doesn't work on Informix"? If your version of Informix is so old that the name is written as INFORMIX, then you're right. However, if you install the necessary code for GROUP_CONCAT (as shown in the other question on SO), then it works — or, at least it works for me on the systems I have tested it on. You do have to install the software; I said you have to create the user-defined aggregate. If you've not done that, it won't work, of couse.
Aug
4
awarded  Excavator
Aug
4
revised Informix: is it necessary to update statistics on views?
Fix trivial typos
Aug
3
answered Multiple table rows in one row Informix
Aug
3
comment How can I control the order of a query regarding to inner join
Note that the Informix DATE function returns a value with no time component. Given that the constant is an approximation to an Informix DATETIME YEAR TO FRACTION(3) literal, there is conversion work going on there. It would be helpful to know the type of the a_dt column. The chances are that there are better ways to write that condition, but which is best depends on the type of a_dt. Which version of Informix and which platform you're running on might be relevant. It is always relevant to ask 'have you run UPDATE STATISTICS (or, depending on the version, has the system done it for you)?'
Aug
3
answered Retrieve one of two possible values from 1 table in INFORMIX
Aug
3
comment Retrieve one of two possible values from 1 table in INFORMIX
There's a lot of information missing (like column names). Presumably, this problem is resolved by now in the real world, so there's limited benefit to pointing this on DBA.SE.
Aug
3
suggested approved edit on Informix: is it necessary to update statistics on views?
Aug
3
awarded  Constituent
Jul
28
answered SSRS and Informix connection
Jul
27
awarded  Caucus
May
3
awarded  Informed
Mar
20
answered Informix Server Rejected Connection
Jan
20
answered Informix: is it necessary to update statistics on views?
Jul
28
revised How to join the latest previous record with SQL
Use correct () instead of {} in CREATE TABLE statement; indent body of statement