database:functions:pears_iqacjournaldescription



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
  • database/functions/pears_iqacjournaldescription.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1