PUT
Top  Previous  Next

Loads a procedure into the database.

put

Options

argname datatype
The parameter name and datatype. This portion may be reported.

comment

An optional comment for the parameter or, if placed after RETURN, an optional comment for the entire procedure. The comment must be enclosed in the current quote setting.

filename

The filename in ASCII text format, with full path, to load as the stored procedure.

procname

The procedure name. If a procedure by this name already exists in the database, an error is generated.

RETURN datatype

Determines the datatype of the value returned by the procedure.

About the PUT Command

The PUT command is used to create or replace Stored Procedures.

If you are replaceing an existing procedure, you must LOCK the procedure first either with the GET LOCK or the SET PROCEDURE command. Once the procedure is locked, it is replaced by an updated file using the PUT command. A procedure cannot be replaced unless it is locked. A procedure is automatically unlocked when replaced with the PUT command.