====== pears.WPKGetSwitchValue ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create function "pears"."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