====== pears.NetCandidatePersonWebHeadline ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Original SQL ===== create procedure "pears"."NetCandidatePersonWebHeadline"( in "pWebUserID" char(20) ) result( "pHeadline" long varchar ) // IQXWeb begin select "IQXNetUserHeadline"("pWebUserID") end /* DOC 2020-06-07 GJ IW-1192 2020-07-24 ET IW-1192 Changed to pass pWebuserID instead of personID to IQXNetUserHeadline as it is expecting an iqxnetuserID not a personID */ /* TEST call NetTestSetup(''); select * from NetCandidatePersonWebHeadline('test.candidate'); expect row; */ go COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetCandidatePersonWebHeadline" IS {create PROCEDURE pears."NetCandidatePersonWebHeadline"(pWebUserID char(20)) RESULT(pHeadline long varchar ) // IQXWeb BEGIN select IQXNetUserHeadline(pWebUserID); END /* DOC 2020-06-07 GJ IW-1192 2020-07-24 ET IW-1192 Changed to pass pWebuserID instead of personID to IQXNetUserHeadline as it is expecting an iqxnetuserID not a personID */ /* TEST call NetTestSetup(''); select * from NetCandidatePersonWebHeadline('test.candidate'); expect row; */ }