File Connector
You are looking at an older version of the documentation. The latest version is found here.
The file connector, known by the type name file, exposes stored procedures to leverage file system resources exposed by the file resource adapter.
Connector-specific Connection Properties
| Property name | Description |
|---|---|
ParentDirectory | Path to the local filesystem |
AllowParentPaths | If set to FALSE, '..' in paths is disallowed, which prevents requesting files that are not contained in the parent directory; optional parameter |
Example
SQL
CALL SYSADMIN.createConnection('filealias', 'ufile', 'ParentDirectory=c:/parentDataDir');;
CALL SYSADMIN.createDatasource('filealias', 'ufile', 'importer.useFullSchemaName=false', null);;