Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 12 Jan 2005 @ 16:59:54 GMT

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

Subj:   Re: How can retrieve BMP/JPG/GIF thru SQL Assistant?
From:   Victor Sokovin


  The limit of 1 MB is only for LOADING BLOB columns via SQL Assistant. (Even that limit can be circumvented if you have enough memory on your PC and dont mind altering a registry entry.)  

  Blobs themselves can be up to 2GB, and SQL Assistant can download these columns to a local file ... if you are willing to wait for the data transfer. (Applies to Windows NT/2000/XP - Win95/98 have much lower limits.)  

Are there any alternatives to SQLA for loading or exporting BLOBs? I probably should download and check out the latest manuals (and not spend your time on such questions) but the 2003 versions of ML or FastExport do not even seem to mention BLOBs at all.

Just to make sure: I'm asking not because I'm unhappy about SQLA. I'm sure it does its best on most occasions. The limitations usually come from the server or client OS, ODBC, etc. It would just be useful to know what the bulk utilities can offer regarding BLOBs. Not to compare them to SQLA or something - they clearly serve differenc purposes and are useful in different situations.

The subject is so rare on the forum that I can't resist asking for more information.


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