pears.NetOwnerSettingsGetSwitches

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE PROCEDURE "pears"."NetOwnerSettingsGetSwitches"( IN "pWebUserID" CHAR(20) ) 
RESULT( "name" CHAR(255),"description" long VARCHAR,"value" SMALLINT ) 
BEGIN
  IF NOT "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
    SELECT "IQXNetSwitchID" AS "name","Description" AS "description","Value" AS "value" FROM "pears"."IQXNetSwitch"
      ORDER BY "name" ASC
  ELSE
    SELECT '99:~Permission denied','',''
  END IF
END
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerSettingsGetSwitches" IS 
{CREATE PROCEDURE pears."NetOwnerSettingsGetSwitches"( IN "pWebUserID" CHAR(20)) 
RESULT( "name" CHAR(255),"description" long VARCHAR,"value" SMALLINT )
BEGIN
    IF NOT "IQXNetHasPermission"("pWebUserID",'APIDESIGN') = 0 THEN
        SELECT IQXNetSwitchID AS name, Description AS description, VALUE AS VALUE FROM "pears"."IQXNetSwitch"
        ORDER BY name
    ELSE
        SELECT '99:~Permission denied', '', '';
    END IF;
END
}