Re: Error -451 on unload statement

Joe Lumbley (jlumbley@netcom.com) wrote: : Does your "tablename" have blobs in it? The reference to "locator buffer" : indicates a problem with blob handling. : : joe Replying to my own reply: From finderr -451: Locator buffer size too small. The locator structure provided for a BYTE or TEXT value in this statement specifies a memory buffer that is smaller than the value (in the loc_bufsize field). The actual size is in loc_indicator. No data was transferred. Revise the program to use a larger buffer, to locate the value in a file instead of memory, or to pass the value in segments through a user-provided read function. Alternatively, you can specify a substring of the value in the SELECT statement. If this is a 4GL program, this error should not occur. If the error recurs, please note all circumstances, and contact the Informix Technical Support Department. Ok, so I was close....they are blobs. HTH. 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. ---------------------------------------------------------------------------