Before you start
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.
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
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).
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.