Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE EXTERNAL TABLE StatementUse the CREATE EXTERNAL TABLE statement to define an external source that is not part of your database to load and unload data for your database.
DATAFILES ClauseThe DATAFILES clause specifies the operating system file or pipe that is opened when you use an external table.
Using Formatting Characters with External TablesYou can use a formatted path name to designate a file name by using the substitution character %r (first ..last).

Using Formatting Characters with External Tables

You can use a formatted path name to designate a file name by using the substitution character %r (first ..last).

Formatting String

Effect

%r(first ..last)

Specifies multiple files on the HCL OneDB™ server for the external table.

The first and last arguments represent a range of values that are substituted in the expression when the statement is run. For example, specifying my_file.%r(1..3) expands to:

my_file.1

my_file.2

my_file.3

The only supported formatting character supported by HCL OneDB is %r.