Software Announcement 299-099
April 27, 1999

Rapidly Create e-business Applications with IBM DB2 Forms for VM and VSE

 ENUS299-099.PDF (35KB)


At a Glance

DB2 Forms 1.0 — global connections using multiple platforms and technologies

  • Create applications that set new standards for performance
  • Build GUIs to:
    • Any DB2 data warehouse
    • DB2 operational data
  • Satisfy universal requirements:
    • Transactions
    • Table editing
    • QBE
    • Data entry
  • Slash development time
  • Store, update, and serve applications to all users from a single database location

For ordering, contact:

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

EXTRA! EXTRA! . . .

Subscribe to IBM iSource, your electronic source for customized IBM information! Go to our Web site at http://www.ibm.com/isource or send an e-mail to info@isource.ibm.com with the word SUBSCRIBE in the body.

Overview

DB2® Forms Version 1.0:

  • Builds application front ends to DB2 workstation databases
  • Enables friction-free distribution of high-performance solutions on the open architecture of DB2

DB2 Forms 1.0 applications can be created by developers, governed by administrators, and run by end users on Windows™ platforms, including:

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

DB2 Forms 1.0 is easy to set up and requires no database gateways, middleware, or ODBC drivers. Users can also build advanced database techniques and commands without programming or SQL knowledge.

Open Group's Distributed Relational Database Architecture™ (DRDA®) Compliance

DB2 Forms 1.0 is fully compliant with the Open Group's DRDA specifications. Global connectivity is possible between DB2 Forms applications and multiple DB2 database platforms via network topologies of choice, including:

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

Centralized management and "Web-ready" server-based licensing yield advantages in:

  • Ease of use
  • Unlimited distribution (no "per seat" charge for application distribution)
  • Maximum centralized control

DRDA support allows access also to multivendor databases (IMS™, VSAM, Oracle, and Microsoft™ Server, and more) via the multidatabase gateway DB2 DataJoiner®.

Building upon the success of IBM's DBEdit enterprise application development tool, DB2 Forms dramatically extends DBEdit's capabilities beyond legacy user environments to Windows desktops and remote users.

Download a 60-day trial version at:

Key Prerequisites

  • Minimum 10 MB of free disk space on each Windows workstation
  • Host hardware must be able to run DB2 for VM or VSE

Planned Availability Date

April 30, 1999

Description

DB2 Forms Advantages

  • Complete environment for building, deploying, and centrally administering Windows-based applications that integrate directly with DB2 databases
  • Global Internet or intranet connectivity to mainframe or workstation databases
  • Full range of DB2 SQL command executions
  • Scale to any size user base (no "per seat" charges for application distribution)
  • Native support for DRDA (the open architecture of DB2)
  • TCP/IP brings:
    • Outstanding application performance and reliability
    • Independence from database gateways, middleware, or ODBC
  • Friction-free distribution of high-performance solutions on the open architecture of 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

Delivered in Three Modules

  1. DB2 Forms Developer is a rapid development environment for creating custom forms for distribution to end users. 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 available to specific groups or to all users.
  2. DB2 Forms User provides users with access to finished DB2 Forms applications, which are stored centrally at the database server. End users select and launch applications from the catalog. 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. Access is available to local or remote locations, including for users connecting from any location via the Internet to TCP/IP supported DB2 databases.
  3. DB2 Forms Console sets up DB2 servers to serve DB2 Forms applications to users. This includes defining servers and installing DB2 Forms packages at the servers. DB2 Forms Console supports and relies upon your existing DB2 security.

Advanced Database Protection and Performance Features: DB2 Forms provides advanced database application capabilities traditionally found only in closed host-based systems. Execution of DB2-specific SQL, direct attachment to the DB2 catalog of tables and columns, and centralized administration all combine to maximize availability and control simultaneously.

Drag-and-Drop for Rapid Application Development: Developers can quickly construct new applications, often in just minutes. Applications can be centrally stored for user access at the database server, and periodically updated and improved at will. DB2 Forms enables the DB2 database server to become the DB2 Forms application server with minimal overhead.

DB2 Forms users can run unlimited numbers of new applications:

  • Without installing additional software
  • Immediately after they are created
  • To update the applications

The enterprise can get up and running at maximum velocity and to 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 that are instantaneously distributed 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.

Without any programming knowledge, developers can drag-and-drop to create forms containing a variety of controls able to perform commonly required tasks, such as:

  • Command Buttons
    • Multiple actions including clear, close, delete, and exit
  • Data Controls
    • Validation rule and formatting choices, including valid integers, range constrains and input format (for example, currency, phone number)
    • Action choices including insert, update, and replace
  • Form Layout
    • Including labels, text boxes, images, and colors

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.

The service end date for this Year 2000 ready product is May 1, 2001.

Product Positioning

DB2 Forms 1.0 allows DB2 customers to quickly produce end-user "front ends" to DB2. The front ends may be for local remote, in-house, or business-to-business uses. Native support for any DRDA application server makes DB2 Forms 1.0 ideal for virtually any DB2 database environment, including VM, VSE, and DB2 UDB workstation databases, and those supporting either SNA or TCP/IP connectivity. Customers wishing to access DB2 on OS/390® should license DB2 Forms for OS/390, refer to Software Announcement 299-056 , dated March 2, 1999.

