pears.NetOwnerGetContactEventType

CREATE PROCEDURE "pears"."NetOwnerGetContactEventType"( IN "pWebUserID" CHAR(20) ) 
/* RESULT( column_name column_type, ... ) */
BEGIN
  SELECT "classcode" AS "Value","classdescrip" AS "Descrip" FROM "pears"."contactclass"
END /* DOC
2016-08-31 PC test and doc
 
inputs:
pWebUserID
 
outputs:
Value - Primary Key
Descrip - text description
 
tests:
ensure a list is returned. There is no filtering
 
*/
/* TEST
 
select (if (select count(*) from "pears"."NetOwnerGetContactEventType"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventType"("pWebUserID" = null)) = (select count(*) from contactclass) then 'y' else 'n' endif);
expect y;
 
*/
GO
 
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetOwnerGetContactEventType" IS 
{CREATE PROCEDURE pears."NetOwnerGetContactEventType"( IN pWebUserID CHAR(20) )
/* RESULT( column_name column_type, ... ) */
BEGIN
	SELECT classcode AS VALUE, classdescrip AS Descrip FROM "pears"."contactclass"
END
 
/* DOC
2016-08-31 PC test and doc
 
inputs:
    pWebUserID
 
outputs:
    Value - Primary Key
    Descrip - text description
 
tests:
    ensure a list is returned. There is no filtering
 
*/
 
/* TEST
 
select (if (select count(*) from "pears"."NetOwnerGetContactEventType"("pWebUserID" = null)) != 0 then 'y' else 'n' endif);
expect y;
select (if (select count(*) from "pears"."NetOwnerGetContactEventType"("pWebUserID" = null)) = (select count(*) from contactclass) then 'y' else 'n' endif);
expect y;
 
*/
}