IBM DB2 Table Editor Version 4.2a Copyright (C) 1999-2001 IBM Corp. All Rights Reserved. Copyright (C) 1999-2001 Rocket Software, Inc. All Rights Reserved. IBM is a registered trademark of International Business Machines Corporation. Rocket is a registered trademark of Rocket Software, Inc. It is strongly recommended that you read this document prior to the installation and use of DB2 Table Editor. The document contains the following information: - Features of DB2 Table Editor - Information about obtaining corrective service - A description of DB2 Table Editor components - Supported operating systems - Installation and configuration information for DB2 Table Editor and the Control Center plug-in About DB2 Table Editor ______________________________________________________________ DB2 Table Editor is a complete environment for building, deploying, and centrally administering table editing front-ends and applications that integrate directly with DB2 databases. DB2 Table Editor Features ______________________________________________________________ - Rapidly build Java, Windows-based or ISPF table editing front-ends. - Build e-business applications that connect directly to DB2 databases over the Internet. - Build applications that operate with any DB2 data warehouse or DB2 operational data. - Build applications using advanced database techniques and commands without programming or expert SQL knowledge. - Design controls, data validation rules, and application behavior within a drag and drop environment. - Run completed applications using the Java user applet, or with Windows 32-bit user client. - Satisfy universal requirements such as transaction management, table editing, and data entry. - No user setup required to run the Java user applet and the Windows user can be set up in minutes without database gateways, middleware, or ODBC drivers. - Restrict user/application permissions with centralized governing - Use IBM's DB2 DataJoiner to include multi-vendor data sources, such as IMS, VSAM, Oracle, Informix, Sybase, Microsoft SQL Server, and more. What's New in Version 4.2a ______________________________________________________________ ISPF interface for the full-screen table editor. Support for viewing and editing LOB columns. Stored procedure support for populating lists. New button actions - Run an SQL action to allow the running of user defined SQL statements or stored procedures. - Open Form action to allow the creation of linked forms. New control features for forms - Lock columns in position in list control on a form. A locked column will not scroll off the screen when you scroll through a list. - Specify default results for controls that derive their content from SQL queries using the Default Result page of the Control Attribute notebook. A robust full-screen table editor - Find and replace on selected rows/columns or the entire grid. - Columns in the grid can be sorted, the order changed, locked, set to force uppercase. - Rows can be inserted, deleted or duplicated. - Cells can be edited, copied, cut, pasted, launched or zoomed. - Visual indicator for primary keys. - Save at end option that enables editing without committing changes until the end of the edit session. Referential integrity support - Update primary keys - Edit related tables feature An enhanced Table Editing Wizard. - Selection of columns to include - Specification of row and sort conditions - Specification of row limit - Specification of locking mode for table being edited - Read only option - Table editing specifications can be saved and reused DB2 Control Center plug-in extension - Edit tables directly from the control center - Ability to launch DB2 Table Editor from the control center toolbar Corrective service and up-to-date product information on the Web ________________________________________________________________ For the most up-to-date product information and corrective service, visit the DB2 Table Editor Web site at: http://www.ibm.com/software/data/db2imstools/db2tools/db2tabledit.html DB2 Table Editor Components ______________________________________________________________ - DB2 Table Editor Console is used to by the administrator to set up DB2 servers to serve DB2 Table Editor applications to users. - DB2 Table Editor Developer is a rapid development environment for creating custom forms for distribution to end users. - DB2 Table Editor User provides users with access to finished DB2 Table Editor applications, which are stored centrally at the database server. - DB2 Table Editor User for Java provides users with access to finished DB2 Table Editor applications using a Java enabled browser or a Java runtime environment. - DB2 Table Editor ISPF interface for table editing the ISPF environment. Supported Operating Systems ______________________________________________________________ DB2 Table Editor applications can be developed and run on any of these Windows platforms: Microsoft Windows 95; Microsoft Windows 98; Microsoft Windows NT 3.51; and Microsoft Windows NT 4.0. They can also be run on any platform that supports a Java enabled browser. Updates to Shared Dynamic Link Libraries ______________________________________________________________ DB2 Table Editor installs the Visual C Runtime library (MSVCRT.DLL v4.21.7303) and Microsoft Foundation Classes library (MFC42.DLL v5.00.7303) to the Windows System directory. If you are running on Windows NT 3.51, DB2 Table Editor will additionally install the Microsoft 3D Windows Control Library (CTL3D32.DLL v2.31.000). Installation Types ______________________________________________________________ The setup program provides three setup options: Custom - you may choose any one or more of the three components to install. Typical - A typical install will copy all files required during normal use of DB2 Table Editor to the specified installation directory and system directories, as required. Compact - The minimum amount of files will be installed to run the user application. Configuration for unattended installation ______________________________________________________________ An unattended installation allows you to select the installation options for your DB2 Table Editor users before beginning the installation process. Using this method you can designate all the options of an installation rather than having to select the same options repeatedly for each installation. Use the following steps to enable unattended installation. STEP ONE - Edit setup.ini Using a text editor such as NotePad, edit setup.ini. This file, on Disk 1 of the installation diskettes, controls the installation process and determines the settings used for the installation. The settings you can control are described below. ____________________________________________________________________________________ [Options] Setting Effect AutoInstall = 0,1 Specify 1 to perform an unattended installation. All other settings in setup.ini are ignored if this setting is not 1. FileServerInstall= 0,1 Specifies whether DB2 Table Editor is already installed on a file server. If the settings is 0, all DB2 Table Editor files are installed to the directory specified in the InstallPath variable If the settings is 1, DB2 Table Editor must be previously installed into the directory specified in the InstallPath variable. To enable a file server installation, you must also set SetupType=2. SetupType= 0,1,2 Specifies the type of installation to perform. 0 indicates a typical installation, 1 indicates a compact installation, 2 indicates a custom installation. If you select 2, you must indicate which components to install. See the [Components] table. Note: Option 2, the custom installation, is strongly recommended. Most users do not require the Console or Developer. InstallPath= Specifies the directory to receive the DB2 Table Editor installation (if FileServerInstall=0) or the file server directory that already contains the installation (if FileServerInstall=1). ProgramGroup= Specifies the name of the program group to create (under Program Manager) or the program folder to create (for the Windows 95, Windows 98 and Windows NT 4.0 Start Menu). ____________________________________________________________________________________ [Components] Setting Effect Admin 0,1 Specifies whether to install DB2 Table Editor Console. If FileServerInstall=1, files are not copied to the local machine, but program group icons are still created. Always set this option to 0 for user installations. Developer 0,1 Specifies whether to install DB2 Table Editor Developer. If FileServerInstall=1, files are not copied to the local machine, but program group icons are still created. Always set this option to 0 for user installations. ____________________________________________________________________________________ Setup.ini example [Options] AutoInstall=1 FileServerInstall=0 SetupType=0 InstallPath=C:\Programs\DB2 Table Editor ProgramGroup=DB2 Table Editor This setup.ini file specifies an unattended installation. A typical installation is performed, copying files to the C:\Programs\DB2 Table Editor directory, and creating a program group or program folder named DB2 Table Editor. STEP TWO - Save setup.ini After you edit and save setup.ini, copy it to Disk 1 of the DB2 Table Editor installation diskettes. STEP THREE - Run DB2 Table Editor Setup Run the installation from the source diskettes or server. The installation proceeds automatically. Installing the DB2 Table Editor Control Center Plug-in ______________________________________________________________ The DB2 Table Editor Control Center Plug-in is an extension to the DB2 Control Center. For more information about the Control Center, refer to the IBM DB2 Administration Guide. The DB2 Table Editor Control Center plug-in adds DB2 Table Editor menu items to the table popup menu and adds a toolbar button to start DB2 Table Editor as an add in tool. To install the DB2 Table Editor Control Center Plug-in application: 1. Copy db2forms.jar into DB2 SQLLIB\cc directory. 2. Copy the version of db2plug.zip that corresponds to the version of DB2 that you are using, into DB2 SQLLIB\cc directory. There are two version of db2plug.zip: db2plug.v6zip and db2plug.v7zip. If you are using DB2 Version 6, then copy db2plug.v6zip, if you are using DB2 V7, then copy db2plug.v7zip. 3. Rename The release specific version that you copied to "db2plug.zip" 4. Locate the db2cc file in the SQLLIB\bin. If you are using Windows, the file is named db2cc.bat. If you are using the Unix or Linux, the file is named db2cc. 5. Update db2cc to include both "db2plug.zip" and "db2forms.jar". The file names must follow a -c option. With newer releases of DB2, you must add the -c option. If you are using an older version of DB2 which has the -c option specified in db2cc, you can append the values to the end of the existing -c option. Here is an example of db2cc after you have added the files if you are working with DB2 V6: IF "%1" == "wait" GOTO WAIT db2javit -j:"CC" -d:"CC" -c:"db2plug.zip;db2forms.jar" -o:"-mx128m -ms32m" -a:"%1 %2 %3 %4 %5 %6 %7 %8" GOTO END :WAIT db2javit -j:"CC" -d:"CC" -c:"db2plug.zip;db2forms.jar" -w: -o:"-mx128m -ms32m" -a:"%2 %3 %4 %5 %6 %7 %8 %9" GOTO END :end Here is an example of db2cc after you have added the files if you are working with DB2 V7: IF "%1" == "wait" GOTO WAIT db2javit -j:"CC" -d:"CC" -c:"db2forms.jar" -o:"-mx128m -ms32m" -a:"%1 %2 %3 %4 %5 %6 %7 %8" GOTO END :WAIT db2javit -j:"CC" -d:"CC" -c:"db2forms.jar" -w: -o:"-mx128m -ms32m" -a:"%2 %3 %4 %5 %6 %7 %8 %9" GOTO END :end If you are running the Control Center as a Java applet, complete the following steps: 1. Copy the db2forms.jar file where the tag points to in db2cc.htm. 2. Update db2cc.htm to include "db2plug.zip" and "db2forms.jar" in the archive list.