IBM United States
Software Announcement 202-052
March 5, 2002

DB2 for IBM eServer iSeries Platform Extended with Enhanced Tools

 ENUS202-052.PDF (34KB)

(Corrected on May 14, 2002)

Changes in the following sections:

  • At a Glance and Description: List of platforms supported by DB2 Web Query Tool modified.
  • Publications: URL updated
  • Terms and Conditions: Software Maintenance and Support Line sections changed to "No" and "Yes," respectively.

At a Glance

  • DB2 Table Editor for iSeries, V4.3
    • Gives database experts tools to perform table editing tasks across multiple databases and platforms
    • Provides for general data entry
    • Allows customer information self-service via the Web
    • Enhances support for large objects
    • Supports new types of forms
  • DB2 Web Query Tool for iSeries, V1.3
    • Connects Web-based users to multiple enterprise database platforms simultaneously
    • Uses any client via JDBC connection and Web browser
    • Supports large objects

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).

Overview

In September 2001, the IBM Data Management team delivered on the first phase of its multiplatform tools strategy that included DB2® Table Editor for iSeries, V4.2 and DB2 Web Query Tool for iSeries, V1.2.

The offerings are expanded further with enhanced tools for iSeries:

  • DB2 Table Editor for iSeries, V4.3

    Quickly and easily updates, creates, and deletes data across multiple DB2 database platforms

  • DB2 Web Query Tool for iSeries, V1.3

    Connects Web-based users directly to multiple enterprise databases — securely and simultaneously — regardless of database size, hardware, operating system, or location

Key Prerequisites

IBM eServer iSeries

Planned Availability Date

July 26, 2002

Description

DB2 Table Editor for iSeries, V4.3

DB2 Table Editor lets you easily support your business processes, and empower novice end users, with customized task-specific table editing forms. Database experts get a robust set of tools to perform ad hoc table editing tasks across multiple databases and platforms. Since end users only need a browser, the solutions you choose to create with DB2 Table editor have maximum reach.

DB2 Table Editor makes it possible to provide direct DB2 database access to anyone, for creating, reviewing, or updating data. Task-specific forms restricted to specific data and actions can be quickly built and rolled out to novice end users An expert interface can be used for browsing existing databases and ad hoc actions.

A Java™-enabled browser is all you need on the client machine for using DB2 Table Editor solutions.

Wizards and a drag-and-drop Windows® environment let you quickly develop table editing forms, which, like mini-applications, are suitable for a wide variety of common business tasks.

Data filtering, business and data access rules, database connections, command buttons, and dialogs are embedded directly in the forms (which can be optionally placed in existing Web pages) so end users can focus on their work instead of database technicalities.

DB2 Table Editor supports multiple DB2 database platforms, mission-critical DB2 features such as existing DB2 security and referential integrity, and advanced DB2 features like large object support. Customers who need to safely provide data editing and data entry capabilities to end users at the front lines of a business or to database administrators will find DB2 Table Editor a valuable offering.

New with V4.3

  • Edit with Formulas — With Table Editor, apply a formula to change a column value in one or more rows.
  • Usability enhancements:
    • When editing data, the input text size is limited by the column datatype and definition
    • The thousands separator is now displayed in numeric columns
    • Provides the ability to migrate forms from test to production environment (list and change tables used)
    • For form layout forms, position on last row of result set after reaching the end
    • Provides the ability to lock columns for list control
    • Provides the ability to work with tables with ROWID columns
    • Object list window that can stay open (Windows only)
    • Support for refer back in validation rules
  • Enhanced Support for LOBs: A new button — Launch LOB — supports the association of a file extension/program for a LOB column. There is also an enhanced internal LOB control that can display additional LOB data types.
  • Previous Row Support: The Table Editor Java player now supports the Previous Row button.
  • Support for New Types of Forms: Table Editor allows you create a form without having to associate it with a primary table. This new feature allows you to build new types forms. For example, you can create a "menu form" that simply controls the launching of other forms.

Note that DB2 Table Editor for iSeries, V4.3 replaces DB2 Forms for AS/400®, V2 (5697-G14).

DB2 Web Query Tool for iSeries, V1.3

When any part of your business operations require faster, more creative, or more complex data operations, DB2 Web Query Tool is the authoring environment to turn to. Web Query Tool's advanced SQL functionality extracts the full performance out of DB2 databases while making it easy for users at all levels to access enterprise-wide data. Wherever data access and data integration can bring value, DB2 Web Query Tool can deliver that value.

DB2 Web Query Tools are capable of accessing DB2 data on z/OS™, iSeries, AIX®, Linux, Windows, HP-UX, and Sun platforms. The products run on Web servers, which need not be on the same platforms as the database servers. For example, to access DB2 database data on iSeries, you need the DB2 Web Query Tool for iSeries. To access DB2 database data on z/OS, you need DB2 Web Query Tool for z/OS. The code for all listed Web server platforms is included as part of each DB2 Web Query Tool.

