IQX Quick Menu

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

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

pears.BlobstoreFullPath

Original SQL

iqx