版次注意事項


10.14 CALL

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:

  1. 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.

  2. The stored procedure being called must be uniquely named in the database.

  3. The stored procedure must be cataloged. If an uncataloged procedure is called, a DB21036 error message is returned.

  4. 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.

  5. There is a maximum of 1023 characters for a result column.

  6. LOBS and binary data (FOR BIT DATA, VARBINARY, LONGVARBINARY, GRAPHIC, VARGAPHIC, or LONGVARGRAPHIC) are not supported.

  7. CALL supports result sets.

  8. If an SP with an OUTPUT variable of an unsupported type is called, the CALL fails, and message DB21036 is returned.

  9. The maximum length for an INPUT parameter to CALL is 1024.


[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]