版次注意事項
The syntax for the CALL command should appear as follows:
.-,---------------.
V |
>>-CALL--proc-name---(-----+-----------+--+---)----------------><
'-argument--'
The description of the argument parameter has been changed
to:
Specifies one or more arguments for the stored procedure.
All input and output arguments must be specified in the order
defined by the procedure. Output arguments are specified
using the "?" character. For example, a stored procedure foo
with one integer input parameter and one output parameter
would be invoked as "call foo (4, ?)".
Note:
- When invoking this utility from an operating system prompt, it may be
necessary to delimit the command as follows:
"call DEPT_MEDIAN (51)"
A single quotation mark (') can also be used.
- The stored procedure being called must be uniquely named in the database.
- The stored procedure must be cataloged. If an uncataloged procedure is
called, a DB21036 error message is returned.
- A DB21101E message is returned if not enough parameters are specified
on the command line, or the command line parameters are not in the correct
order (input, output), according to the stored procedure definition.
- There is a maximum of 1023 characters for a result column.
- LOBS and binary data (FOR BIT DATA, VARBINARY, LONGVARBINARY, GRAPHIC,
VARGAPHIC, or LONGVARGRAPHIC) are not supported.
- CALL supports result sets.
- If an SP with an OUTPUT variable of an unsupported type is called,
the CALL fails, and message DB21036 is returned.
- The maximum length for an INPUT parameter to CALL is 1024.
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]