Category "teradata-sql-assistant"

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

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

split int col in Teradata

I was trying to split int column in Teradata but its showing error *** Failure 9134 Unsupported type detected. SELECT col1,strtok(col2,0 ,1) FROM table;

Teradata : Extract Date from string

There is a notation field with different number of characters. Eg Exceed Limit Fee 26-January-2020 or Account Exceed Limit Fee 05-June-2001 I want to extract