Results of Defining Structures Using SQL Statements › CREATE PROCEDURE Statement

CREATE PROCEDURE Statement

CREATE PROCEDURE

Creates a procedure. The following are the significant PROCEDURE entity-occurrence attributes defined:

• AUTHID= The authorization identifier (the schema) in effect when the SQL CREATE statement was executed.
• CREATOR= The accessor ID assigned at the SQL CREATE statement execution.
• DETERMINISTIC= Indicates that the procedure does (Y) or does not (N) return the same value given the same input (whether a procedure can provide different results due to factors other than the data). This attribute is informational only.
• ENTITY-NAME= This is an internally generated unique name consisting of the schema (the AUTHID), followed by a hyphen, followed by the SQLNAME value.
• EXTERNAL= If the procedure causes an external module to be executed, this attribute is set to Y. Otherwise, if the procedure directly executes SQL statements, this attribute is set to N.
• FIPS= Indicates if the procedure is valid in FIPS processing. Y indicates yes, N indicates no, and S indicates no because of syntax.
• LANGUAGE= The programming language used to produce the module executed when the procedure is invoked.
• PARM-LIST-STYLE= The style of the parameter list to be passed to the procedure module by SQL: GENERAL, GENERAL WITH NULLS, or DATACOM SQL.
• PRC-VALID=Y When a change is made to a program referenced by a procedure, this attribute is set to N.
• SQLNAME= The name of the procedure as specified in the CREATE PROCEDURE statement.
• SQL-ACCESS= Indicates whether the procedure executed contains SQL statements and whether SQL performs only read function (READ), read and updated functions (MODIFY), or only other SQL functions such as DDL (YES). If no SQL is executed, the value is NO.