Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2008 @ 16:02:02 GMT

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

Support for large objects was added to SQL Assistant in version 6.2. When you retreive a large object column it will ask you to provide a file name and type.

It will then write each object to a file using the name as a stub and followed by a number.

If the object is a picture you should specify a type of bmp, jpg or gif and it will give you the option of displaying the object as a picture in the Answerset grid instead of, or as well as, writing it to the file.

Some (older) versions of SQL Assistant require that you set the ODBC DSN option "Use Native Large Object support" in order for this to work.

Mike Dempsey
Teradata Client Tools

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