Kbase P62676: Increase SQLWidth without getting a bad performance
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/24/2004 |
|
Status: Unverified
GOAL:
Increase SQLWidth without getting a bad performance
FIX:
Dbtool is an utility which is included in service Pack 6 or higher, It detects which is the longest record and sets the SQLwidth filed to that value.Using 4GL it is always possible adding records which are over the maximum allowed but system will only display the number of the characters correponding with that maximum(Using 4GL).That's why the longest record can change when using 4GL. When trying to retrieve data from the table using SQL92, it will show an error stating that, there are records which are violating the constraints and it will be needed use dbtool again in order to change the SQLWidth.This happens when working with 4GL and SQL92 at the same time. Nothing happen if changing the SQLWidth very often, ,and of course the size will increase a little bit more,.This is the only solution when (getting/inserting data) which are bigger than the format using SQL92.(rather than cutting or splitting the record)