Filtering records with SQL*Loader

From: hazledid <david.hazledine_at_roche.com>
Date: Thu, 06 May 1999 10:52:06 GMT
Message-ID: <qveY2.4711$vY2.18322@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 - 05:52:06 CDT