Problem exporting LOB from SQL Assistant

Tools
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.