pears.NetCandidatePersonHeadline [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.NetCandidatePersonHeadline ======
<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"."NetCandidatePersonHeadline"( in "pWebUserID" char(20),in "pPersonID" char(20) default null ) 
result( "pHeadline" long varchar ) 
// IQXWeb
begin
  set "pPersonID" = "NetCandidateValidPersonID"("pWebUserID","pPersonID");
  select "PersonHeadline"("pPersonID")
end /* DOC
2017-06-06 PC Test and doc
2018-03-28 PC insert top 1 into subquery
2018-10-22 MHS IW-456 multi-cand fix and tests
*/
/* TEST
call NetTestSetup('');
select * from NetCandidatePersonHeadline('test.candidate');
expect row;

*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidatePersonHeadline" IS 
{create PROCEDURE pears."NetCandidatePersonHeadline"(pWebUserID char(20),in pPersonID char(20) default null)
RESULT(pHeadline long varchar )
// IQXWeb
BEGIN
  set pPersonID=NetCandidateValidPersonID(pWebUserID,pPersonID);
	select PersonHeadline(pPersonID); 
END

/* DOC
2017-06-06 PC Test and doc
2018-03-28 PC insert top 1 into subquery
2018-10-22 MHS IW-456 multi-cand fix and tests
*/

/* TEST
call NetTestSetup('');
select * from NetCandidatePersonHeadline('test.candidate');
expect row;

*/
}
</code>