With Oracle announcing end of life for IBM i distributions of MySQL, I'll discuss the potential for alternatives of MySQL on the i.
Written by Tom Snyder
Oracle has decided to no longer support MySQL on the IBM i, and I for one am very disappointed in this recent announcement. When I first heard that you could run MySQL on the IBM i, I initially thought to myself, "Why would I want to use the MySQL database when I have DB2?" In this article, I intend to tell you why you would want to and why it's such a loss that Oracle will no longer be providing IBM i binaries. I'll also explain some of the options that we have without it.
In the December 2010 "API Corner" article, "Still Using Compile-Time Arrays?", we looked at one approach to removing compile-time arrays containing textual information from a program. The text removed was being used to display the status of an order (order canceled, order shipped, etc.) to the user of an inquiry program. In this article, we will review one way to access the text that is to be displayed by the use of a message file (*MSGF) and a procedure being exported by a message support service program (*SRVPGM).