DB2 Web Query Tool version 1.2 / Lijun (June) Gu.

Format:

Book

Contributor:

Gu, Lijun.

International Business Machines Corporation. International Technical Support Center.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Relational databases.

SQL (Computer program language).

IBM Database 2.

Physical Description:

xviii, 180 p. : ill.

Edition:

1st ed.

Place of Publication:

[S.l.] : IBM, International Technical Support Organization, 2002.

Language Note:

English

Contents:

Front cover

Contents

Figures

Tables

Notices

Trademarks

Preface

The team that wrote this redbook

Notice

Comments welcome

Chapter 1. Introduction

1.1 Data management tools

1.2 Objectives and contents of this redbook

1.3 April, 2002 announcement

Chapter 2. Introducing DB2 Web Query Tool

2.1 Overview

2.2 Architecture

2.2.1 Environment

2.2.2 Interfaces

2.3 What to order and install

2.4 Integration with other tools

2.5 What's coming in DB2 Web Query Tool V1.3

Chapter 3. Installation and configuration of WQT

3.1 Installing DB2 Web Query Tool for Multiplatforms

3.1.1 Prerequisites

3.1.2 Installing DB2 Web Query Tool

3.1.3 Installation of IBM DB2 Web Query Tool Catalogs

3.1.4 Configuration of Web Query Tool

3.2 OS/390 system setup

3.2.1 Prerequisites

3.2.2 Installation tasks

3.2.3 Allocating and mounting an HFS dataset

3.2.4 Copy the file to the directory and untar it

3.2.5 Set Permission bits for file access

3.2.6 Install the DB2 Web Query Tool Catalog

3.2.7 Configure DB2 Web Query Tool

Chapter 4. Using DB2 Web Query Tool

4.1 Launching DB2 Web Query Tool

4.1.1 Launching DB2 Web Query Tool in a browser

4.1.2 Logging onto DB2 Web Query Tool

4.2 Disconnecting from a DB2 database

4.3 Terminating administrative connections

4.4 Logging out of DB2 Web Query Tool

4.5 Using DB2 Web Query Tool

4.5.1 Using DB2 Web Query Tool online help

4.5.2 Using the DB2 Web Query Tool interface

4.5.3 Connecting to a DB2 database

4.5.4 Working with filters

4.5.5 Working with queries

4.5.6 Working with results sets

4.5.7 Working with categories

4.5.8 Working with groups

4.5.9 Working with SQL IDs

4.5.10 Working with DB2 tables

4.5.11 Working with DB2 Table Editor forms

4.5.12 Working with compare sessions.

4.5.13 Setting up catalog objects

4.5.14 Working with log files

4.6 Integrating Table Editor and Web Query Tool

Appendix A. JDBC connection to DB2

A.1 A brief introduction to JDBC

A.2 JDBC and OS/390

A.3 Verifying JDBC connectivity

Appendix B. Troubleshooting

B.1 General troubleshooting

B.2 Common issues

B.3 Multiplatform specific issues

B.4 z/OS and OS/390 specific issues

B.5 Determining the Web Query URL

B.6 Viewing Web Query error messages

B.7 Cannot expand the SQLQueries branch

B.8 There is no Save option in Edit Query page

B.9 Cannot display the XML result in WQT directly

B.10 Cannot send the result to an e-mail address

B.11 Cannot open the downloaded MS Excel file

Related publications

IBM Redbooks

Other resources

Referenced Web sites

How to get IBM Redbooks

IBM Redbooks collections

Index

Back cover.

Notes:

"October 2002."

Includes bibliographical references and index.

OCLC:

560313648