We have define a coulmn as CLOB in a teradata table as we have to load it from a CLOB column from Source(Oracle), but
during loading it from API/Uitlity mode in Abinito, we are getting an error and load is failing.
I belive we cannnot load a CLOB column thorugh utility...
Work around -->
We are thinking to define the column as varchar , after checking the length of the max possible value from source system.
Any suggestions/feedback on the above pls?
I am facing an issue while unloading table which has one of the column defined datatype as the BLOB/CLOB.
when I tired to unload table using below code,it gives result as the partial columns but not all the columns..Can any one please help us to get all the columns as the output