 | Level: Intermediate Sonali Surange (ssurange@us.ibm.com), pureQuery Tools Lead, IBM
Mark Jamison (mjamison@us.ibm.com), Premium Support Analyst, IBM
28 Feb 2008 Learn everything you ever wanted to know about working with your database and building applications in Data Studio — all in 40 minutes. Objectives - Start with an Informix table and create a pureQuery data access layer.
- Customize the pureQuery data access layer.
- Create pureQuery application development around the customized SQL.
- Propose database schema from a bean.
- Create an Informix SQL procedure.
- Create pureQuery data access for the procedure.
- Join results SQL queries to Informix database with Java objects.
Prerequisites
It is assumed that you will use the Informix 11.0 server in this
tutorial. However, you can also use this tutorial with
Informix 10.0. You must install and configure the
DEMOXML database. Follow the steps listed below:
- Run the script attached to this tutorial.
-
Ensure that you initialize your
Informix server settings as listed at http://www.iiug.org/devnews/.
System requirements
This tutorial can be used with the IBM® databases — IBM DB2® for Linux®, UNIX®, and
Windows®, zSeries®, and iSeries®, as well as IBM
Informix® Dynamic Server (IDS). Furthermore, the Eclipse environment is IBM Data Studio V1.1.
Duration
Formats html, pdf
Tutorial overview
In this tutorial, take a tour of Data Studio and pureQuery using Informix Dynamic
Server (IDS). Easily work with Informix databases and build Java™ database applications using numerous unique scenarios. Learn how to productively customize SQL inside your Java program and create your own data access layers for Informix.
| | | |
