The condition OTHERWISE specifies a selection criterion which is fulfilled when the record has not been selected for any other target table.
With this condition, the "remainder" of the input file records for which no coherent selection criterion can be defined may be loaded into a specific table.
Example:
DATALOAD TABLE part1 IF POS 1 = 'a'
number 02-10 CHAR
descr 11-30
DATALOAD TABLE part2 IF POS 1 = 'b'
number 02-10 CHAR
descr 11-30
DATALOAD TABLE part3 OTHERWISE
number 02-10 CHAR
descr 11-30
INFILE ...
OTHERWISE may only be specified for the last table in a sequence of DATALOAD statements.