pears.NetGetWebUserIDs

CREATE PROCEDURE "pears"."NetGetWebUserIDs"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) DEFAULT NULL ) 
RESULT( "pWebUserID" CHAR(20),"PersonID" CHAR(20) ) 
// IQXWeb
BEGIN
  SELECT "pWebUserID",
    "NetCandidateValidPersonID"("pWebUserID","pPersonID") AS "PersonID"
    FROM "dummy"
END /* DOC
2017-11-07 GJ Created - Probably needs tweaking
2018-10-22 MHS IW-456 multi-cand fix 
 
Inputs:
pWebUserID
 
Outputs:
pWebUserID
pPersonID
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetGetWebUserIDs" IS 
{CREATE PROCEDURE pears."NetGetWebUserIDs"( IN pWebUserID CHAR(20), IN pPersonID CHAR(20) DEFAULT NULL ) 
RESULT( pWebUserID CHAR(20), PersonID CHAR(20) ) 
// IQXWeb
BEGIN
    SELECT 
        pWebUserID,
        NetCandidateValidPersonID(pWebUserID,pPersonID) AS PersonID
    FROM
        dummy
END
 
/* DOC
2017-11-07 GJ Created - Probably needs tweaking
2018-10-22 MHS IW-456 multi-cand fix 
 
Inputs:
    pWebUserID
 
Outputs:
    pWebUserID
    pPersonID
 
*/
}