Software Announcement 200-063
March 28, 2000

IBM DB2 Forms for OS/390 Version 2 — Rapidly Build Java and Windows Front Ends to Any DB2 Database

 ENUS200-063.PDF (44KB)


At a Glance

Tackles your fundamental data access and update needs across your enterprise.

  • Drag and drop workspace
  • No programming, compiling, or porting needed
  • Embed applications in Web pages or run stand-alone
  • View, update, or create data (with data validation and business rules) directly to:
    • Any DB2 data warehouse
    • DB2 operational data
  • Store, update, and serve applications to all users from a single database location
  • Slash development time, and rapidly create any number of unique business solutions for unlimited locations and numbers of users

For ordering, contact:

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

Overview

DB2® Forms Version 2 represents a breakthrough in rapid development and deployment of network and Web-based applications.

Key problems that plague e-business and Web transactions are scalability, reliability, and ease of implementation. DB2 Forms Version 2 addresses all three.

You can reap benefits as you extend databases directly to the Web, the intranet, or throughout the enterprise on a closed SNA environment.

Now you can:

  • Quickly build and embed data-intensive applications in your Web pages
  • Use these applications to read and write directly to the DB2 database of your choice (instead of to an HTTP server, CGI script, or other middleware solution)
  • Use these applications as stand-alone Java™ applications without a browser
  • Optionally create parallel native, 32-bit, Windows™-based applications that connect via TCP/IP or SNA
  • Allow even novices to prototype (and improve at will) the multiple applications their departments may need
  • Effortlessly ensure that only the latest versions of applications are in use by everyone
  • Support DB2 security and advanced DB2 performance features to globally dispersed user and customer bases
  • Centrally administer and control end-user actions and access to data

DB2 Forms V2 is positioned as a companion product to every DB2 database to satisfy a broad range of fundamental data access and update needs in every area of the enterprise, and as an alternative to more complex application building packages and languages that require significant training, skill sets, or infrastructure investment.

The benefits of getting up and running quickly, adherence to open standards, choice of platforms and networks upon which to run, and tight technical coupling to DB2 (through static SQL, host variables, and more) distinguish DB2 Forms Version 2.0 from any other product.

In addition, DRDA® compliance in DB2 Forms Version 2.0 and native support for DB2 DataJoiner® make DB2 Forms a strategic choice in any heterogeneous database environment.

The product is double byte character set (DBCS) ready; for example, double byte characters can be used for filename and table name handling. No language translations are provided.

Download a 60-day trial version at:

Key Prerequisites

  • Any workstation capable of running Windows 95, Windows 98, or Windows NT™ 3.51 or later, with a minimum of 10 MB of free disk space.
  • Host hardware capable of running DB2.

Planned Availability Date

March 31, 2000

Description

What's New in DB2 Forms Version 2.0?

Following are several new capabilities for DB2 Forms Version 2.

  • A single development environment enables you to simultaneously build both Java-based and 32-bit Windows-based applications (some application features may only be available in 32-bit, Windows-based applications and not in Java-based applications)
  • Greater flexibility in determining behavior of controls with:
    • New "refer back" capability that allows one control to "look up" a value in another and use that value to perform an action
    • Multiple column list controls that can be filled with values based on an SQL select statement
    • A combo box or list control's action can be based on a value other than the one displayed
    • "Previous row" command button
    • "Launch" command button
    • Setting of automated refresh frequencies for the values in combo boxes, plus a manual refresh command button
  • Tighter host integration with:
    • Ability to bind static SQL for all statements of a form
    • Use of host variables when sending data values to DB2
  • Table editing "wizard" for Java and Windows end users, for quickly producing form layouts or table layouts of editable data
  • Intuitive search characters (for example, "starts with" or "like")

