Product specifications

• DISTINCT clause within SELECT statement

• UNION and UNION ALL

Note:

The ORDER BY operation depends on the Bucket Split Size SBO parameter.

The data access driver also supports the MIN, MAX, AVG, SUM, and COUNT grouping functions in SELECT

statements.

Driver limitations

The CSV OpenDriver does not implement any functionality for altering the state of the CSV file, such

as INSERT, UPDATE and ALTER. The data access driver also does not support indexes or JOIN

operations on CSV files.

Related Topics

• Bucket Split Size

6.1.2 File location

CSV files used as data sources can be ether local or remote. For files on remote systems, the HTTP,

FTP, and SMB (also known as CIFS) protocols are supported. The HTTPS and FTPS encrypted protocols

are not supported in this release.

Note:

SMB is the standard file sharing protocol on MS Windows. Since the jCIFS library provides access to

the protocol, you must install the jCIFS JAR file in the data access driver directory, that is connection

server-install-dir\connectionServer\open\drivers\open. The version to install is 1.3.15.

It is available at http://jcifs.samba.org/.

You can set whether the data source is local or remote through the Location Type parameter of the

connection wizard. If the data source is remote, you must set the protocol used through the Protocol

parameter of the wizard. The Protocol value must match the protocol specified in the Filepath or

Pattern and Schema File parameter values.

Example: CSV file paths

The following examples illustrate the possible paths of CSV files.

• C:\csv\report.csv for a local file

• http://server:8080/path/ for files accessible through HTTP

• ftp://server/path/ for files accessible through FTP

• smb://server:port/myshare/mydirectory for files accessible through SMB