With Web Query Tool customers can:

  • Connect Web-based users directly to multiple enterprise database platforms and brands simultaneously, regardless of database size, hardware, operating system or location
  • Maintain existing DB2 security and support multiple DB2 database platforms all from one tool
  • Provide instant global access to business information over multiple e-mail clients including WAP-enabled devices like cell phones, PDAs, text pagers
  • No special client software is required. Operates for any client via JDBC connection and a web browser.
  • Build, test and share even the most complex queries with an intuitive interface
  • Enable complex querying, data comparisons and customized presentation
  • Explore database objects, including tables and views
  • Leverage advanced SQL and query building features, such as multiple SQL statements, parameterized variables, and DB2-specific SQL
  • Make it easy to view, download, import and convert query results to diverse file formats, including HTML, XML/XSL, .TXT, and .CSV files for use on other databases and desktop applications
  • Perform other data conversion tasks, such as omitting columns from a dataset or imposing new datatypes
  • Import data from XML and other files, and use to create new or append to existing tables
  • Minimize application maintenance, and leverage the intranet or Internet for database connectivity

New with V1.3

  • J2EE Support: Web Query is now a J2EE compliant web application. As such, it can now be deployed on WebSphere® V4.
  • Shared Catalog: To avoid having to set up a separate catalog at each location/connection, you can choose to share saved objects (queries and results) in a Web Query catalog. Objects saved in a shared catalog can be directed to run at any connectable database server.
  • Usability Enhancements: A number of usability enhancements are included in this new release including the ability to save and reuse settings and filters, additional filter specification (including case sensitive filters), a streamlined query execution path, and context sensitive help. An SQL assistant component is also included, which helps less technical users write and run queries.
  • Server-side XSL: Server side XSL transformations are now applied to the generated XML/XSL data, which removes all requirements for client side XML translation software components.
  • Stored Procedure Support: A DB2 stored procedure can be run by selecting it from the Web Query object tree. You can also run a stored procedure by specifying a CALL statement in your query.
  • Web Services (SOAP): A saved query can be published as a SOAP service that any SOAP requester can access.
  • Scalable Vector Graphing: Result sets can be transformed to graphs/charts using the Scalable Vector Graphics (SVG) model.
  • Large Object Support: You can retrieve LOB data in Web Query. Web Query can also launch the appropriate viewing application to render the LOB data (picture, video, audio, etc.).

Euro Currency

These programs are not impacted by euro currency.

Trademarks

 
iSeries is a trademark of International Business Machines Corporation.
 
The e-business logo and z/OS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, AS/400, AIX, and WebSphere are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a registered trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.

Education Support

Visit Web site:

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

Displayable Softcopy Documentation

For DB2® Table Editor for iSeries, V4.3: README.TXT file with information on how to install the product and the DB2 Table Editor Control Center Plug-in. On line HELP is included.

The following publications are not available in hardcopy form. They are available for download in both PDF and BookManager® formats on the Web site:

                                             Identification
Title                                        Number
 
Concepts and Components                      SC27-1644
Installation and Customizing                 SC27-1646
DB2 Table Editor User's Guide                SC27-1616
DB2 Web Query User's Guide                   SC27-0971

Technical Information

Hardware Requirements

These products will operate on any hardware IBM eServer iSeries configuration that supports the required version of a DB2 Server.

Software Requirements

These products will operate on any software iSeries configuration that supports the required version of DB2.

Planning Information

Direct Customer Support: Direct customer support is provided by IBM Operational Support Services — Support Line. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Support Line can help answer questions pertaining to usage and suspected software defects for eligible products.

Installation and technical support is provided by Global Services. For more information call 800-IBM-4YOU (426-4968).

Packaging: Both products are packaged as Media Packs containing the following:

  • Program code on CD-ROM
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information

Softcopy documentation is provided on the Internet.

Security, Auditability, and Control

The security and auditability features of User Identification and Password Management for these products are developed in concert with DB2 security.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Ordering Information

Each product has a single charge unit of "Processor Group."

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration, the appropriate charge feature numbers and quantities, and the feature number of the desired distribution medium.

                                   Processor-
                                   Based
                                   OTC(1)
                                   Feature        Group
Description                        Number         Number
 
Medium CD-ROM
 
Medium Feature Number 5809
 
DB2 Table Editor for               0001           P05
 iSeries V4.3                      0002           P10
 Program Package                   0003           P20
 (5697-G84)                        0004           P30
                                   0005           P40
                                   0006           P50
 
