Here's a fun way to learn about IBM Informix! Learn or teach the basics of Informix Dynamic Server (IDS) and relational databases with an interactive game called "The IDS Detective Game." The game teaches relational database concepts and shows how technology can be applied to solving real-life problems (the game's theme is a crime investigation). The IDS Detective Game is based on the DB2 Detective Game created by Joanna Kubasta and Joanne Moore.

Capture data from an analog environment in real time and store it in an Informix Dynamic Server or DB2 database. Use WebSphere Application Server Community Edition to create graphs of captured data and present them in Java Server Pages. All the steps, including the installation and wiring of the magnetic sensors, the computer interface, the client OLTP code, and the JSP code for presentation of results, are presented in an easy-to-follow format.

Work with IBM Data Studio's Data Web Services and the IBM DB2 and Informix family of databases.

Use the UPDATE STATISTICS statement in IBM Informix Dynamic Server (IDS) to get the moust out of the database optimizer. Get a brief overview of this SQL statement and see how it can be used for a variety of problems. Discover the importance of updating statistics and view illustrations that show how statistics are gathered. Finally, browse a FAQ section at the end of the article to answer any lingering questions you might have about this important SQL statement.

IBM Informix Dynamic Server, Version 11 (IDS 11) has new SQL features. Learn how to use SQL to perform administrative tasks, improve query performance, manage data security, and manipulate data. The eighth in a series of eight tutorials, use this tutorial to help prepare for the IDS 11 exam 918.

Take a complete tour of Data Studio and pureQuery using Informix databases. Learn everything you ever wanted to know about working with your database and building database applications in Data Studio.

IBM Data Studio brings Informix Dynamic Server developers the latest in Web services technology. Learn how this new set of tools makes it easy to design, develop, deploy, and manage your IDS applications. Get started with Web services development using the latest methodology, and also learn how you can simulate a Web service response by converting it to presentable HTML format.

Explore a powerful new feature of IBM Informix Dynamic Server (IDS) called "named parameters in a CallableStatement," which enables you to identify a parameter using its name instead of its ordinal position. This feature thus extends the capability of using CallableStatements so that they can be used either by ordinal position or parameter name. Learn the difference between the two techniques, and see the advantages of named parameters over the ordinal technique.