Add the following columns to the section “SYSPROCEDURE system table” in Chapter 10, “System Tables.”
source LONG VARCHAR, avg_num_rows FLOAT, avg_costs FLOAT, stats LONG BINARY,
source This column contains the original source for the procedure if the PRESERVE_SOURCE_FORMAT option is ON. It is used to maintain the appearance of the original text. For more information, see “PRESERVE_SOURCE_FORMAT option [database]” in Chapter 2, “Database Options.”
avg_num_rows Information collected for use in query optimization when the procedure appears in the FROM clause.
avg_cost Information collected for use in query optimization when the procedure appears in the FROM clause.
stats Information collected for use in query optimization when the procedure appears in the FROM clause.
