====== pears.NetDockerGetConfig ======
<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"."NetDockerGetConfig"( in "pWebUserID" char(20) ) 
result( "theName" char(20),"theValue" long varchar ) 
begin
  select distinct
    "s"."WPKGlobalSwitchID" as "theName",
    "WPKMaintainGetSwitchValue"("s"."wpkglobalSwitchID",'Global',"source") as "theValue"
    from "wpkglobalswitch" as "s"
      left outer join "WPKGlobalSwitchAltGroup" as "g" on "s"."wpkglobalswitchid" = "g"."wpkglobalswitchid"
    where "s"."source" in( 'L','P' ) 
    and "isnull"("s"."locked",0) = 0
    and("s"."WPKGlobalSwitchGroupID" in( 'WEBGENERAL','WEBSERVER','WEBAPI','PASSWORDOPTIONS','REGWIZARD' ) or "s"."WPKGlobalSwitchGroupID" in( 'WEBGENERAL','WEBSERVER','WEBAPI','PASSWORDOPTIONS','REGWIZARD' ) )
end /* DOC
2020-09-08 GJ/MHS Created Docker Proc for getting config
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetDockerGetConfig" IS 
{create PROCEDURE NetDockerGetConfig( IN pWebUserID CHAR(20) ) 
RESULT( theName CHAR(20), theValue LONG VARCHAR ) 
BEGIN
  
    SELECT DISTINCT 
        s.WPKGlobalSwitchID as theName, 
        WPKMaintainGetSwitchValue(s.wpkglobalSwitchID,'Global',source) as theValue
    FROM 
        wpkglobalswitch s 
    LEFT OUTER JOIN 
        WPKGlobalSwitchAltGroup g on s.wpkglobalswitchid = g.wpkglobalswitchid
    WHERE 
        s.source in ('L','P') 
        AND 
        isnull(s.locked,0)=0 
        AND (s.WPKGlobalSwitchGroupID in ('WEBGENERAL', 'WEBSERVER', 'WEBAPI', 'PASSWORDOPTIONS', 'REGWIZARD') OR s.WPKGlobalSwitchGroupID in ('WEBGENERAL', 'WEBSERVER', 'WEBAPI', 'PASSWORDOPTIONS', 'REGWIZARD'))

END

/* DOC
  2020-09-08 GJ/MHS Created Docker Proc for getting config
*/
}
</code>