Home » RDBMS Server » Server Utilities » SQL Loader -- Treating Invalid Date as NULL
SQL Loader -- Treating Invalid Date as NULL [message #70965] Tue, 20 August 2002 04:22 Go to next message
Scot
Messages: 7
Registered: August 2002
Junior Member
I am loading fixed width positional data, some of which contains dates. By default, if a field is blank, it will be loaded as NULL, but it will be loaded.

But, assume the date mask for a field is 'mmddyyyy'. If the field contains an invalid date, such as:

'00000000' (invalid everything, all zeros)
or

'99112002' (invalid month)

The default behavior is to fail to load the record, writing it to the .bad file. I would like to specify that these situations be loaded successfully (not written to the .bad file), using a NULL for the value of the column. How do I do this?

Report message to a moderator

Re: SQL Loader -- Treating Invalid Date as NULL [message #70967 is a reply to message #70965] Tue, 20 August 2002 04:33 Go to previous message
Scot
Messages: 7
Registered: August 2002
Junior Member
I apologize for the multiple posts, had some sort of network problem at my place of employment that indicated the post didn't go through.

Report message to a moderator

Previous Topic: Full Import without import users SYS and SYSTEM (Who do this??)
Next Topic: SQL*loader error message
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Apr 29 13:43:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.