pears.NetOwnerSettingsGetSwitches [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== pears.NetOwnerSettingsGetSwitches ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code 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
}
</code>