IBM(R) DB2(R) Table Editor for Multiplatforms, Version 4 Release 3 Fix Pack 7 README CONTENTS 1.0 ABOUT THIS README FILE 1.1 Evaluation code 1.2 Corrected known problems 1.3 Enhancements 2.0 PREREQUISITES 2.1 Hardware Requirements 2.2 Software Requirements 3.0 INSTALLATION INSTRUCTIONS 3.1 Updates to Shared Dynamic Link Libraries 3.2 Configuration for Unattended Installation 3.3 Installing the DB2 Table Editor Control Center Plug-in 3.3.1 Installing the DB2 Table Editor Control Center Plug-in on DB2 V7 3.3.2 Installing the DB2 Table Editor Control Center Plug-in on DB2 V8 4.0 CONFIGURATION INSTRUCTIONS 5.0 RESTRICTIONS 6.0 CORRECTIONS TO DOCUMENTATION 7.0 HOW TO GET HELP 8.0 NOTICES 8.1 Other notices 8.2 Use of evaluation program 8.3 Trademarks and service marks 1.0 ABOUT THIS README FILE Welcome to IBM DB2 Table Editor, Version 4 Release 3, Fix Pack 7 that contains the latest fixes for DB2 Table Editor V4.3. This Fix Pack is a complete replacement of the product without the License Use Management (LUM) key. IBM DB2 Table Editor has been tested and validated with all supported releases of DB2 Universal Database(TM) for multiplatforms through Version 8 Release 1 modification 7 and DB2 for os/390 and z/OS PDO0409. Subsequent releases might require additional maintenance. In this README file, the following naming convention applies: IBM DB2 Table Editor for Multiplatforms is abbreviated to DB2 Table Editor. 1.1 Evaluation code If you are using evaluation code, the evaluation code enables you to try this product for a period of 60 days. After 60-days, you must purchase a license to continue to use the product. When you purchase the product, the license is enforced based upon the platform to which you are connecting using IBM DB2 Table Editor. For more information on Licensing see "Licensing" in the DB2 Table Editor User's Guide. Read the NOTICES Section 8.2, USE OF EVALUATION PROGRAM, and the License Agreement provided with your evaluation copy of the program. 1.2 Corrected Known Problems This fix pack contains the following corrections: - PK12183 - a saved form can now be opened from a catalog that is not the default. - PK02482 - all DBEDIT panels can be imported with DB2 Table Editor using Windows XP Service Pack 2. - PQ78910 - Numeric data column treated as CHAR Data during a sort. - PQ83783 - JPEG images do not display on forms. - PQ89590 - Application memory error occurs when using DB2 Table Editor. Performing a search on a form when running the DB2 Table Editor Windows User component on a Windows XP machine causes DB2 Table Editor to crash. - PQ90016 - Testing a stored procedure using the DB2 Table Editor Developer component and running it using the DB2 Table Editor Windows User component caused the DB2 Table Editor Windows User component to crash. - PQ94798 - When using an existing form to perform an update, an error (SQLCODE100) occurs for rows of string data that contain single quoted words. DB2 Table Editor adds an additional set of single quotes. - PQ96041 - Redundant DB2 column names are erroneously displayed when editing a related table - PQ96281 - A SQLCODE-313 error is returned when opening a saved form through the DB2 Table Editor Developer component, when a catalog other than the DB2 Table Editor default catalog is used. - PQ96647 - An SQL0104N error (unexpected token) occurs when updating/inserting values into the primary table in a form that has a join condition between two tables. - SA96434 - When one form links to another form, data displays with the error: "An unexpected error occurred (SQLIFAC2,1985)'. When you click ‘OK’, and the data in the form disappears. - PK02411 - Installing DB2 Table Editor on a client from a file server, using the File Server install did not work. 1.3 Enhancements Enhanced functionality when working with Informix Databases - No DB2 catalog database required - A DB2 database is no longer required when working with Informix data only. - Save forms at server - Forms can now be saved at the server using the DB2 Table Editor Windows User component, and saved forms can be retrieved from the server using the Windows User and Java Player components. 2.0 PREREQUISITES 2.1 Hardware Requirements Hardware requirements are those needed to run the Windows software as described in 2.2 Software Requirements. DB2 Table Editor has the following requirements: - Approximately 16 MB of free disk space on a Windows machine - A minimum of 32 MB memory. Additional memory improves performance. 2.2 Software Requirements DB2 Table Editor runs on the following operating systems: - Microsoft Windows 2000 - Microsoft Windows XP 3.0 INSTALLATION INSTRUCTIONS To install DB2 Table Editor: 1. Download the Fix Pack from the Web: http://www.ibm.com/software/data/db2imstools/support/fixpaks.html Download the file to a temporary directory on the system where the DB2 Table Editor is installed. 2. Browse to the Disk1 directory and double-click setup.exe. The DB2 Table Editor install starts. 3. Follow the steps in the DB2 Table Editor Install wizard. For specific information on items in the install wizard, click the Help button to access the online help. 4. When the installation is complete, start the DB2 Table Editor Console and create a server definition file for each server that you want to access using DB2 Table Editor. For more information on creating a server definition file, see the DB2 Table Editor User's Guide. Note: You must set up server definition files for the servers that you want to access using DB2 Table Editor before you can access these servers using DB2 Table Editor Developer, Windows User, or Java Player. Use the DB2 Table Editor Console to setup server definition files. 5. Bind the DB2 Table Editor packages. 3.1 UPDATES TO SHARED DYNAMIC LINK LIBRARIES DB2 Table Editor installs the Visual C Runtime library (MSVCRT.DLL v4.21.7303) and Microsoft(R) Foundation Classes library (MFC42.DLL v5.00.7303) to the Windows(R) System directory. If you are running on Windows NT(R) 3.51, DB2 Table Editor will additionally install the Microsoft 3D Windows Control Library (CTL3D32.DLL v2.31.000). 3.2 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. By using this method you can designate all of the options for multiple installations rather than having to select the same options repeatedly for each individual 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. Specify the settings that you want in setup.ini. _____________________________________________________________________________ [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 also must 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. 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(R), Windows 98(R), and Windows NT(R) 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 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. [Options] AutoInstall=1 FileServerInstall=0 SetupType=0 InstallPath=C:\Programs\DB2 Table Editor ProgramGroup=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. 3.3 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 pop-up menu and adds a tool bar button to start DB2 Table Editor as an add in tool from the DB2 Universal Database Control Center. 3.3.1 INSTALLING THE DB2 TABLE EDITOR CONTROL CENTER PLUG-IN on DB2 V7 1. Copy the following files and directories to the SQLLIB\cc directory: - db2forms.jar - One or more of the following license files. – dbehost.lic – dbe400.lic - dbework.lic -dbehost.ecf (if you are working with a trial version of DB2 Table Editor) You must copy the license file that corresponds to the platform on which the DB2 database to which you want to connect resides. - HtmlHelp Directory (Including all sub folders) By default this directory is SQLLIB\cc. The Control Center requires that these files be located in the Java classpath so that they can be loaded when the Control Center is started. 2. Copy db2plug.v7zip into SQLLIB\cc directory. There are two version of db2plug.zip: db2plug.v7zip and db2plug.v8zip. db2plug.v7zip works with DB2 version 7. 3. Rename db2plug.v7zip to: db2plug.zip NOTE: If there is already another version of db2plug.zip in SQLLIB\cc, you must combine the contents of the existing db2plug.zip and the DB2 Table Editor db2plug.zip. For Example, if you are using the Zip utility, use the following command: zip -r0 db2plug.zip com\rocketsoftware\myplugin\*.class Where the plug-in package name is: com.companyname.myplugin 4. Locate the db2cc file in the SQLLIB\bin. If you are using Windows, the file is named db2cc.bat. If you are using 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. The following is an example of db2cc after you have added the files: 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 6. If you are running the DB2 Control Center as a Java applet, complete the following steps: a. Copy the db2forms.jar file where the tag points to in db2cc.htm. b. Update db2cc.htm to include db2plug.zip and db2forms.jar in the archive list. You can now start Table Editor from within Control Center by selecting a DB2 Table Editor menu item from the Table popup menu or the new tool bar button. 3.3.2 INSTALLING THE DB2 TABLE EDITOR CONTROL CENTER PLUG-IN on DB2 V8 1. Copy the following files and directories to the SQLLIB\tools directory: - db2forms.jar - One or more of the following license files. – dbehost.lic – dbe400.lic – dbework.lic - dbehost.ecf (if you are working with a trial version of DB2 Table Editor) You must copy the license file that corresponds to the platform on which the DB2 database to which you want to connect resides. - HtmlHelp Directory (Including all sub folders) By default this directory is SQLLIB\tools. The Control Center requires that these files be located in the Java classpath so that they can be loaded when the Control Center is started. 2. Copy db2plug.v8zip, into SQLLIB\tools directory. 3. Rename db2plug.v8zip to: db2plug.zip Note: If there is already another version of db2plug.zip in SQLLIB\tools, you must combine the contents of the existing db2plug.zip and the DB2 Table Editor db2plug.zip. For Example, if you are using the Zip utility, use the following command: zip -r0 db2plug.zip com\rocketsoftware\ccplugin\*.* Where the plug-in package name is: com.rocketsoftware.ccplugin 4. If you are running the Control Center as a Java applet, complete the following steps: a. Copy the db2forms.jar file where the tag points to in db2cc.htm. b. Update db2cc.htm to include db2plug.zip and db2forms.jar in the archive list. You can now start Table Editor from within the DB2 Control Center by selecting a DB2 Table Editor menu item from the Table popup menu or the new tool bar button. 4.0 CONFIGURATION INSTRUCTIONS For complete instructions on how to customize and use DB2 Table Editor, refer to DB2 Table Editor for Multiplatforms User's Guide. If you received your copy of DB2 Table Editor electronically,locate the User's Guide here: http://www.ibm.com/software/data/db2imstools/library.html If you are installing this image from a CD-ROM, the documentation is located in /doc directory. The User's Guide on the Web can contain updates to the publication on CD-ROM. 5.0 RESTRICTIONS The following are the restrictions to the DB2 Table Editor functionality in Version 4.3 Fix Pack 7: - If you specify CCSID "37 (U.S. English EBCDIC)" in the ANSI Client CCSID field in the DB2 Table Editor Console component when checking for the existence of DB2 Table Editor packages, you will get the following error: "SQL error with SQL code = +100 and SQL state = 02000" Use the default, CCSID 1252 instead. - When you are connecting to an Informix database server, the Informix server must be on the same machine as your Web server. - When a DB2 error message is generated, the following error message is displayed in place of the correct error message: "CCSID-0" DB2 PTF UQ86495 has been created to resolve this problem. - When working with any ODBC data source, primary keys and cascade updates and deletes are not supported. - When using a scalar FULLSELECT SQL statement in Table Editor Developer, you may encounter a -204 error message. This error will not affect the output from the SQL statement. - When using the DB2 Table Editor Java player component, very long table, creator, and column names may be truncated. - Long names are only supported when connecting to a new DB2 (Workstation V7 or later or iSeries V5R1 or later) database when no earlier version of DB2 Table Editor and no version of QMF is being used to access the database. - In order to run the DB2 Table Editor Java Player against a DB2 V8 database, you must use Java 2. - When working with Informix databases, table locking is not available. - LOBs cannot be inserted when you are using a shared or an exclusive lock. - When accessing the DB2 Table Editor functionality through DB2 Web Query, on AIX, you can only update a primary key once per DB2 Web Query session. - When working with Informix databases, only CHARACTER data can be inserted into FOR bit data, LONGVARCHAR columns. - LOB controls are not available when connecting to an Informix server, when using the DB2 Table Editor Java player, or when using the DB2 Table Editor Control Center Plug-in. - As stated in the DB2 Universal Database Release notes (for Multiplatforms): "For version 8 clients to work with version 7 servers, you need to configure and enable the use of DRDA(R) application server capability on the version 7 server. For information on how to do this, refer to the [DB2 Universal Database] version 7 Installation and Configuration Supplement. When accessing version 7 servers from version 8 clients, there is no support available for Some data types: * Large object (LOB) data types * User-defined distinct types * DATALINK data types" You cannot use CLI connectivity to connect using a DB2 Universal Database Version 8 client (for Multiplatforms) to a DB2 Version 7 database. - Binary data cannot be read when reading data from an Informix server. Text files are supported. - In Java implementations of DB2 Table Editor (as an applet), the applet will hang if you attempt to open multiple applets at once if J2SDK 1.4.0 is installed. If you are using Microsoft Internet Explorer with the SUN Java JVM V1.4, you must upgrade to V 1.4.1_02. - If you have thousands separator and you use the 'Find' command you need to check 'match whole word only box' in order to find what you are searching for. - In order to insert 100 or more rows at a time you must change the following value in your Server Definition (SDF) file. NumDynamicSectionsForCall=100 NumDynamicSectionsWithHold=100 NumDynamicSectionsWithoutHold=100 In the example above the value of 100 indicates the number of rows that can be inserted at a time. Change this number to the number of rows that you want to insert. The maximum allowable value here is 999. - In the DB2 Table Editor Console, all creator names must be 8 characters or shorter - When calling a stored procedure the datatype of the values that are passed in must match the datatype of the input and output parameters of the stored procedure. - Cascading deletes can only be performed on Informix databases that have logging enabled. - When updating an Informix tableusing DB2 Table Editor, when inserting or updating values the Informix database only accepts the value based on the length of the field as defined in the table. If a value is entered in Table Editor that is longer than the length as defined in the database, the value will be truncated when the table is updated. - Running Informix stored procedures when using output parameters is not supported. 6 .0 CORRECTIONS TO DOCUMENTATION To obtain the latest refresh of DB2 Table Editor publications refer to: http://www.ibm.com/software/data/db2imstools/library.html 7.0 HOW TO GET HELP For a complete and up-to-date source of DB2 Table Editor information, including information on issues discovered after this readme was published, go to the following website: DB2 Table Editor Online Support: http://www.ibm.com/software/data/db2imstools/support.html If you are not able to find your answer searching the listed URL, call 1-800-IBM-SERV to speak to an IBM representative for assistance. 8.0 NOTICES This information was developed for products and services offered in the U.S.A. IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative for information on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended to state or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does not infringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of any non-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document. The furnishing of this document does not give you any license to these patents. You can send license inquiries, in writing, to: IBM Director of Licensing IBM Corporation North Castle Drive Armonk, NY 10594-1785 U.S.A. For license inquiries regarding double-byte (DBCS) information, contact the IBM Intellectual Property Department in your country or send inquiries, in writing, to: IBM World Trade Asia Corporation Licensing 2-31 Roppongi 3-chome, Minato-ku Tokyo 106, Japan The following paragraph does not apply to the United Kingdom or any ther country where such provisions are inconsistent with local law: INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties in certain transactions, therefore, this statement may not apply to you. This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; these changes will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or the program(s) described in this publication at any time without notice. Any references in this publication to non-IBM Web sites are provided for convenience only and do not in any manner serve as an endorsement of those Web sites. The materials at those Web sites are not part of the materials for this IBM product and use of those Web sites is as your own risk. Licensees of this program who want to have information about it for the purpose of enabling: (i) the exchange of information between independently created programs and other programs (including this one) and (ii) the mutual use of the information which has been exchanged, should contact: IBM Corporation J74/G4 555 Bailey Avenue San Jose, CA 95141-1003 U.S.A. Such information may be available, subject to appropriate terms and conditions, including in some cases, payment of a fee. The licensed program described in this information and all licensed material available for it are provided by IBM under terms of the IBM Customer Agreement, IBM International Program License Agreement, or any equivalent agreement between us. Any performance data contained herein was determined in a controlled environment. Therefore, the results obtained in other operating environments may vary significantly. Some measurements may have been made on development-level systems and there is no guarantee that these measurements will be the same on generally available systems. Furthermore, some measurement may have been estimated through extrapolation. Actual results may vary. Users of this document should verify the applicable data for their specific environment. Information concerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly available sources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBM products. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products. All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only. All IBM prices shown are IBM's suggested retail prices, are current and are subject to change without notice. Dealer prices may vary. This information is for planning purposes only. The information herein is subject to change before the products described become available. This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, the examples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names and addresses used by an actual business enterprise is entirely coincidental. COPYRIGHT LICENSE: This information contains sample application programs in source language, which illustrates programming techniques on various operating platforms. You may copy, modify, and distribute these sample programs in any form without payment to IBM, for the purposes of developing, using, marketing or distributing application programs conforming to the a pplication programming interface for the operating platform for which the sample programs are written. These examples have not been thoroughly tested under all conditions. IBM, therefore, cannot guarantee or imply reliability, serviceability, or function of these programs. 8.1 Other notices XMLParser.Java, AELfred, Version 1.1: AElfred, Version 1.1 Microstar's Java-Based XML Parser Copyright (c) 1997, 1998 by Microstar Software Ltd. Home page: http://www.microstar.com/XML/ Licensing Terms: "AElfred is free for both commercial and non-commercial use and redistribution, provided that Microstar's copyright and disclaimer are retained intact. You are free to modify AElfred for your own use and to redistribute AElfred with your modifications, provided that the modifications are clearly documented." Disclaimer: "This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of merchantability or fitness for a particular purpose. Please use it AT YOUR OWN RISK." WFC XMLParser "I'm just a simple little NT programmer. Most of the work I do is remote controlling equipment in real time. I started out using Windows 3.0. Then came Windows 3,1 and then NT. I started using NT but unfortunately, Microsoft didn't. I started using MFC but unfortunately, Microsoft didn't (and still doesn't) put any real support for NT into MFC so I wrote a bunch of C++ classes to make my life easier. Like all class libraries, mine grew. Now I'm giving it away. I call it Win32 Foundation Classes." 8.2 Use of evaluation program If you are using an evaluation copy of the program, the following terms apply: This program contains a disabling device that will prevent it from being used upon expiration of this license. You will not tamper with this disabling device or program. You should take precautions to avoid any loss of data that might result when the program can no longer be used. See the License Agreement terms that apply to the use of evaluation code. 8.3 Trademarks and service marks The following terms are trademarks or service marks of the IBM Corporation in the United States or other countries or both: AIX DB2 DB2 Universal Database IBM Informix iSeries z/OS zSeries Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Other company, product, and service names may be trademarks or service marks of others. (C) Copyright IBM Corporation 2001, 2005; Copyright Rocket Software, Inc., 2001.2005. All rights reserved. Note to U.S. Government Users Restricted Rights -- Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.