Author: SSWUG Research

Community

Exporting DB2/400 Dates to Excel

(Jeff Haddix) In order for Microsoft’s Excel spreadsheet to recognize the set of values for a column as dates, those values must be stored as a number of days. For example, to export the date December 26, 2006, to an Excel spreadsheet, you should export the number 37,066, not a date value like 12/26

Community

D.I.Y. MySQL 5.1 monitoring

(Guy Harrison) I wrote recently about using events and the new processlist table in MySQL 5.1 to keep track of the number of connected processes. Although having the PROCESSLIST available as an INFORMATION SCHEMA table is usefull, it seemed to me that having SHOW GLOBAL STATUS exposed in a similar