Question & Answer
Question
The "USING DESCRIPTOR" clause was documented in the V8.2 manual, but it is not found in the V10.5 manual. We searched the words, "USING DESCRIPTOR" in the V10.5 Knowledge Center but could not find any matches related to the CALL statement. Can we collect data using SQLDA and SQLCA by issuing a CALL statement with the "USING DESCRIPTOR" clause on V10.5 as we could on V8.2?
Answer
The "USING DESCRIPTOR" clause is no longer supported as of DB2 V8.1. Here is a snippet
of the V8.2 SQL Reference Volume 1 for reference:
----------
Appendix M. CALL invoked from a compiled statement
Invokes a procedure stored at the location of a database. A
stored procedure, for example, executes at the location of the
database, and returns data to the client application.
Programs using the SQL CALL statement are designed to run in two
parts, one on the client and the other on the server. The server
procedure at the database runs within the same transaction as the
client application. If the client application and stored procedure
are on the same partition, the stored procedure is executed
locally.
Note: This form of the CALL statement is deprecated, and is only
being provided for compatibility with previous versions of DB2.
... snip ...
Syntax:
CALL procedure-name
host-variable
host-variable
USING DESCRIPTOR descriptor-name
----------
As mentioned as above, the statement is deprecated in V8.2 and has been since
V8.1. Appendix M was removed from the documentation in V10.1.
Note:
Please contact your Sales Rep to submit a potential design change towards a future
release. Or please open a ticket, Request For Enhancement at
https://www.ibm.com/developerworks/rfe/
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21985925