Hi there,
In Oracle EBS, I have a concurrent program whose executable method is sql*loader, the sql*loader control file look like this:
options (errors=99999,silent=(header,feedback,discards))
load data
infile *
append
into table A_TABLE_NAME
WHEN REC_ID <> 'TRL'
TRAILING NULLCOLS
(
PLAN_NBR POSITION (1:6) CHAR
,REC_ID POSITION (7:9) CHAR
,NAME POSITION (10:50) CHAR
,UPLOAD_DATE SYSDATE
)
The data file looks like this
123456001JOHN DOE
123456002JANE DOE
...
123456TRL
The "WHEN REC_ID <> 'TRL'" in control did discard the last row 123456TRL, which is what I want. However, the problem is, even though I set silent to discards, the converrent program still show Warning status. What need to be done so the concurrent program will not show Warning status, but show normal status?
Thank you so much for your help!
Regards