pears.ReportImageFetch

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

Original SQL

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."ReportImageFetch" IS 
{CREATE FUNCTION ReportImageFetch 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( IN ReportImageName CHAR(50) ) 
RETURNS long BINARY
BEGIN
  RETURN blobstorefetch('R',(SELECT FIRST reportid FROM report WHERE filename=ReportImageName ORDER BY 1));
END
}