 | Level: Introductory Pamela Siebert (psiebert@us.ibm.com), Staff Software Engineer, IBM
Venkatesh Gopal (gopalv@us.ibm.com), Senior Software Engineer, IBM
15 May 2008
Updated 09 Apr 2009 Get an introduction to IBM® Data Studio and the IBM Data
Studio Developer offering, and see how IBM Data Studio Developer 2.1 can be
used to develop applications with Informix® Dynamic Server
(IDS).
Before you start
About this
tutorial
In this tutorial, walk through setting up Data Studio Developer 2.1 to
work with IDS. Learn how to expose database operations as Web
services, see how to work with basic database objects, SQL statements,
and stored procedures, and get an introduction to pureQuery, an
innovative approach to building high-quality, better-performing Java
database applications. This tutorial also describes the IBM Data
Studio offering in some detail.
Objectives
When you've completed this tutorial, you'll:
- Be familiar with Data Studio Developer 2.1
- Know how to set up Data Studio Developer 2.1 to connect to
IDS
- Be able to create a Data Web Service with IDS
- Know how to create a pureQuery application with IDS, and use some
of the pureQuery features such as SQL performance statistics and
heterogeneous batching
Prerequisites
This tutorial assumes that you have:
-
Data Studio Developer 2.1 FP1
and WebSphere Community Edition 2.x installed. (You can get the
WebSphere CE code as part of the Data Studio Developer 2.1
installation, or you can
download
it.)
- At least a basic working knowledge of Eclipse-based IDEs.
- Informix Dynamic Server 11
installed and a basic working knowledge of IDS.
- Downloaded the sample database used in this tutorial, the GSDB
database (see Download).
System requirements
To run the examples in this tutorial, you need a Windows XP system with
IBM Data Studio Developer 2.1 installed, with IBM Data Server Driver
for JDBC and SQLJ, and an Informix server (local or remote).
Optionally, an Informix JDBC driver (Version 3.00.JC3 or later) can be
used instead of IBM Data Server Driver for JDBC and SQLJ. This
tutorial uses the GSDB database, which is available in the
Download section.
You must use the sample database named GSDB. Follow these steps to
create the database:
- Get the zip file from the Download
section of this article, and extract the files from it. You will
see three files (createGSDBv1.2.bat, createGSDBv1.2.sh, and
GSDBv1.2.sql) and an xml folder.
- Bring down the IDS server if it is already up.
- Set the DBDATE variable to Y4MD.
- Set the SBSPACENAME value to sbspace in the onconfig file.
Alternatively, you can either edit createGSDBv1.2.bat or
createGSDBv1.2.sh if you want to use a different SBSPACENAME
value.
- Bring up the IDS server
- Run createGSDBv1.2.sh or createGSDBv1.2.bat, respectively.
| |
