Archives of the TeradataForum

Message Posted: Mon, 28 Aug 2000 @ 16:20:14 GMT

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

Mary Lou,

Change the "FIELD" command in the "LAYOUT" section to define IJUNK02 as "CHAR(8)". The Multiload will then use the format that you specified to convert it to a date (as long as it's defined as a DATE column in the table). If you have trouble with it, you may have to put parenthesis around the entire expression like this:

(:IJUNK02 (format 'MMDDYYYY'))

Thanks,

Barry

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