====== pears.NetReportCombo_gender ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create procedure "pears"."NetReportCombo_gender"( in "pWebUserID" char(20) ) result( "Description" char(250),"Value" char(250) ) begin select 'Male','M' union all select 'Female','F' end go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetReportCombo_gender" IS {create procedure pears."NetReportCombo_gender"( in "pWebUserID" char(20) ) result( "Description" char(250),"Value" char(250) ) begin select 'Male','M' union all select 'Female','F' end }