Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


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