title: SQL Loader error
body: <p>I get the below log message from sql loader. Is this message "Rows not loaded because all WHEN clauses were failed." a really error? 
  At the end i have a log message saying total records read as 74256.  In the ctl control file i see the 38-39 character for record type in each line
  and based on it i will insert into different tables.</p>
  
  <pre><code>Table TEST1_AA:
  
    42233 Rows successfully loaded.
  
    0 Rows not loaded due to data errors.
  
    32023 Rows not loaded because all WHEN clauses were failed.
  
    0 Rows not loaded because all fields were null.
  
  
  
  Table IIR_TEST2_BB:
  
    0 Rows successfully loaded.
  
    0 Rows not loaded due to data errors.
  
    74256 Rows not loaded because all WHEN clauses were failed.
  
    0 Rows not loaded because all fields were null.
  
  
  
  Table IIR_TEST3_CC:
  
    31 Rows successfully loaded.
  
    0 Rows not loaded due to data errors.
  
    74225 Rows not loaded because all WHEN clauses were failed.
  
    0 Rows not loaded because all fields were null.
  
  
  
  Total logical records skipped:          0
  
  Total logical records read:         74256
  
  Total logical records rejected:         0
  
  Total logical records discarded:        1
  </code></pre>
  
  <p>Sample CTL  File </p>
  
  <p>OPTIONS (ERRORS=9999999999, SILENT=(FEEDBACK), ROWS=1000)</p>
  
  <p>load data</p>
  
  <hr>
  
  <p>into table test_HD</p>
  
  <hr>
  
  <p>append</p>
  
  <p>when (038:039) = 'HD'</p>
  
  <p>(</p>
  
  <p>record_sequence_no             POSITION(029:037) DECIMAL EXTERNAL</p>
  
  <p>,line_type                      POSITION(040:040) CHAR</p>
  
  <p>,header_record_type             POSITION(041:041) CHAR</p>
  
  <p>,enquiry_telephone_number       POSITION(042:052) CHAR</p>
  
  <p>,total_amt_last_bill            POSITION(053:066) DECIMAL EXTERNAL</p>
  
  <p>,total_payment_received         POSITION(067:080) DECIMAL EXTERNAL</p>
  
  <p>)</p>
  
  <p>into table test_AS</p>
  
  <hr>
  
  <p>append</p>
  
  <p>when (038:039) = 'AS'</p>
  
  <p>(</p>
  
  <p>record_sequence_no             POSITION(029:037) DECIMAL EXTERNAL</p>
  
  <p>,line_type                      POSITION(040:040) CHAR</p>
  
  <p>,girn                           POSITION(041:047) CHAR</p>
  
  <p>,charge_desc                    POSITION(048:077) CHAR</p>
  
  <p>}</p>