IBM Support

DB2 Table Editor Version 4.3 Fix Pack 5 Restrictions

Question & Answer


Question

The following document contains the restrictions to DB2® Table Editor V4.3 Fix Pack 5.

Answer

The following are the restrictions to the DB2 Table Editor functionality in Version 4.3 Fix Pack 5:

  • 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 receive 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 including Informix databases, primary keys and cascade updates and deletes are not supported.
  • When using a scalar fullselect SQL statement in Table Editor Developer, you might 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.
  • ODBC connectivity can only be used to connect to Informix Databases.
  • In order to run the DB2 Table Editor Java Player against a DB2 V8 database, you must use Java 2.
  • 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.
  • When working with Informix databases, primary key columns are treated like regular 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 Plugin.
  • 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

Related Information

DB2 Table Editor Fix Pack

[{"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"DB2 Table Editor","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
11 February 2021

UID

swg21170424

Page Feedback