DB2 Forms Advantages

  • Rapid development of data-intensive Web applications
  • Global Internet or intranet connectivity to mainframe, AS/400®, or workstation databases
  • Broadest choice of end-user environments, including:
    • Accessing through browsers as applets embedded in Web pages
    • Accessing as stand-alone Java applications
    • Accessing as native Windows 32-bit applications
  • Applications in all environments that read and write directly to any DB2 database
  • Native support for DB2 syntax and SQL commands
  • Server-based application code allows opening applications to an unlimited number of users
  • Applications utilize existing DB2 logon security
  • Centralized management and administration, providing excellent concurrency and control over application versions and user permissions
  • Friction-free distribution of high-performance solutions powered by the number-one database: DB2

Application Possibilities

Business-to-Business Customer Relationship Solutions

  • Product catalog applications
  • Online ordering
  • Order status and transport tracking
  • Customer support databases
  • Supply chain management

Sales Support Solutions

  • Customer and contact management
  • Account status tracking
  • Sales campaign targeting
  • Direct online pricing, availability, and inventory reservation
  • Order entry automation
  • Mobile office support

General Data Warehouse and Operational Data Solutions

  • Corporate-wide QBE applications (for example, corporate phone book)
  • Table editing
  • Data entry
  • Data validation
  • Test data creation

The enterprise can get DB2 Forms applications such as those above up and running at maximum velocity and fully realize the benefits of ongoing iterative development. Instead of error-prone "monolithic" application planning, coding, installation, and client configuration projects with long turnaround times, developers can focus their resources on user-driven enhancements. Enhancements can be distributed instantaneously in much smaller, more rapid cycles of development and user feedback. In this key way, DB2 Forms strategically enhances the business effectiveness of application development teams, and brings an important new dimension to the centralized sharing capabilities of relational database servers.

Delivered as Four Modules

DB2 Forms Developer

A rapid development environment for creating custom forms that end users can access from virtually any environment or location. In a drag-and-drop interface, developers quickly add command buttons, labels, text boxes, and controls for containing data and "drop down" lists. Behaviors, data sources, and data validation rules are assigned to controls from easy-to-use dialogs that require no programming. Applications can be made available only to their creators, to all users, made fully visible within a Web page, or made available as a link in a Web page. The developer can specify whether a unique DB2 logon is required to access the application.

Each application presents specific data associated with it at development time, and enforces data browsing, data entry, and data update rules embedded within it. Typical applications include table editing, inventory or product catalog access, order entry, customer invoice retrieval, or query-by-example front ends.

Whether rolled out for access from within Web pages, as stand-alone Java applications, or as Windows-based applications, no compiling or porting is needed for any DB2 Forms application.

DB2 Forms Console

Sets up DB2 servers to centrally store Java and Windows-based DB2 Forms applications for access by end users. The Console defines servers, installs DB2 Forms packages at the servers, creates the DB2 Forms catalog objects at the servers, and sets various user group permissions. DB2 Forms Console supports and relies upon your existing DB2 security.

DB2 Forms User

The Windows client run-time that provides users with access to Windows-based DB2 Forms applications, which are stored centrally at the database server. (Installation of the DB2 Forms User Module is not required when using Java-based DB2 Forms applications.) End users select and launch any number of applications from the catalog (stored at the DB2 server) without having to install any additional code on their workstations. Access can be made available to local or remote workstations, including those connecting from any location via the Internet to TCP/IP-supported DB2 databases.

DB2 Forms Java Player

Installed by the administrator to your HTTP server for serving your Java-based DB2 Forms applications to Web browsers. Can also be installed on Java-enabled workstations for running Java-based DB2 Forms applications stand-alone without a browser.

Applications can contain a variety of controls for performing commonly required tasks, such as:

Command Buttons for Multiple Actions

  • Launch
  • Refresh
  • Search
  • Next
  • Previous
  • Insert
  • Update
  • Delete
  • Clear
  • Close
  • Delete
  • Exit
  • Help

Data Controls

  • Combo boxes, multiple column list controls, and multiple line edit controls
  • Validation rule and formatting choices, including valid integers, range constraints, and input format (for example, currency, phone number)

Form Layout

  • Labels
  • Text Boxes
  • Images
  • Borders
  • Colors

Java and XML Standards Compliance

DB2 Forms Version 2 generates online applications that can be run as Java applets embedded in Web pages for access through a browser, or as stand-alone Java applications without a browser.

