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