How to ignore a column in loader

[shibha]

Can anyone give me syntax on how to ignore a data column while loading data ?

Here's the part of control file :

LOAD DATA
INTO TABLE tablename
APPEND
TRAILING NULLCOLS
(
COUNTRY_CODE CHAR TERMINATED BY X'09',
FROM_MAILCODE CHAR TERMINATED BY X'09',
TO_MAILCODE CHAR TERMINATED BY X'09',
DEST_CODE CHAR TERMINATED BY X'09'
)

Here's the data format, tab separated fields. I want to ignore the country description while loading :

AR Argentinia 2451 2451 ROS
AR Argentinia 2500 2500 COR
AR Argentinia 2550 2550 ROS

Thanks in advance.

[ramkii]

Hi,

Try using column POSITION to ignore the field.

Thanks.
Ramki

[shibha]

Unfortunately column lengths are variable.

[culonbu]

you can use FILLER to suppress column


LOAD DATA
INTO TABLE tablename
APPEND
TRAILING NULLCOLS
(
COUNTRY_CODE CHAR TERMINATED BY X'09',
FROM_MAILCODE CHAR TERMINATED BY X'09' FILLER, <<<<<<<
TO_MAILCODE CHAR TERMINATED BY X'09',
DEST_CODE CHAR TERMINATED BY X'09'
)

Here's the data format, tab separated fields. I want to ignore the country description while loading :

AR Argentinia 2451 2451 ROS
AR Argentinia 2500 2500 COR
AR Argentinia 2550 2550 ROS