This is an old revision of the document!
The $RETRIEVE_FILE functions opens an external textual file and returns the contents. This function is most commonly used in Omnidex Text applications to index and query a catalog of external textual files. This function can also be used to simply retrieve the contents of any textual file using an Omnidex SQL statement.
This function returns a buffer using the datatype and length specified in the parameters. If no parameters are specified, then the default datatype and length are returned.
$RETRIEVE_FILE(filename [,'datatype' [,length [,'options']]])
A string literal, a column, or an expression containing the filename to retrieve.
The datatype to be used for retrieving the file’s content. Typically a CLOB or C STRING is used to retrieve ASCII data such as text.
Datatypes are specified in textual form, and may be used with or without lengths. If no lengths are specified, then they must be included in the length parameter. If no datatype is specified, then CLOB is presumed.
The length to be used for retrieving the file’s content. Lengths may also be specified in the datatype parameter using the standard Omnidex syntax. If no length is provided in either place, the length defaults to 64KB.
The options to be applied to retrieving this file.
Use the STOPWORDS list identified by this option.
Parse the keywords from the text and discard all whitespace and punctuation.