Cannot find option to enable Large Object (LOB) data types

Database
Visitor

Cannot find option to enable Large Object (LOB) data types

The version of Teradata is 16.10.0.2 and I couldn't find the option to enable Large Object (LOB) data types according to the documentation in link below : Tools > Define ODBC Data Source > Configure > Options and select Use Native Large Object Support

https://docs.teradata.com/reader/7JJPNb_K3ELUuQwvd0V6Kg/o6aRI7rrKNs9vfTHCRVDhA

 

Thus, everythin time when I connect to Impala ODBC driver, Teradata would ask me LOB information for every column. If I click cancel for every column the data can be populated, but it would be very inefficeint if I have a lot of columns.

 

Can anyone help share how to fix this situation? 


Accepted Solutions
Highlighted
Teradata Employee

Re: Cannot find option to enable Large Object (LOB) data types

I think this option has moved inside SQL Assistant in Tools / Options / Answerset / Use default file names for LOB columns - No prompt.

 

But I'm not a huge fan either, on a query I'll run multiple times I prefer to cast lob as varchar(4000) (or anything that makes sense) or spamming the cancel key for one time queries.

1 ACCEPTED SOLUTION
1 REPLY 1
Highlighted
Teradata Employee

Re: Cannot find option to enable Large Object (LOB) data types

I think this option has moved inside SQL Assistant in Tools / Options / Answerset / Use default file names for LOB columns - No prompt.

 

But I'm not a huge fan either, on a query I'll run multiple times I prefer to cast lob as varchar(4000) (or anything that makes sense) or spamming the cancel key for one time queries.