Problem exporting LOB from SQL Assistant

Tools & Utilities
Enthusiast

Problem exporting LOB from SQL Assistant

I'm trying to get LOB results from Teradata XML Services stored procedures using Teradata SQL Assistant (TSA). I can run the command in TSA, and I get prompted for a filename for the LOB results, but no file gets created, and I only get a '?' in the onscreen answer set. If I run the same command in BTEQWIN, I can get/see the results (as long as the result isn't very wide). Also, in the ODBC config, I did check the box for "enabling native large object support". I am using TSA version 7.2, ODBC 3.05. Does anyone have a workaround/solution for this?
1 REPLY
Enthusiast

Re: Problem exporting LOB from SQL Assistant

FYI - Here's the final update to this thread. I needed to install/use the version 12 (TTU 12) software for ODBC and TSA. Now, stored procedure LOB results are correctly returned to the Windows client through TSA.