pears.NetDockerGetConfig

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
*/
}