Kbase P162121: Are SQL width and Max width the same in the dbtool output?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
30/03/2010 |
|
Status: Unverified
GOAL:
Are SQL width and Max width the same in the dbtool output?
GOAL:
Is SQL Width the same as Max Width in DBTOOL output?
FACT(s) (Environment):
Progress 9.1D
Progress 9.1E
OpenEdge 10.x
All Supported Operating Systems
FIX:
The SQL Width and Max Width are not the same in DBTOOL. 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 problems when executing SQL queries; see solution 18959 for more information. 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 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