Empress Technical Support Corner Depending on the type of data retrieved from a database, XML maps the data in an application and allows it to be processed according to the nature of the data. Using Empress extends XML through the power of Empress Web HTML Toolkit and its PSM feature. The following example shows you how to build a simple XML application. Create and insert the following PSM module: # include char* xml_month (char* value) {   char* xmlvalue;   int length;   length = 50 + strlen (value);   xmlvalue = (char*)spmget (length);   sprintf (xmlvalue, "%s", value);   return xmlvalue; } char* xml_day (char* value) {   char* xmlvalue;   int length;   length = 50 + strlen (value);   xmlvalue = (char*)spmget (length);   sprintf (xmlvalue, "%s", value);   return xmlvalue; } char* small_xml (     char* value,     char* type) {   char* xmlvalue;   if (!strcmp (type, "MONTH"))     xmlvalue = xml_month (value);   else if (!strcmp (type, "DAY"))     xmlvalue = xml_day (value);   return xmlvalue; } Assume the database's Table "Customers" contains: 1* select from Customers; Name Monthly Daily David Steveson Jan. 10th Mark Tumber Mar. 23rd Sharon Stane Dec. 1st Mark Tumber Mar. 23rd Sharon Stane Dec. 1st Executed XML encapsulated PSM module result in: 2* select xml(Monthly, 'Month') PRINT MONTHLY FROM Customers; MONTHLY <MONTH>Jan.</MONTH> <MONTH>Mar.</MONTH> <MONTH>Dec.</MONTH> 3* select xml(Daily, 'DAY') PRINT DAILY FROM Customers; DAILY <DAY>10th</DAY> <DAY>23rd</DAY> <DAY>1st</DAY> This example demonstrates a simple way to create an XML application. For a more complex interface with greater detail, read the HyperAction Volume 7 at Empres website.

Empress exhibits in Red Hat's "Revolution of Choice" Booth V8.20 Debuts at Linux Expo '99 Empress RDBMS V8.20 made its debut to the French market at Linux Expo '99 held in Paris, France on June 17th and 18th.     Bonded by their common hunger for Linux information, over 5000 developers, students, project managers, consultants, and even a few Microsoft spies, lined up to participate in the first ever Linux show in Paris. Participants had the opportunity to attend conferences on the evolution of Linux, web development, Java, security, system integration and more.     In addition to Empress France, over 80 exhibitors supported the show, gathering to demonstrate their Linux solutions and to discover potential customers and future partners. From Compaq, to Hewlett-Packard, to Sun Microsystems, American-based IT giants were among those exhibiting at Linux Expo. Some companies used the show as an opportunity to announce their commitment to Linux and launch Linux based services.     Partnered with Red Hat Software, Empress France showcased the advanced capabilities of Empress RDBMS V8.20 including its threadsafe capabilities, forksafe functions, data streaming and more. Other features include its PHP Interface and XML support, Perl and Tcl/tk interfaces, greater flexibility with a variety of third party tools, and a Category 4 compliant JDBC Interface. A free trial version of the Embedded Empress Developer's Toolkit V8.20 is currently available on Red Hat 6.0's Linux Applications CD (LACD).     Florian Michaud of Empress France states, "Empress is a trusted name in the Linux community. Linux enthusiasts appreciate the over five years of Linux support that Empress has provided as compared to the very new Linux implementations of other database vendors."     After decades of dominance by traditional operating systems, Linux emerges as an interesting and viable option that attracts developers in the French market. For more information about Empress on Linux, contact your Empress representative.

For information on the products or companies covered in this newsletter, please contact Empress Software by telephone, fax, or e-mail, using any of the numbers listed below:

Empress Software Inc. 6401 Golden Triangle Drive Greenbelt, Maryland USA 20770 Tel: (301) 220-1919 Fax: (301) 220-1997 E-mail: sales@empress.com

Empress Software Inc. 3100 Steeles Avenue East Markham, Ontario Canada L3R 8T3 Tel: (905) 513-8888 Fax: (905) 513-1668 E-mail: sales@empress.com