-
sqlldr - records are not properly loaded
Hi,
I tried to load text file to Oracle database using sqlldr. Here is the control file:
LOAD DATA
INFILE '/home/oracle/LOAD/T28548518.txt'
REPLACE
INTO TABLE pager_data
WHEN c1 = 'Record_E' and phonenum <> ' ' and capnum <> ' '
fields terminated by ","
(
...
charge decimal external "ROUND(:charge*1.15,2)",
phonenum char nullif phone_num=blanks "REPLACE(:phone_num,'-')",
capnum char nullif capnum=blanks,
...
)
In the condition, If BOTH phonenum AND capnum are NULL, then these records should be skipped, but log shows sql loader skips records if EITHER condition matches. Anyone know why? Thanks for your help.
Last edited by marist89; 08-23-2004 at 11:54 AM.
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
|