Known Issues and Restrictions

The restrictions covered here are those that are not covered elsewhere in the documentation, or that are of a temporary nature and may be removed in a later product. Other restrictions are covered in the chapter Supplementary Information for Data Express:

  • Data Express does not support the INTERVAL DATE data type because the 32-bit Oracle Driver does not support it.
  • Data Express supports LOB field types for DB2 with some restrictions. For more information, see Getting Started with z/OS Data Stores, and the topic DB2 for z/OS Environment Restrictions in this book.
  • Data Express supports XML field types for DB2 with some restrictions. For more information, see Getting Started with z/OS Data Stores, and the topic DB2 for z/OS Environment Restrictions in this book.
  • Data Express supports VARBINARY fields types for DB2 with some restrictions. For more information, see the DB2 for z/OS Environment Restrictions topic and Getting Started with z/OS Data Stores.
  • Data Express does not support LOB field types for ADABAS databases. Also, some Binary field types are not handled during ADABAS FDT analysis.
  • For DB2 tables with non-direct access, Life Cycle requires SYSPUNCH and DCLGEN to be partitioned data set (PDS) members, even though the cataloging phase supports SYSPUNCH and DCLGEN as sequential files. If you want to use Life Cycle and you have cataloged SYSPUNCH in a sequential file, you will need to delete it from the knowledge base and re-catalog it as a PDS member.
  • The Extension Technology does not support use of the parallel execution mode where multiple methods access the same tables within the target data store(s).
  • Data Express does not support sampling on true binary data.
  • Currently Data Express only shows the first 1000 distinct values and ranges, which are sorted either numerically or alphanumerically based on the data element type. When there are more than 1000 distinct data element values, the Data Element Value ends at the 1000th unique value instead of the greatest data element value.
  • Data Express uses USERID and PASSWORD to connect to the databases containing lookup tables. The password is mandatory.
  • On 64-bit platforms, Data Express runs as a 32-bit application; therefore, you must use 32-bit ODBC connections for Distributed Loader and Distributed Exporter even when running Data Express on a 64-bit platform.