DB2 Forms also generates the specifications for a Java application in XML vocabulary, laying the groundwork for future integration in Web-based data interchange and leveraging of IBM's DB2 XML Extender.

Java and XML standards compliance adds universal portability to DB2 Forms applications, allowing application developers, end users, and the enterprise to:

  • Immediately enhance any Web site's data handling and e-business capabilities
  • Quickly and safely integrate operational data, data warehouses, and legacy data sources with intranet and Internet operations
  • Create robust applications once and distribute everywhere
  • Centrally administer, manage, and update applications that are accessed worldwide
  • Build on open, universally accepted standards for application development, data access, and data interchange
  • Minimize client workstation preparation
  • Fully leverage TCP/IP connectivity to any DB2 database platform

Open Group's DRDA Compliance

This product is in compliance with Open Group's Distributed Relational Database Architecture™ (DRDA).

At the same time DB2 Forms Version 2 generates your Java-based applications, it can also generate Windows-based applications which can be distributed freely on demand over networks and are architecturally coupled to DB2 via the open standards of DRDA.

DRDA compliance allows you to easily transcend network, hardware, and operating system differences when connecting Windows-based DB2 Forms client applications to DB2 database servers on multiple platforms. The result is the elimination of database gateways, middleware, and ODBC drivers, while gaining more rapid setup, easier administration, and support for advanced features of DB2.

In part, DRDA compliance makes the use of multiple network types transparent, including:

  • Publicly accessible Internet connections
  • Dedicated dial-up lines
  • TCP/IP intranets
  • Closed SNA environments

DRDA compliance also allows inclusion of multivendor databases (including IMS™, VSAM, Oracle, and Microsoft™ SQL Server) via the multidatabase gateway DB2 DataJoiner.

Year 2000

This product is Year 2000 ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided that all products (for example, hardware, software, and firmware) used with the product properly exchange accurate date data with it.

Euro Currency

This program is not impacted by euro currency.

Product Positioning

DB2 Forms Version 2 is a new technology for enabling full relational database support over intranets and the Internet, including at e-commerce sites where database updates and data retrieval play a crucial role in operations. Customers desiring to establish high levels of reliability and performance in heavily trafficked Web-based storefronts and customer service sites should look to DB2 Forms to provide the following:

  • The ability to easily deploy reliable data-intensive applications through their existing Web sites, such as:
    • Visitor registration
    • Order entry
    • Pick lists
    • Order status
    • Online pricing and inventory
    • Order History, QBE, and other multi-row data retrieval
  • The choice to integrate application interfaces within the design of existing pages, or make applications open as separate interfaces
  • Support for DB2 databases on multiple platforms, including Linux, Windows NT™, AS/400, and OS/390®
  • A drag-and-drop rapid development environment in which application changes are made in minutes without programming
  • Low learning curve, so that even non-programmers can quickly develop applications from scratch
  • Simplicity of administration, with no need to adapt HTTP servers to handle data with complex scripts
  • Support for DB2 security
  • A fully-functional 60-day evaluation version available for download and free technical support during the trial period at:

Long-standing DB2 customers will also appreciate support in Windows-based DB2 Forms applications for DRDA standards, which in part allows for cross-platform operability and SNA connectivity to legacy environments where intranets are not enabled.

Customers with multivendor database environments (which include databases such as VSAM, IMS, Oracle, Sybase, Microsoft SQL Server, and others) will benefit from the DB2 Forms Version 2.0 support for IBM's DB2 DataJoiner, providing access to the broadest possible set of enterprise data sources.

Hardware and Software Support Services

SmoothStart™/Installation Services

SmoothStart and Installation Services are not provided.

DB2 Forms on-site developer and administrator education are provided for a fee by the following IBM Business Partner:

    Rocket Software, Inc.
    Two Apple Hill
    Natick, MA 01760
    508-655-4321

Trademarks

 
Distributed Relational Database Architecture, IMS, and SmoothStart are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, DataJoiner, AS/400, and OS/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows, Microsoft, and Windows NT are trademarks 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.

Open Enterprise

