Re: Invalid date with SQLLOAD
From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Thu, 1 Dec 1994 11:38:39 GMT
Message-ID: <James.Lawrence.38.000BA547_at_epamail.epa.gov>
Date: Thu, 1 Dec 1994 11:38:39 GMT
Message-ID: <James.Lawrence.38.000BA547_at_epamail.epa.gov>
In article <3bgqoe$c7q_at_news.cais.com> sarek_at_cais2.cais.com (Scott T Johnson) writes:
>From: sarek_at_cais2.cais.com (Scott T Johnson)
>Subject: Invalid date with SQLLOAD
>Date: 30 Nov 1994 03:15:25 GMT
>I have a LARGE datafile to load which contains dates. Some of the data
>are dates but they are invalid. If the date is invalid, SQL*Load rejects
>the entire record. Is there a way to place a NULL in the appropriate
> field if the date is invalid?
> Thanks,
> Scott
If there is I havn't found it. I deal with this by loading into a temporary table, clean up the data, and then move it with an 'Insert ... Select...' statement.
Lawrence..... Received on Thu Dec 01 1994 - 12:38:39 CET