File Connector
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);;