StarQuest Technical Documents
How to Return Result Set Column Names from a DB2 Stored Procedure
Last Update: 26 June 2008
Product: StarSQL
Version: 5.x
Article ID: SQV00SQ002
Abstract
When calling a DB2 for OS/390 stored procedure, the result set column names may not be returned to the application. If no column names are returned from DB2, StarSQL will provide default column names (i.e. Column1, Column2,...ColumnN).
Solution
If you want the client application to receive the column names of the result set from a stored procedure call, set the DESCSTAT value on the DSNTIPF panel of the DB2 host to YES. The default value for DB2 v7 and earlier is NO, for DB2 v8 and v9, the default value is YES.
Additional Information
DB2 UDB for z/OS & OS/390 Version 7
Installation Guide, Document Number GC26-9936-02
DB2 for z/OS Version 8
Installation Guide, Document Number GC18-7418-07
DB2 Version 9.1 for z/OS
Installation Guide, Document Number GC18-9846-03
DISCLAIMER
The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization. The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.