Re: Filtering records with SQL*Loader

Try using constraints.
In this case you could add a constraint UPPER(column_name) =LOWER(column_name) to the table
you want to load.
Records that don't meet the constraint will not be loaded by SQL*Loader, the ones that do will.

regards,

Jan-Hein Biekens

hazledid <david.hazledine_at_roche.com> schreef in artikel <qveY2.4711$vY2.18322_at_c01read01.service.talkway.com>...
> One of the fields in a data file contains numeric values, but an
> occasional record has an alphanumeric in the field.
> I wanted to filter out these alphanumerics when loading the file with
> SQL*Loader, and I thought I could use the WHEN clause as follows:
>
> WHEN TRANSLATE(field,'$0123456789','$') IS NULL
>
> However, it turns out that SQL functions can't be used in WHEN clauses.
> Cany anyone suggest a means of performing this
> filtering with SQL*Loader?
>
> David J. Hazledine
> Roche Products Limited
> 40 Broadwater Road
> Welwyn Garden City
> AL7 3AY
> United Kingdom
> Registration Number 100674
> Tel. +44 (0)1707 366166
>
> --
> Posted via Talkway - http://www.talkway.com
> Exchange ideas on practically anything (tm).
>
>
Received on Thu May 06 1999 - 08:11:10 CDT