Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2008 @ 16:02:02 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Viewing of Data in tables which has CLOB/BLOB
From:   Dempsey, Mike

Support for large objects was added to SQL Assistant in version 6.2. When you retreive a large object column it will ask you to provide a file name and type.

It will then write each object to a file using the name as a stub and followed by a number.

If the object is a picture you should specify a type of bmp, jpg or gif and it will give you the option of displaying the object as a picture in the Answerset grid instead of, or as well as, writing it to the file.

Some (older) versions of SQL Assistant require that you set the ODBC DSN option "Use Native Large Object support" in order for this to work.

Mike Dempsey
Teradata Client Tools

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020