This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
dev:sql:functions:retrieve_file [2011/01/26 03:07] els |
dev:sql:functions:retrieve_file [2016/06/28 22:38] (current) |
||
---|---|---|---|
Line 20: | Line 20: | ||
=== datatype === | === datatype === | ||
- | 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. | + | The datatype to be used for retrieving the file’s content. Typically a CLOB or 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. | 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. | ||
Line 40: | Line 40: | ||
Parse the keywords from the text and discard all whitespace and punctuation. | Parse the keywords from the text and discard all whitespace and punctuation. | ||
- | ==== Example ==== | + | ==== Examples ==== |
- | === Example 1 === | + | === Example 1: Retrieving from a named file === |
+ | |||
+ | This example retrieves the contents of a single, named file. Note that this example retrieves from the table $OMNIDEX. $OMNIDEX is a virtual table that is always available that contains a single virtual row. It is available for purposes such as these. | ||
+ | |||
+ | <code> | ||
+ | select $retrieve_file('star.sql', 'c string(4KB)') | ||
+ | from $OMNIDEX; | ||
+ | </code> | ||
+ | |||
+ | === Example 1: Retrieving from a named file === | ||
+ | |||
+ | This example relies on the LIBRARY table containing a FILENAME column. This FILENAME column contains a different filename for each row. This statement will retrieve the contents of each file as each row is retrieved. | ||
+ | |||
+ | <code> | ||
+ | select $retrieve_file(FILENAME, 'c string(4KB)') | ||
+ | from LIBRARY; | ||
+ | </code> | ||
+ | |||
{{page>:bottom_add&nofooter&noeditbtn}} | {{page>:bottom_add&nofooter&noeditbtn}} |