版次注意事項


|10.24 PUT ROUTINE (new command)

|PUT ROUTINE

|Uses the specified routine SQL Archive (SAR) file to define a routine in |the database.

|Authorization

|dbadm

|Required Connection

|Database. If implicit connect is enabled, a connection to the default database |is established.

|Command Syntax

|>>-PUT ROUTINE----FROM----file-name----------------------------->
| 
|>-----+---------------------------------------+----------------><
|      '-OWNER--new-owner--+----------------+--'
|                          '-USE REGISTERS--'
| 

|Command Parameters |

|FROM file-name
|Names the file where routine SQL archive (SAR) is stored.

|OWNER new-owner
|Specifies a new authorization-name for the routine that will be used |for authorization checking of the routine. The new-owner must have the necessary |privileges for the routine to be defined. If the OWNER clause is not specified, |the authorization-name that originally defined the routine is used.

|USE REGISTERS
|Indicates that the CURRENT SCHEMA and CURRENT PATH special registers |are used to define the routine. If this clause is not specified, the settings |for the default schema and SQL path are the settings used when the routine |was originally defined. CURRENT SCHEMA is used as the schema name for unqualified |object names in the routine definition (including the name of the routine) |and CURRENT PATH is used to resolve unqualified routines and data types in |the routine definition. |

|Examples

|     PUT ROUTINE FROM procs/proc1.sar;

|Usage Notes

|No more than one procedure can be concurrently installed under a given |schema.


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