Archives of the TeradataForum

Message Posted: Wed, 17 Dec 2008 @ 16:29:22 GMT

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

I don't know how big your LOBs are but the max size of VARCHAR and VARBYTE in Teradata is larger than for most other databases. (Some are as small as 4K)

If your LOBs are smaller than 64K you might therefore want to consider the option of using those data types rather than LOBs. (This decision has its own pros and cons)

SQL Assistant is capable of importing larger LOBs, but this is not a bulk load tool (ie. It is slow) and it requires that each LOB be a file on the pc/server that is running the app.

Mike Dempsey
Teradata Client Tools

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