DB2® Forms implements the follow key industry standards:

  • Open Group's Distributed Relational Database Architecture™ (DRDA®) is used to communicate with the DB2 family of relational databases.
  • The TCP/IP and SNA Network communication protocols are supported by DB2 Forms. The DRDA Application Requester (AR) and DRDA Application Server (AS) functionality can now be implemented using these standard protocols.
  • SQL 92 Entry Level: DB2 Forms is compliant with this level of SQL.

Technical Information

Hardware Requirements: For DB2 Forms application storage, the host hardware must be able to run DB2.

For DB2 Forms application usage, workstation hardware must be able to run the Java™ or Windows™ software.

Software Requirements: The following table displays a representative DB2 product for each host environment.

Host Environment         DB2 Product
 
OS/390(R)                DB2 for OS/390 Version 5,
                           or later
VM                       DB2 for VM and VSE Version 6,
                           or later
AS/400(R)                DB2 Universal Database(R) for
                           AS/400 V4.3, or later
AIX(R)                   DB2 Universal Database for
                           AIX
HP-UX                    DB2 Universal Database for
                           HP-UX
SCO UnixWare             DB2 Universal Database
                           for SCO UnixWare
Sun Solaris              DB2 Universal Database
                           for Sun Solaris
Windows                  DB2 Universal Database
                           for Windows NT(TM), Windows 95,
                           and 98

Serving Java-based DB2 Forms applications to users who wish to run them in their browsers requires an HTTP server running IBM's JDBC driver, which is in turn configured to establish a CLI connection to the local or remote DB2 databases that you wish users to access. Refer to your DB2 documentation for further details on setting up CLI connections and the DB2 JDBC driver.

Running Java-based DB2 Forms applications in a browser requires a browser that supports JVM 1.1, or later, such as current versions of Netscape or Microsoft™ Internet Explorer.

Running Java-based DB2 Forms applications without a browser requires a workstation that supports JVM 1.1, or later, and has a DB2 Client Application Enabler installed on it that is configured to support the DB2 database to which you wish to connect. Refer to your DB2 documentation for further details on setting up the DB2 Client Application Enabler.

DB2 Forms Windows-based application usage, building applications with the DB2 Forms Developer Module, and set up and administration with DB2 Forms Console Module each require any of the following 32-bit Windows environments:

  • Windows 95
  • Windows 98
  • Windows NT 3.51, or later

For TCP/IP connectivity for DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module, DB2 Forms must be able to establish a TCP connection from the Windows workstation to the remote host and remote port (the port on which DB2 is listening). This can be established with many 32-bit WinSock products, including those provided with Windows 95, Windows 98, and Windows NT.

For SNA connectivity for DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module, DB2 Forms requires an SNA/CPI-C product on each Windows workstation. These products are the interface between DB2 Forms and the APPC verb set used by the SNA environment to manage server/requester relationships.

The following table indicates the configurations that DB2 Forms Windows-based applications, the DB2 Forms Developer module, and the DB2 Forms Console module have been tested with and support. The columns under Windows 9x and Windows NT indicate whether or not DB2 Forms works with the listed SNA product on that platform.

SNA Product                           Windows      Windows
                                         9X           NT
 
IBM Personal Communications            32-bit
  AS/400 and 3270 4.1 for
  Windows 95
IBM Personal Communications            32-bit
  AS/400 and 3270 4.1 for
  Windows NT
eNetwork(TM) Personal                  32-bit       32-bit
  Communications Version 4.21
  for Windows 95 and Windows NT
Microsoft SNA Server 2.11 or 3.0       32-bit
  Windows 95 Client
Microsoft SNA Server 2.11 or 3.0       32-bit
  Windows NT Client
Novell NetWare for SAA 2.2             32-bit       32-bit
Wall Data Rumba 95/NT 5.0              32-bit       32-bit

Compatibility: DB2 Forms for OS/390 Version 2 is upwardly compatible with DB2 Forms for OS/390 Version 1.

Limitations: DB2 Forms for OS/390 Version 2 is Double Byte Character Set (DBCS) ready. No language translations are provided.

Planning Information

Packaging: DB2 Forms is shipped on one CD-ROM.

