DSNT095I   DSNTXTB REQUEST CANCELLED BECAUSE TABLE schema-name.table-name IS NOT IN THE REQUIRED FORMAT AT COLUMN NUMBER column-number. EXPECTED: expected-format. FOUND: actual-format.

Explanation

While analyzing a table, DSNTXTB encountered a column that has an unexpected name or attribute.

schema-name
The name of the table schema or creator.
table-name
The name of the table.
column-number
The location of the unexpected name or attribute.
expected-format
The format that is required for the name or attribute.
actual-format
The format that is used for the name or attribute.

System action

Processing terminates.

User response

  1. Query SYSIBM.SYSCOLUMNS, and inspect the column names and attributes of the table. For example, use the following query:
    SELECT NAME, COLNO,
    CASE COLTYPE 
      WHEN 'TIMESTMP' THEN 'TIMESTAMP'
      ELSE COLTYPE
    END,
  LENGTH ,LENGTH2 
  FROM SYSIBM.SYSCOLUMNS 
  WHERE TBCREATOR = 'schema-name' 
  AND TBNAME = 'table-name' 
  ORDER BY COLNO;

    Use the information about SYSIBM.SYSCOLUMNS to help you locate the structural problem.

  2. If you suspect that the table might not be an EXPLAIN table, review the list of EXPLAIN tables. Compare your table to the expected table of the same name. If the table is not an EXPLAIN table, consider renaming it.
  3. If the table is an EXPLAIN table, it is not in the expected format and you must correct the discrepancy. You can either:
    • Alter the table to conform to the format described for the table.
    • Rename the existing table, create a replacement table with the appropriate name in the expected format, and copy the data from the original table to the replacement. When you have confirmed the contents of the replacement table, drop the original table.

Severity

8 (error)