A fix is available
APAR status
Closed as program error.
Error description
When the DB2 CLI API SQLTables() is issued with a Catalog Name, in DB2 UDB Version 7.2, the CLI driver reports a CLI0150E - "Driver Not Capable" error. In DB2 UDB Version 8, the CLI drive r does not return such an error, and in most cases this causes t he API to return an empty result set. . Some third party applications will call SQLTables with a Catalog Name to see if the driver supports Catalog Names. If it fails, it will call SQLTables again, with a NULL Catalog Name. . A new db2cli.ini keyword called PATCH2=69 will be added to cause a CLI0150E error to occur when a non-NULL Catalog Name is used; or if the length of the Catalog Name is 0 bytes. This will make the call to SQLTables() consistent with the DB2 UDB Version 7.2 driver, and allow applications built around that behavior to work with DB2 UDB Version 8. .
Local fix
If possible change the application so that SQLTables() is called with a NULL for the Catalog Name.
Problem summary
Problem Description: PATCH2=69 is available to force SQLTables( ) to return CLI0150E error when non-null catalog name is passed. Users Affected: Application Developers Problem Summary: First fixed in DB2 UDB Version 8 Fixpak 11
Problem conclusion
First fixed in DB2 UDB Version 8 Fixpak 11
Temporary fix
Comments
APAR Information
APAR number
JR22401
Reported component name
DB2 CPE WINDOWS
Reported component ID
5724B5601
Reported release
820
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2005-09-16
Closed date
2006-02-03
Last modified date
2006-02-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 CPE WINDOWS
Fixed component ID
5724B5601
Applicable component levels
R820 PSN
UP
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"820"}]
Document Information
Modified date:
07 October 2021