pears.NetOwnerGetContactEventType [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.NetOwnerGetContactEventType ======
<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"."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;

*/
}
</code>