Informix LOAD FROM file with header
No; there isn't a way to tell standard Informix LOAD to skip a header line. Note, too, that it won't remove quotes from around fields in CSV format and otherwise deal with things the way CSV format officially expects (though, since you have semicolon-separated values rather than comma-separated values, it...
Error running command oninit -i for Informix on Ubuntu Server
informix,ubuntu-10.04,ubuntu-server,informixdb
What is the setting of $INFORMIXSERVER in your environment, and what values are set for DBSERVERNAME and DBSERVERALIASES in the $ONCONFIG file? It seems that you've set $INFORMIXSERVER to a value that isn't present in the $ONCONFIG file that is in use. Maybe you didn't set $ONCONFIG at all, or...
NHibernate error accessing Informix database - System error occurred in network function
hibernate,nhibernate,fluent-nhibernate,informix,informixdb
After studies in the customer environment and logs it was found that the error occurred due to completion of a backup in a certain schedule that caused instability in the bank resulting in connection error and after that the the application did not work properly need to be restarted (the...
Informix using a subquery
Presumably this is what you want: select first 1 * from table t order by date desc, time desc; The problem is that you cannot use this as a subquery unless it is the in from clause. A simple way to accomplish this is something like: select . .. from...