search cancel

SQL Include error when upgrading DB2 from v10 to v11

book

Article ID: 42114

calendar_today

Updated On:

Products

PanAudit Plus Easytrieve Report Generator PAN/SQL

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

Release: PSQLOR00200-2.4-Pan/SQL-for Oracle
Component: