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