pears.NetGetWebEmail [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.NetGetWebEmail ======
<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"."NetGetWebEmail"( in "pWebUserID" char(20) ) 
result( "email" char(100) ) 
begin
  select "EmailAddress" as "email"
    from "iqxnetuser"
    where "IQXNetUserID" = "pWebUserID"
end /* DOC
2018-05-07 GJ Created
*/
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetGetWebEmail" IS 
{create PROCEDURE pears."NetGetWebEmail"( in "pWebUserID" char(20) )
RESULT( "email" char(100) )
BEGIN 
    SELECT 
        EmailAddress AS email 
    FROM 
        iqxnetuser 
    WHERE IQXNetUserID = pWebUserID
END
/* DOC
2018-05-07 GJ Created
*/
}
</code>