The key advantages of DB2 Forms over and above other approaches to DB2 database application development include:

  • A native capacity to connect to multiple DB2 database platforms at will (for example, VM, VSE, AIX®, and Windows NT) without configuration of database gateways, middleware, or ODBC drivers.
  • Direct support for enterprise database features (such as DB2 security, and workload balancing in DB2 Version 6) demanded by administrators of large environments.
  • Convenient centralized administration.
  • Native support for DataJoiner's DRDA application server, enabling robust support for heterogeneous environments that include non-DB2 databases, such as IMS, VSAM, Oracle, Sybase, Microsoft SQL Server, and more.

Current DBEdit customers will want DB2 Forms 1.0 for:

  • Year 2000 compliance
  • Ease of use
  • Ability to quickly replicate existing DBEdit applications

DB2 Forms can support DBEdit customers as they grow in the twenty-first century, including to multiple DB2 database platforms.

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


    Rocket Software, Inc.
    One Innovation Drive
    Natick, MA 01760
    508-655-7677

Trademarks

 
Distributed Relational Database Architecture and IMS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DRDA, DataJoiner, OS/390, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Windows NT is a registered trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Open Enterprise

DB2® Forms implements the following 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

Specified Operating Environment

Hardware Requirements: Host hardware must be able to run DB2 for VM or VSE.

Workstation hardware must be able to run the Windows™ software, as described in the Software Requirements section.

Software Requirements: Host software requirements are those required to run DB2 for VM or VSE.

DB2 Forms for VM and VSE is 32-bit and runs on:

  • Windows 95
  • Windows 98
  • Windows NT®

Access to DB2 Universal Database® (UDB) Personal Edition is not supported.

DB2 Forms will connect to DB2 for VM, Version 6 via native TCP/IP or SNA, and to DB2 for VSE, Version 6 via SNA. DB2 Forms will connect to earlier versions of DB2 for VM or VSE via SNA.

For TCP/IP connectivity, 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, 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 has been tested with and supports. The columns under Windows 9x and Windows NT indicate whether or not DB2 Forms works with the listed SNA product on that platform.

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

Planning Information

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

Security, Auditability, and Control

The announced program uses the security and auditability features of the VM or VSE 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.

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. 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:

Ordering Information

New Licensees

Orders for new licenses can be placed now. Shipment will begin on April 30, 1999.

Basic License: To order a license, specify the program number and feature number 9001 for asset registration, and the feature numbers below that correspond to the group that contains the designated machine.

                                             MOSP
                         Basic               Basic
                         MLC                 MLC
     Group               Feature             Feature
     Number              Number              Number
 
     18                  1002                1034
     20                  1003                1035
     25                  1004                1036
     28                  1005                1037
     29                  1006                1038
     30                  1007                1039
     31                  1008                1040
     32                  1009                1041
     35                  1010                1042
     38                  1011                1043
     40                  1012                1044
     50                  1013                1045
     60                  1014                1046
     70                  1015                1047
     80                  1016                1048
MLC
= Monthly License Charge

Note: The group can be determined by referring to Exhibit for System/390® Machines (Z125-3901).

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.

Program
                                             ESL OTC
                              Program        Feature
Description                   Number         Number
 
DB2 Forms for VM              1064           5697-F16
  and VSE

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

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for an OTC to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material

                              Feature        Distribution
Environment                   Number         Medium
 
DB2 Forms for VM              5809           CD-ROM
  and VSE

Customization Options: The customization options apply only to expedited shipments. Select the appropriate feature number if expedited shipment is desired.

Expedite Shipments

                                                       Feature
Description                                            Number
 
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.

DSLO License: To order a DSLO license, specify the program number, feature number 9901 for asset registration, and the feature number below for graduated MLC or OTC (China only) that corresponds to the group containing the designated machine.

                                             MOSP
                         Basic               Basic
                         MLC                 MLC
     Group               Feature             Feature
     Number              Number              Number
 
     18                  1019                1049
     20                  1020                1050
     25                  1021                1051
     28                  1022                1052
     29                  1023                1053
     30                  1024                1054
     31                  1025                1055
     32                  1026                1056
     35                  1027                1057
     38                  1028                1058
     40                  1029                1059
     50                  1030                1060
     60                  1031                1061
     70                  1032                1062
     80                  1033                1063

Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license will be provided through the basic license location. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.

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.

Additional product information, including technical updates between releases, can be found at the DB2 Forms Resource Center by first accessing:

Customer Financing

IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. 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:

Terms and Conditions

Licensing: IBM Customer Agreement

Variable Charges Apply: Yes

Indexed Monthly License Charge (IMLC) Applies: No

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable

Version-to-Version Upgrade Credits Apply: Yes

                    Replaced
Program             Program             Program
Name                Number              Name
 
DB2 Forms           5697-F12            To a follow-on
  for VM                                if any
  and VSE

Single Version Charging Applies: Not applicable

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
  • Services for DSLO licenses: Provided through basic license location

Support Line: S/390®

Charges

Contact your IBM representative for charges information for this announcement.

Call Now to Order

To order, contact the IBM Americas Call Centers, your local IBM representative, or your IBM Business Partner.

IBM Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept. YE001
            P.O. Box 2690
            Atlanta, GA  30301-2690
 Reference: YE001

To identify your local IBM Business Partner or IBM representative, 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, DB2 Universal Database, AS/400, System/390, and S/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Windows NT is a registered trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.