Re: SQL Loader

Hi,

my experience is: you cannot crash it.

We import all our data into "POOL" Tables, and check afterwards the existence of BAD-Files like the following: if [ -z "${ORACLE_USER}" ]
then

   sqlload USERID=$DW_ORAUSER \

           CONTROL=$CONTROLFILE \
           DATA=$DATAFILE \
           LOG=$LOGFILE \
           DISCARD=$DISCARDFILE \
           BAD=$BADFILE

else

   sqlload USERID=$ORACLE_USER/$ORACLE_PASSWORT \

           CONTROL=$CONTROLFILE \
           DATA=$DATAFILE \
           LOG=$LOGFILE \
           DISCARD=$DISCARDFILE \
           BAD=$BADFILE 

#------------------------------------------------------------------------------#
# Pruefe den Erfolg bzw. Misserfolg					       #
#------------------------------------------------------------------------------#

if [ -f $BADFILE ] || [ -f $DISCARDFILE ] then

    ErrNr=200
    DWMSG_MeldeFehler ${DW_EintragsNr} F $ErrNr $DATAFILE $LOGFILE fi

Koen Van Vaerenberg wrote:
>
> How do you crash Sql loader .
> I set the option (control file) Errors = 0, but he still does a normal
> completion in Oracle Financials.
> I really need the program to terminate in error when it encounters a bad
> record.
>
> Anyone ??
>
> Thanks in advance

--

Thomas Bregulla,                 Disclaimer:
Landgrabenweg 151, 53227 Bonn    The opinions expressed here
Tel.: 0228.936.2689              are my own; and not of 
Fax.: 0228.936.4709              the company I am working for