Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2005 @ 14:20:32 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: How can retrieve BMP/JPG/GIF thru SQL Assistant?
From:   Dempsey, Mike


BTEQ can handle BLOBs if you issue SET LARGEDATAMODE ON, but it is limited to 64K for Import/Export.

(It does allow you to retrieve a larger LOB to sysout ... but that would be displayed in Hex dump format so it is only useful for debugging what was loaded by another application.)

None of the load/unload utilities support BLOBs yet.

CLI and ODBC both support BLOBs, so you could write your own application.

I think the logic was that in many cases BLOBs will be loaded [and possibly retreived] by custom applications. For example, a medical system that captures CT scans would then load the scan to Teradata - and probably also retreive and display it later.

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: 15 Jun 2023