Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2008 @ 11:23:46 GMT


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

Subj:		Re: Viewing of Data in tables which has CLOB/BLOB

From:		Victor Sokovin

We have few tables in our Teradata Database which has columns > > with CLOB/BLOB data types.

I am able to fire the normal tables using SQL assistant but it is not supporting to see the data in the tables which has CLOB/BLOB

Can any one suggest the way to see the data in the Teradata tables which has CLOB/BLOB data types.

You are probably on the older version of SQLA. I can't recall when exactly LOB support had been added but it should at least be available from version 7.0. Here is what you should have at the minimum:

"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."

This is a quote from the SQLA Help.

Check your SQLA version and try to upgrade the Assistant.

Victor


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

Attachments

Library

Quick Reference