pears.NetCandidatePersonHeadline

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

Original 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;
 
*/
}