Archives of the TeradataForum

Message Posted: Thu, 20 Mar 2003 @ 20:12:29 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Multiload and Date fields

From:		Dan Homer

I'm trying to load a flat file into Teradata which includes some Julian dates. Unfortunately, in some of my data files, the dates are invalid and gets dumped to the error table during load. I'd like to nullify invalid dates so the rest of the record can load properly.

I realize one workaround would be to load the date to a character field, then clean out the invalid dates using sql, but am interested on what workarounds are available upon loading in Multiload, rather than afterwards.

Any suggestions/help would be greatly appreciated!

Dan Homer
Systems Integrator
Bull Services