Archives of the TeradataForum

Message Posted: Mon, 10 Jan 2005 @ 23:30:07 GMT

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

From SQL Assistant 6.1 and up Help:

Teradata SQL Assistant now supports Large Objects. Large objects come in two types

Binary: These columns may contain Pictures, Music, Word documents, etc. The column type used by different vendors may be any of - BLOB, IMAGE or LONG RAW.

Text: These columns contain text data such as Text, HTML, XML or Rich Text (RTF)

The column type used by different vendors may be any of - CLOB, TEXT or LONG.

When an Answer set contains a Large Object (LOB) column Teradata SQL Assistant will ask you to provide a file name, a file type, and optionally, a directory for each Large Object column. Each LOB data value will be written to a separate file.

The file name for each data value will be created by joining the file name, a sequential number, and the file type.

For example, if you provide 'Photo' as the name and 'jpg' as the type, the files will be called Photo001.jpg, Photo002.jpg, and so on...

Although you may change the directory each time SQL Assistant requests a file name, only the last directory specified for a given Answer set will be used. This directory will be used for all LOB files related to this Answer set.

The file names will be displayed on buttons within the Answer set grid. If you click on a button, the file opens. This feature relies on Windows File Associations so you must specify the file type that is appropriate for the type of data stored in the LOB column.

If the data is a picture (File type BMP, JPG, JPEG, GIF or ICO only) SQL Assistant will offer you the option of displaying the picture within the Answer set grid itself. You may request that the picture is displayed instead of being saved to a file, or in addition to being saved to a file.

Large objects can also be imported. There is a limit of 999,999 bytes for any imported file. You must set the Maximum Size, on the Export tab of the Options screen, to a value that is at least as large as the largest file you plan to import. Please see Importing data from a file for more information.

Note: if you select one of the image file extensions it will allow you the option of viewing the object in the output window.

Ed Ray

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