Processor Group Migration
  P5 to P10                        0007
  P5 to P20                        0008
  P5 to P30                        0009
  P5 to P40                        0010
  P5 to P50                        0011
  P10 to P20                       0012
  P10 to P30                       0013
  P10 to P40                       0014
  P10 to P50                       0015
  P20 to P30                       0016
  P20 to P40                       0017
  P20 to P50                       0018
  P30 to P40                       0019
  P30 to P50                       0020
  P40 to P50                       0021
 
DB2 Web Query Tool                 0001           P05
 for iSeries V1.3                  0002           P10
 Program Package                   0003           P20
 (5697-G85)                        0004           P30
                                   0005           P40
                                   0006           P50
 
Processor Group Migration
  P5 to P10                        0007
  P5 to P20                        0008
  P5 to P30                        0009
  P5 to P40                        0010
  P5 to P50                        0011
  P10 to P20                       0012
  P10 to P30                       0013
  P10 to P40                       0014
  P10 to P50                       0015
  P20 to P30                       0016
  P20 to P40                       0017
  P20 to P50                       0018
  P30 to P40                       0019
  P30 to P50                       0020
  P40 to P50                       0021
1
One-time charge

Basic Machine-Readable Material for iSeries Products: The environment for the following products in this announcement is OS/400®. The Distribution feature numbers are listed in the following table.

                                   Feature        Distribution
Product                            Number         Medium
 
DB2 Table Editor for               5809           CD-ROM
 iSeries, V4.3 (5697-G84)
DB2 Web Query Tool for             5809           CD-ROM
 iSeries, V1.3 (5697-G85)

Customization Options: Select the appropriate feature numbers to customize your order with delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number
 
Initial Shipments
 
Ship media only (suppresses initial                 3470
 shipment of documentation)
 
Ship documentation only (suppresses                 3471
 initial shipment of media)
 
Expedite Shipments
 
Local IBM office expedite                           3445
 (for IBM use only)
 
Customer expedite process charge                    3446
 ($30 charge for each product)

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.

Terms and Conditions

Licensing: IPLA. Proofs of Entitlement are required for all authorized use.

The following agreements apply for maintenance and do not require customer signatures:

  • IBM Agreement for Acquisition of Support (Z125-6011)
  • Addendum for Support (Software Maintenance) for Select iSeries and pSeries Programs (Z125-6495)

Limited Warranty: Yes

Program Services: Available until November 30, 2004

Money-Back Guarantee: 30-day, money-back guarantee, applicable to the first instance per customer enterprise. The money-back guarantee will commence on the invoice date.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Software Maintenance Applies: No

For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.

IBM Operational Support Services — Support Line: Yes

AIX®/UNIX® Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

iSeries Software Subscription Applies: Yes

Variable Charges Apply: No

Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers

Prices

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

                                Processor-
                                Based
                                OTC
                                Feature     Group
Description                     Number      Number     OTC
 
DB2 Table Editor for            0001        P05       $  700
 iSeries, V4.3                  0002        P10        1,000
 Program Package                0003        P20        4,000
 (5697-G84)                     0004        P30        4,400
                                0005        P40        6,700
                                0006        P50        7,000
 
Processor Group Migration
  P5 to P10                     0007                     300
  P5 to P20                     0008                   3,300
  P5 to P30                     0009                   3,700
  P5 to P40                     0010                   6,000
  P5 to P50                     0011                   6,300
  P10 to P20                    0012                   3,000
  P10 to P30                    0013                   3,400
  P10 to P40                    0014                   5,700
  P10 to P50                    0015                   6,000
  P20 to P30                    0016                     400
  P20 to P40                    0017                   2,700
  P20 to P50                    0018                   3,000
  P30 to P40                    0019                   2,300
  P30 to P50                    0020                   2,600
  P40 to P50                    0021                     300
 
                                Processor-
                                Based
                                OTC
                                Feature     Group
Description                     Number      Number     OTC
 
DB2 Web Query Tool              0001        P05       $  700
 for iSeries, V1.3              0002        P10        1,000
 Program Package                0003        P20        4,000
 (5697-G85)                     0004        P30        4,400
                                0005        P40        6,700
                                0006        P50        7,000
 
Processor Group Migration
  P5 to P10                     0007                     300
  P5 to P20                     0008                   3,300
  P5 to P30                     0009                   3,700
  P5 to P40                     0010                   6,000
  P5 to P50                     0011                   6,300
  P10 to P20                    0012                   3,000
  P10 to P30                    0013                   3,400
  P10 to P40                    0014                   5,700
  P10 to P50                    0015                   6,000
  P20 to P30                    0016                     400
  P20 to P40                    0017                   2,700
  P20 to P50                    0018                   3,000
  P30 to P40                    0019                   2,300
  P30 to P50                    0020                   2,600
  P40 to P50                    0021                     300

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:

Order Now

 Use Priority/Reference Code: AE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. AE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
iSeries and pSeries are trademarks of International Business Machines Corporation.
 
The e-business logo is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, BookManager, OS/400, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
UNIX is a registered trademark is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.