Archives of the TeradataForum
Message Posted: Thu, 20 Mar 2003 @ 20:12:29 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|