-
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.
-
Hi,
Try using column POSITION to ignore the field.
Thanks.
Ramki
-
Unfortunately column lengths are variable.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|