PBA(Bind Analyzer for Db2) was implemented recently. In the Endeavor environment, COBOL programs are promoted and most of them have DB2 SQL statements. There is a need to compare and synchronize the db2 data names and their characteristics as they are produced by DB2 pre-compiler with the DB2 DDL information (SYSIBM.SYSCOLUMNS). Can the above comparison be executed using the bind analyzer for DB2 ?
Release : 20.0
PBA does not currently have a capability to compare the DBRM host variables to the column definition in the catalog. However, PBA does have the ability to compare the precompile DBRM with the bound package DBRM in the Db2 catalog to detect any differences in the SQL and/or host variable information. That is the extent of the catalog comparison reporting that is currently supported.