Retrieves a stored procedure .
Options
filename
The name of the file the stored procedure is placed in, in ASCII text format.
LOCK
Locks the procedure so it cannot be locked or unlocked by another user. When a procedure is locked, only the user placing the lock can replace the procedure. The NAME setting is used for identification of the user.
procname
The name of the procedure to retrieve.
About the GET Command
The GET command is used to read a stored procedure from the database into an ASCII file. If the LOCK option is used with the GET command, the procedure cannot be replaced by using the PUT command.
Rows are copied, not removed, from the source.
Example
The following command retrieves the SetOrderID procedure and places it into a file name SetOrdID.STP.
GET SetOrderID TO SetOrdID.STP
The following series of commands will retrieve the CreateTempTabs procedure and place it into a file name TempTabs.STP, then Edit the file, and finally replace the stored procedure from the file with an updated version.
GET CreateTempTabs TO TempTabs.STP
RBE TempTabs.STP
PUT TempTabs.STP AS CreateTempTabs
For more information on the PUT command see it's entry in the help files.
Note: The STP file extension is not required by R:BASE it is merely a suggestion for a meaningful naming convention.
