====== pears.sa_conn_properties_by_name ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."sa_conn_properties_by_name"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in "connidparm" varchar(255) default null ) 
result( "Number" integer,"PropNum" integer,"PropName" varchar(255),"PropDescription" varchar(255),"Value" varchar(255) ) 
begin
  declare local temporary table "t_conn_properties"(
    "Number" integer null,
    "PropNum" integer null,
    "PropName" varchar(255) null,
    "PropDescription" varchar(255) null,
    "Value" varchar(255) null,
    ) in "SYSTEM" on commit preserve rows;
  insert into "t_conn_properties" select * from "sa_conn_properties"("connidparm");
  select * from "t_conn_properties" order by "PropName" asc,"Number" asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."sa_conn_properties_by_name" IS 
{create procedure sa_conn_properties_by_name 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in connidparm varchar(255) default null)
result(Number integer,PropNum integer,PropName varchar(255),PropDescription varchar(255),Value varchar(255))
begin
  declare local temporary table t_conn_properties(
    Number integer null,
    PropNum integer null,
    PropName varchar(255) null,
    PropDescription varchar(255) null,
    Value varchar(255) null,
    )
    in SYSTEM on commit preserve rows;
  insert into t_conn_properties select * from sa_conn_properties(connidparm);
  select * from t_conn_properties order by PropName asc,Number asc
end
}
</code>