pears.IQXNetUserHeadline

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Original SQL

CREATE FUNCTION "pears"."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