版次注意事項
Retrieves a routine SQL Archive (SAR) file for a specified SQL routine.
Authorization
dbadm
Required Connection
Database. If implicit connect is enabled, a connection to the default database
is established.
Command Syntax
>>-GET ROUTINE--INTO---file_name----FROM----+-----------+------->
'-SPECIFIC--'
>-------PROCEDURE----routine_name------------------------------><
Command Parameters
- INTO file-name
- Names the file where routine SQL archive (SAR) is stored.
- FROM
- Indicates that start of the specification of the routine to be retrieved.
- SPECIFIC
- The specified routine-name is given as
a specific name.
- PROCEDURE
- The routine is an SQL procedure.
- routine-name
- The name of the procedure. If SPECIFIC is specified then it is the specific
name of the procedure. If the name is not qualified with a schema name, the
CURRENT SCHEMA is used as the schema name of the routine. The routine-name must be an existing procedure that is defined as an SQL
procedure.
Examples/STRONG>
GET ROUTINE INTO procs/proc1.sar FROM PROCEDURE myappl.proc1;
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]