Archives of the TeradataForum
Message Posted: Thu, 18 Dec 2008 @ 11:23:46 GMT
You are probably on the older version of SQLA. I can't recall when exactly LOB support had been added but it should at least be available from version 7.0. Here is what you should have at the minimum:
"Large objects come in two types
Binary These columns may contain Pictures, Music, Word documents, etc. The column type used by different vendors may be any of â " BLOB, IMAGE or LONG RAW.
Text These columns contain text data such as Text, HTML, XML or Rich Text (RTF)
The column type used by different vendors may be any of â " CLOB, TEXT or LONG.
When an Answer set contains a Large Object (LOB) column Teradata SQL Assistant will ask you to provide a file name, a file type, and optionally, a directory for each Large Object column. Each LOB data value will be written to a separate file."
This is a quote from the SQLA Help.
Check your SQLA version and try to upgrade the Assistant.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|