pears.IQXNetSwitchValue

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"."IQXNetSwitchValue" IS 
{CREATE FUNCTION 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
}