====== pears.WPKGetSwitchValue ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Original SQL =====
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."WPKGetSwitchValue" IS
{create function WPKGetSwitchValue
/* Application Maintained Function / Procedure - DO NOT EDIT*/
(in SwitchID char(20),in SwitchLocation char(20))
returns long varchar
begin
declare srce char(1);
declare rv long varchar;
select source into srce from wpkglobalswitch where wpkglobalswitchid = switchid;
select wpkmaintaingetswitchvalue(switchid,SwitchLocation,srce) into rv ;
return rv
end
}