pears.NetCandidateP60sList [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetCandidateP60sList ======
<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"."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

*/
}
</code>