pears.BlobstoreFullPath

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"."BlobstoreFullPath" IS 
{CREATE FUNCTION BlobstoreFullPath 
 
/* Application Maintained Function / Procedure - DO NOT EDIT*/
 
( IN xpath CHAR(250) )
RETURNS CHAR(250)
NOT deterministic
BEGIN
	/* if xpath is relative then prepend with the database folder */
	IF charindex(':',xpath)>0 OR LEFT(xpath,1)='/' OR LEFT(xpath,1)='\\' THEN
    RETURN xpath
 ELSE 
    RETURN BlobstoreDbFolder()+xpath
 END IF;
END
}