版次注意事項


10.18 GET ROUTINE (new command)

GET ROUTINE

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;


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