pears.IQacJournalDescription

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

Original SQL

CREATE FUNCTION "pears"."IQacJournalDescription"( IN "DocID" CHAR(8),IN "LineNo" SMALLINT ) 
RETURNS long VARCHAR
BEGIN
  DECLARE "rv" long VARCHAR;
  SELECT FIRST "description" INTO "rv" FROM "iqacjournal" WHERE "documentid" = "docid" AND "linenumber" = "lineno";
  RETURN "rv"
END