Probably here is what you need (the solution from Progress Knowledge Center):
Title: "ODBC/JDBC Error 7864 Caused by Insufficient SQL-Width"
Created: 31-Jul-2000 Last Modified: 30-Jun-2004
Known to occur in:
Column <column> in table <table> has value exceeding it max length or precision (7864)
Getting error 7864 with SQL92 client
Error 7864 with ODBC, JDBC clients or SQL explorer querying database
This error appears on a SQL-92 Client when trying to return data stored in a character field greater than the defined SQL width of the field.
With a 4GL connection to a Progress Database there is no size limit for a character field (except the 32k limit for the all record). By default, the SQL-WIDTH is set to twice the length of the displayed format. Since programs may not take the displayed format into account, the data size may easily go beyond the SQL-WIDTH of the field, hence the error with SQL-92 Clients.
1. Scan the entire database and check to see whether data contained in character fields exceeds the SQL-WIDTH. Please reference Progress solutions P13348, "How to detect problematic SQL-WIDTH with a 4GL program" and P24496, "What is the DBTool ?".
2. Expand SQL-WIDTH.
Follow these steps to change the SQL width:
From the Data Dictionary on UNIX
1) Select Schema.
2) Select SQL Properties.
3) Select the desired table.
4) Change the width for desired field to a number that your data length is (less than 2K).
From Data Dictionary on Windows:
1) Select "SQL Properties" from "Options" menu.
2) Select "Adjust Field Width".
3) Change the width for desired field to a number that your data length is (less than 2K).
To change the width programmatically (via the Progress 4GL):
find first _file where _file._file-name = "". find first _field of _file where _field._field-name = "". update _field._width.