pears.NetCandidateP60sList

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original SQL

CREATE PROCEDURE "pears"."NetCandidateP60sList"( IN "pWebUserID" CHAR(20),IN "pPersonID" CHAR(20) ) 
RESULT( "p60id" CHAR(20),"ninumber" CHAR(20),"employer" CHAR(255),"p60Path" CHAR(255) ) 
BEGIN
  // iqxWEB
  IF EXISTS(SELECT * FROM "sysobjects" WHERE "name" = 'SoftNetDummyCandidateP60sList') THEN
    SELECT "p60id","ninumber","employer","p60Path" FROM "SoftNetDummyCandidateP60sList"("pWebUserID") ORDER BY "p60id" DESC
  ELSE IF EXISTS(SELECT * FROM "sysobjects" WHERE "name" = 'SoftNetCandidateP60sList') THEN
      SELECT "p60id","ninumber","employer","p60Path" FROM "SoftNetCandidateP60sList"("pWebUserID") ORDER BY "p60id" 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"."NetCandidateP60sList" IS 
{CREATE PROCEDURE pears."NetCandidateP60sList"( IN pWebUserID CHAR(20), IN pPersonID CHAR(20) )
RESULT(p60id CHAR(20), ninumber CHAR (20), employer CHAR (255), p60Path CHAR(255))
BEGIN
  // iqxWEB
    IF EXISTS(SELECT * FROM sysobjects WHERE name='SoftNetDummyCandidateP60sList') THEN
        SELECT p60id, ninumber, employer, p60Path FROM SoftNetDummyCandidateP60sList(pWebUserID) ORDER BY p60id DESC
    ELSE IF EXISTS(SELECT * FROM sysobjects WHERE name='SoftNetCandidateP60sList') THEN
        SELECT p60id, ninumber, employer, p60Path FROM SoftNetCandidateP60sList(pWebUserID) ORDER BY p60id DESC
    ELSE
        SELECT NULL, NULL, NULL, NULL FROM dummy 
    END IF;
    END IF;
END
 
/* DOC
 
2020-08-04 JG created
 
*/
 
/* TEST
 
*/
}