SQL Width and
Max Width are not the same in DBTOOL output when using either Options 1 or 2:
1. SQL Width & Date Scan w/Report Option
2. SQL Width Scan w/Fix Option
SQL-Width is the
current SQL Width for the field listed.
Max-Width represents the
size of the longest piece of data in the field.
If the Max Width of a field exceeds the SQL Width then this can cause issues when executing SQL queries which is why these DBTOOL features were added to the Product in Progress 9.1E.
Example. The following is DBTOOL output for the Salesrep table in the Sports2000 database:
Current max fieldLen for Salesrep (5):
Fld# SQLWidth Max Width ERROR NAME
---- -------- --------- ----- ----
4: 8 3 SalesRep
2: 60 20 RepName
3: 16 8 Region Should a character or decimal field contain data whose length exceeds the SQL Width setting then it will be reflected in the DBTOOL output in the error column:
Current max fieldLen for Salesrep (5):
Fld# SQLWidth Max Width ERROR NAME
---- -------- --------- ----- ----
4: 3 4 *** SalesRep
2: 60 20 RepName
3: 16 14 Region