pears.IQXNetSwitchValue

CREATE FUNCTION "pears"."IQXNetSwitchValue"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  IN "pWebUserID" CHAR(20),IN "pIQXNetSwitchID" CHAR(50) ) 
RETURNS CHAR(250)
NOT deterministic
BEGIN
  DECLARE "irv" INTEGER;
  DECLARE "rv" CHAR(250);
  DECLARE "xIQXNetUserClassID" CHAR(20);
  SELECT "IQXNetUserClassID" INTO "xIQXNetUserClassID" FROM "IQXNetUser" WHERE "IQXNetUserID" = "pWebUserID";
  SELECT "nullif"("IQXNetOverrideSwitchValue"("xIQXNetUserClassID","pWebUserID","IQXNetSwitchID","Value"),0),
    "nullif"("trim"("IQXNetOverrideSwitchTextValue"("xIQXNetUserClassID","pWebUserID","IQXNetSwitchID","TextValue")),'')
    INTO "irv","rv" FROM "IQXNetSwitch" WHERE "IQXNetSwitchID" = "pIQXNetSwitchID";
  IF "irv" IS NOT NULL THEN
    RETURN "isnull"("rv","string"("irv"))
  END IF
END