Archives of the TeradataForum

Message Posted: Thu, 22 Dec 2005 @ 15:22:30 GMT

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

Hi Bill:

Most of us oldtimers would not think that using delimited input files is a long term solution either. It requires the data to all be parsed before it can be put into a field so that it can be put into a block. Then, it all has to be converted into the appropriate data type to be stored in the table. Both of these operations slow the utility down.

If it finds the hex value and stops looking for more, you really need (in the long term) to not make it look for the end of each field and the end of the record. Do you not want your loads to run as fast as possible? Will this not cause more of a concern when you get to multi-million record loads?

Is there a way you can build the file as fixed length record and use more native data types? This would take care of your problem and the data would be loaded.

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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