| Filler keyword in SQL Loader Release 7.3.4.4.1 [message #72424] |
Thu, 12 June 2003 16:42  |
Masoud
Messages: 1
Registered: June 2003
|
Junior Member |
|
|
Hi,
We use the SQL Loader Release 7.3.4.4.1. Does anybody that whether the keyword 'FILLER' can be used in that release of sqlldr.
I tried using the same and I am not able to load the file, skipping the first column which I don't need in the table (it doesn't mean that it loads skipping the nth column).
I do not know whether it is a syntax error or the version doesn't support the use of it. The CTL file is as below
LOAD DATA
INFILE datafile.csv
APPEND INTO TABLE table_msg
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
(col1 FILLER CHAR(2),
msg_id,
seg_code,
time_stamp DATE(21) "DD-MON-YYYY:HH24:MI:SS",
load_dt SYSDATE)
Any help on this regards would be greatly appreciated.
Thanks in advance.
Masoud A R.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
