pears.NetCandidateP45sList

CREATE PROCEDURE "pears"."NetCandidateP45sList"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "p45id" CHAR(20),"leavingdate" DATE,"employernameandaddress" long VARCHAR,"p45Path" CHAR(255) ) 
BEGIN
  // iqxWEB
  IF EXISTS(SELECT * FROM "sysobjects" WHERE "name" = 'SoftNetDummyCandidateP45sList') THEN
    SELECT "p45id","leavingdate","employernameandaddress","p45Path" FROM "SoftNetDummyCandidateP45sList"("pWebUserID") ORDER BY "leavingdate" DESC
  ELSE IF EXISTS(SELECT * FROM "sysobjects" WHERE "name" = 'SoftNetCandidateP45sList') THEN
      SELECT "p45id","leavingdate","employernameandaddress","p45Path" FROM "SoftNetCandidateP45sList"("pWebUserID") ORDER BY "leavingdate" DESC
    ELSE
      SELECT NULL,NULL,NULL,NULL FROM "dummy"
    END IF
  END IF
END /* DOC
 
2020-08-04 JG created
 
*/
/* TEST
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidateP45sList" IS 
{CREATE PROCEDURE pears."NetCandidateP45sList"( IN pWebUserID CHAR(20), IN pPersonID CHAR(20) )
RESULT(p45id CHAR(20), leavingdate DATE, employernameandaddress long VARCHAR, p45Path CHAR(255))
BEGIN
  // iqxWEB
    IF EXISTS(SELECT * FROM sysobjects WHERE name='SoftNetDummyCandidateP45sList') THEN
        SELECT p45id, leavingdate, employernameandaddress, p45Path FROM SoftNetDummyCandidateP45sList(pWebUserID) ORDER BY leavingdate DESC
    ELSE IF EXISTS(SELECT * FROM sysobjects WHERE name='SoftNetCandidateP45sList') THEN
        SELECT p45id, leavingdate, employernameandaddress, p45Path FROM SoftNetCandidateP45sList(pWebUserID) ORDER BY leavingdate DESC
    ELSE
        SELECT NULL, NULL, NULL, NULL FROM dummy 
    END IF;
    END IF;
END
 
/* DOC
 
2020-08-04 JG created
 
*/
 
/* TEST
 
*/
}