Re: Error -451 on unload statement
Hi Philippe,
I think you hit bug 57342. You probably have unprintable characters in
the text field. You can:
- ensure that your text field does not have unprintable characters (we
encountered this problem having null characters stored in a text field);
- change the data type of your TEXT column to BYTE; the unload will work
fine and you can revert to TEXT any time;
- upgrade; version 7.24.xx has this bug fixed.
Best regards,
Cristian.
Philippe Fornaciari 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.
> I didn't find how to fix this problem.
>
> Thank you for your answer.
>
> Philippe Fornaciari
> Summit Technologies International
> p.fornaciari@summittechnologies.com