Skip to main content

IBM DB2 for i

Identifying SQL record format identifier change (II14134)

A recent PTF corrected a problem where the Record Format Level Identifier was sometimes incorrectly generated when an SQL table contained a Date, Time, or Timestamp column. Please read Informational APAR II14134 for more background on this problem.

The following SQL script can be run from the IBM i Navigator SQL Scripts tool to determine what files are impacted by this change. The execution of this script requires the usage of system naming mode (ie, *SYS).

We're here to help

Easy ways to get the answers you need.


or call us at
1-866-883-89011-866-883-8901
Priority code:
101AR13W

DB2 Web Query

Web based query and reporting


IBM i for BI Solution

IBM i for Business Intelligence is a packaged solution that is easy to order and easy to implement, and easy to maintain. Everything you need for an out of box analytical solution based on IBM i and DB2 Web Query.