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

CALL SYSADMIN.createConnection('filealias', 'ufile', 'ParentDirectory=c:/parentDataDir');;
CALL SYSADMIN.createDatasource('filealias', 'ufile', 'importer.useFullSchemaName=false', null);;