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 Informix® 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 Informix is %r.