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 }