Teradata: How to display LOB inline(inside the cells)

Question

I have a Teradata table which contains LOB objects in different columns.

When I do a query, it pops up window to ask where to save the LOB objects as txt files onto my disk.

LOB Information (due to my SOF level, I cannot display the screenshot)

My question is, is it possible to display the content of these LOB objects inline(inside the cells)?

Answer 1

I found the solution:

Changed Configuration (Due to my SOF level, I cannot show image directly in my post)

Changing the "Handle the BLOB/CLOB size" to smaller values solved my problem partially.

The reason why it's partially is because the LOB Information pop-up still there.

Answer 2

If you want this for viewing in Teradata SQL Assistant only (it can't display arbitrarily wide columns):

If the strings in the CLOB columns are short enough, cast them to varchar in your query:

select id, cast(clarge as varchar(1000)) as WhatIsInCLob
from ...

If the values can exceed varchar limits (depends on the character set of the CLOB, and session character settings, but easily thousands of chars), then use SUBSTRING to limit the output:

select id, cast(substring(clarge,1,4000) as varchar(4000)) as WhatIsInCLob
from ...

There is more specific limit information here: https://docs.teradata.com/r/Teradata-SQL-Assistant-for-Windows-User-Guide/October-2018/Getting-Started/Limitations