company logo

FILE EXTENT keyword

The keyword can be written in capital or small letters, but not mixed. Using capital letters refers to a reserved keyword. In order to refer to the file input function from within an operation path, the from-file keyword should be used, instead.

The FILE EXTENT keyword requires a file specification as parameter:

fileExtent ( Path= file_path | PathOption= option_name ,

FileType= file_type , Headline= headline_opt,

Definition= type_def )

file_path - Complete file path to be accessed as extent

option_name - Alternatively to the file path an option name may be defined. The option must be set to the file path. The option name is also used as extent name for the external file collection . In case of XML export, it refers to the name of the root element.

file_type - File storage format ( xml , csv , oif , esdf ) when this is different from the file name extension.

headline_opt - Headline option indicates for csv or esdf files the first line contains a headline and should be ignored.

type_def - Name of data type definition defining for the collection in database. Instead of a type definition a file name for a definition file (ODL, ESDF or XML format) may be defined.

Definition: 

_fileext              := _file extent  

_file                 := 'file'         | __file

__file                :: 'FILE'

extent := 'extent'       | __extent

__extent :: 'EXTENT'