Informix: Sysmaster queries
I'm in a sharing mood today, so let me post a link I discovered while looking for some informix sysmaster queries.

I'm in a sharing mood today, so let me post a link I discovered while looking for some informix sysmaster queries.
timestamp, data types, database
The TIMESTAMP datatype in MySQL has some nice features which aren't well known. It's a datatype used to store a date-and-time value.
If you try to use dbaccess on the command line, it might not work properly if your TERM is configured badly.
I recently encountered a problem where we had accidentally created a new database in the root dataspace. We only found out about this after receiving a lot of out-of-space errors. Here is how we moved it to the proper dbspace.
When you want to connect from one database to the other, you have to make sure that both databases have the same log settings. When creating a database you can choose to do so with log, with buffered log or without log.