Browse Prior Art Database

A Method for Describing Static SQL Statements at Execution Time

IP.com Disclosure Number: IPCOM000014855D
Original Publication Date: 2000-Dec-01
Included in the Prior Art Database: 2003-Jun-20
Document File: 2 page(s) / 41K

Publishing Venue

IBM

Abstract

This disclosure shows a method to support SQL DESCRIBE requests for static SQL statements at execution time and how the results of these requests can be cached, if such facilities exist, in order to speed up future DESCRIBE requests for the same statement. This method allows for ad hoc DESCRIBE requests on any static SQL statement without any setup or coordination prior to execution while keeping the system overhead to a minimum. With the addition of a caching capability, the impact of requesting describe information for static SQL statements is further minimized.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 52% of the total text.

Page 1 of 2

A Method for Describing Static SQL Statements at Execution Time

This disclosure shows a method to support SQL DESCRIBE requests for static SQL statements at execution time and how the results of these requests can be cached, if such facilities exist, in order to speed up future DESCRIBE requests for the same statement. This method allows for ad hoc DESCRIBE requests on any static SQL statement without any setup or coordination prior to execution while keeping the system overhead to a minimum. With the addition of a caching capability, the impact of requesting describe information for static SQL statements is further minimized.

An SQL DESCRIBE request returns detailed information, referred to as describe information, on the output of an SQL statement such as the column names and column data types of the result set. Traditionally, this information is not available for static SQL statements due to the excessive catalog storage requirements required to contain the describe information. By providing the capability to DESCRIBE static SQL statements at execution time, the describe information does not have to be collected at compilation time and stored in the system catalogs. This latter action significantly increases the size of the system catalogs since it is not known at compilation time which static SQL statements will need to be described in the future so describe information must be collected for all static SQL statements. The method outlined in this disclosure only provides describe information...