A one- to three-character file name extension to use for data files.
Valid Values
ext
where:
ext
is the name of the one- to three-character file name extension.
Behavior
This value is used for all Create Table statements. Sending a Create Table using an extension other than the value specified for this option causes an error.
In other SQL statements, such as Select or Insert, users can specify an extension other than the one specified for this connection option. The Data File Extension value is used when no extension is specified.
