SQL Include error when upgrading DB2 from v10 to v11
Article ID: 42114
Updated On:
Products
Issue/Introduction
Question:
We recently upgraded to version 11.6 and when running test jobs against it, the following error is occurring:
SQL INCLUDE FROM table_name
EZTC0441E >>> $ no rows found in the catalog for the given object
The jobs work correctly if the include statements are removed, but this is not a feasible solution for our programmers.
The PAN/SQL version we are on is v24c and the binds have been rerun for each DB2 system,
Answer:
Apar RO78062 resolves this problem.
PROBLEM DESCRIPTION: ADD SUPPORT FOR DB2 BIGINT
DATA TYPE Applying this PTF to PanSQL is part of
the maintenance required to enable Easytrieve
programs to process DB2 columns of the type BIGINT.
In addition to this PanSQL PTF, Easytrieve PTFs
referencing BIGINT and 8-Byte-Binary are also
required.
11.6 ADD SUPPORT FOR SQL BIGINT TYPE RO73211
11.6 ADD SUPPORT FOR SQL BIGINT TYPE RO73212
SYMPTOMS: Prior to these PTF's, PanSQL did not
recognize DB2 BIGINT columns.
Even though this was the same INCLUDE for DB2v11, that was being used for DB2v10.
It depends how the INCLUDE was created.
1. Was it created by the IBM utility DDL(Data Definition Language), or
2. Was it just copied over to the DB2v11 catalog, from the DB2v10 Catalog.
The IBM utility DDL(Data Definition Language), created a DB2 BIGINT DATA TYPE, that Easytrieve
could not handle unless Apar RO78962 was applied.
Environment
Component:
Feedback
