-
sqlldr question
Hi friends ,
can i capture sqlldr error message or exception when sqlldr gets some bad records
actually we are invoking this in shell script .
sqlldr xyz/xyz@test control=/usr/local/weblogic/upload_vol.ctl direct=true log=/usr/local/weblogic/upload_vol.log
--- upload_vol control file
LOAD DATA
INFILE '$FILE_NM'
INTO TABLE upload_volume
TRUNCATE
FIELDS TERMINATED BY ','
Thanks in advance .
-
-
hi dave ,
thanks for quick response ..
i want this operation to fail .. whenever a single bad record is present in the flat file ..
by putting bad=bad.log it is writing bad records in bad.log file .. which continues the sqlldr .
i want this to exit with error message whenever a bad record comes .
Thanks
-
oh right, there is a max error parameter - ill try look it up
-
-
Actually, use ERRORS=0. If you use ERRORS=1 the loader will terminate only when it encounters a *second* bad record. This parameters specifies how many bad records you allow before stopping the loading process.
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
I will let you know once i try eith errors = 0
Last edited by prakashs43; 08-19-2004 at 12:46 PM.
-
I tried errors = 0 in following command
sqlldr xyz/xyz@isrprod control=/usr/local/weblogic/upload_vol.ctl log=/usr/local/weblogic/upload_vol.log bad=/usr/local/weblogic/upload_vol.bad discard=/usr/local/weblogic/Web_data/upload_vol.dis errors=0
but it still continued though there was one bad record .
and it showed that record in .bad file .
am i missing anything here .
thanks
-
Is the command line being truncated?
How about putting OPTIONS (ERRORS=0) in the control file?
-
Hi Friends ,
errors=0 is actually exiting sqlldr whenever 1st bad record comes
actually i am calling sqlldr from java
can i actually capture
success and failure return codes ..
thanks for all your help
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
|