版次注意事項
|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.
[ 頁面頂端 | 前一頁 | 下一頁 | 目錄 | 索引 ]