Archives of the TeradataForum

Message Posted: Tue, 02 Jan 2007 @ 20:52:02 GMT

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

You can use the 'Import' mode of SQL Assistant to load LOBs of up to 10MB.

The actual limit varies depending on the version of SQL Assistant ... and can be overridden if you really want to do that. (and have enough memory on your PC) See the 'Advanced features' section of the help file/user guide if you need to override the limit.

Note that you must set the maximum buffer size on the Export/Import tab of Options, to be large enough to handle the largest LOB you are loading.

Older versions were able to load only BLOBs (not CLOBs) for some DBMSs.

See help file for details of using Import mode.

Mike Dempsey
Teradata Client Tools

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