Re: Error -451 on unload statement
Philippe Fornaciari (p.fornaciari@summittechnologies.com) wrote:
: Hi All,
: I am working on a Windows NT 4.0 server with Informix OLWS 7.22.
: I try to unload a table into a text file using dbaccess and the SQL
: 'unload to textfile select * from tablename". The table contains a text
: field. The unload starts to build the text file, but stops before the
: end (300 rows of 1400 rows) with the Error Message -451 Locator buffer
: size too small.
Does your "tablename" have blobs in it? The reference to "locator buffer"
indicates a problem with blob handling.
joe
--
---------------------------------------------------------------------------
Joe Lumbley(jlumbley@netcom.com) author of: "INFORMIX DBA Survival Guide"
Slaving away on "INFORMIX DBA Survival Guide, The SQL", available late 1998
from Prentice Hall/Informix Press.
---------------------------------------------------------------------------