pears.IQXNetUserHeadline [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.IQXNetUserHeadline ======
<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>
COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."IQXNetUserHeadline" IS 
{create function IQXNetUserHeadline( 
  in "pWebUserID" char(20) ) 
returns long varchar
begin
  declare "userClass" char(20);
  declare "personName" char(200);
  set "userClass" = (select first "iqxnetuserclassid" from "iqxnetuser" where "iqxnetuserid" = "pWebUserID");
  set "personName" = (select "person"."forenames" from "iqxnetuser" key join "iqxnetuserlink" key join "person" where "iqxnetuser"."iqxnetuserid" = "pWebUserID");
  return "string"('<h2> Hello ',"personName",', welcome to your portal.</h2>')
end
}
</code>