| sqlrd control file [message #442109] |
Thu, 04 February 2010 13:40  |
navin_deep
Messages: 18
Registered: November 2009
|
Junior Member |
|
|
Hi
I am not able to understand how and which dat is loaded for a certain sqllrd control file logic used in our application, can anyone please explain it.
data file is of format xxxx.dat and data is like :
43355334;1978-01-29;
44334433;1970-01-15;
43434343;1974-03-26;
43334443;1977-09-20;
Control File used is :
OPTIONS (LOAD=500000)
LOAD DATA
CHARACTERSET WE8ISO8859P1
INTO TABLE ABCD
TRUNCATE
WHEN (9)=';'
AND (8)<>';' AND (7)<>';' AND (6)<>';' AND (5)<>';'
AND (4)<>';' AND (3)<>';' AND (2)<>';' AND (1)<>';'
Fields terminated by ';'
TRAILING NULLCOLS
(
EMPLOYEE_NUMBER char,
BIRTH_DATE date 'YYYY-MM-DD',
DTTM_STAMP sysdate
)
Can anyone please explain me the logic used here by control file ?
Regards
-navin
|
|
|
|
| Re: sqlrd control file [message #442122 is a reply to message #442109] |
Thu, 04 February 2010 15:12  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
If there is not a semicolon in all positions between 1-8 and there is a semicolon in position 9, then load the data into the corresponding columns.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
