====== 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 }