Security, Auditability, and Control

The announced product uses the security and auditability features of the OS/390 operating system and the supported database servers.

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

There are no publications for this product. All required information is on the product's single CD, help text, or at:

New Licensees

Orders for new licenses can be placed now.

Shipment will begin on the planned availability date.

To order DB2 Forms for OS/390 specify:

Type      Model
 
5697      G16

Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium.

                                              ESL OTC
Description                                Feature Number
 
DB2 Forms for OS/390 Version 2                  0018
  (5697-G16)

ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).

Parallel Sysplex® License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B, and PSLC Level C, PSLC Level D features and quantity.

If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses.

Also, specify the feature number of the desired distribution medium.

                    PSLC           PSLC Basic License
Machine             Feature        MLC Feature
MSU Capacity        Number         Description
 
1                   0001           PSLC Base, 1 MSU
2                   0002           PSLC Base, 2 MSUs
3                   0003           PSLC Base, 3 MSUs
4 to 45             0004           PSLC Level A, 1 MSU
                    0005           PSLC Level A, 42 MSUs
46 to 175           0006           PSLC Level B, 1 MSU
                    0007           PSLC Level B, 10 MSUs
                    0008           PSLC Level B, 50 MSUs
176 to 315          0009           PSLC Level C, 1 MSU
                    0010           PSLC Level C, 10 MSUs
                    0011           PSLC Level C, 50 MSUs
316 or more         0012           PSLC Level D, 1 MSU
                    0013           PSLC Level D, 50 MSUs
N/A                 0014           PSLC NC IDENTIFIER

Example 1: For a single machine with 11 MSUs, the PSLC features would be:


    0003 — quantity 1
    0004 — quantity 8

Example 2: For two machines in a Parallel Sysplex, which have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1:

      0003 — quantity 1
      0005 — quantity 1
      0006 — quantity 5
      0007 — quantity 1
  • PSLC no-charge license #2:

      0014 — quantity 1

Single Version Charging: To elect single-version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine on which the programs are operating.

Growth Opportunity License Charge (GOLC) To order a Multiprise® 3000, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.

Multiprise 3000             GOLC
     Model             Feature Number
 
      H30                   0015
      H50                   0016
      H70                   0017

Basic Machine-Readable Material

                          Feature         Distribution
Environment                Number            Medium
 
DB2 Forms for OS/390        5809             CD-ROM

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

Example: No publications are available for this product. All required information is included on the product's single CD and has help text.

                                                    Feature
Description                                         Number
 
Initial Shipments
 
Serial number only (suppresses shipment             3444
  of media and documentation)
 
Satellite Electronic Delivery                       3450
 
Update Shipments
 
Suppress updates (suppresses update                 3482
  shipment of media and documentation)
 
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.

Optional Machine-Readable Material: To order, select the feature number for the desired distribution medium.

Unlicensed Documentation: No publications are shipped with the announced product. All documentation supporting the product is included as help text on the product's CD-ROM and at:

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.

Terms and Conditions

Licensing: IBM Customer Agreement

Variable Charges Apply: No

Indexed Monthly License Charge (IMLC) Applies: No

Installation License or Location License Applies: No

Usage Restriction Applies: No

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

Volume Discount: Not applicable

Products Eligible for Single Version Charging

    Replaced Program             Replacement Program
Program          Program      Program           Program
Name             Number       Name              Number
 
DB2 Forms for    5697-F09     DB2 Forms for     5697-G16
  OS/390                        OS/390
  Version 1                     Version 2

Warranted: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All

Testing Period: Two months (basic license only)

Program Services

  • Support Center applies: Yes
    Access available through the IBM Support Center
  • Available until discontinued: 12-months written notice
  • APAR Mailing Address:
      IBM Corporation
      555 Bailey Ave.
      San Jose, CA 95141

Support Line: No

Charges

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. YE001
            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

 
Distributed Relational Database Architecture and eNetwork are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, OS/390, AS/400, DB2 Universal Database, AIX, Parallel Sysplex, and Multiprise are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows, Windows NT, and Microsoft are trademarks 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.