pears.NetGetRegRequired

CREATE PROCEDURE "pears"."NetGetRegRequired"( IN "pWebUserID" CHAR(20) ) 
RESULT( "JSON" CHAR(255) ) 
BEGIN
  SELECT "TextValue" AS "JSON"
    FROM "IQXNetSwitch"
    WHERE "IQXNetSwitchID" = 'REGREQ'
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetGetRegRequired" IS 
{CREATE PROCEDURE pears."NetGetRegRequired"( IN "pWebUserID" CHAR(20) ) 
RESULT("JSON" CHAR(255))
BEGIN
	SELECT
	    TextValue AS [JSON]
	FROM
	    IQXNetSwitch
	WHERE   
	    IQXNetSwitchID = 'REGREQ';
END
}