Salesforce

Are SQL width and Max width the same in DBTOOL output?

« Go Back

Information

 
TitleAre SQL width and Max width the same in DBTOOL output?
URL NameP162121
Article Number000130605
EnvironmentProduct: Progress
Version: 9.1D, 9.1E
Product: OpenEdge
Version: 10.x, 11.x
OS: All supported platforms
Question/Problem Description
Are SQL Width and Max Width the same in the DBTOOL output:
1. SQL Width & Date Scan w/Report Option
2. SQL Width Scan w/Fix Option

What is the difference between SQL-Width and Max-Width?
Steps to Reproduce
Clarifying Information
In the context of Data Definition (.DF) files, SQL-WIDTH and MAX-WIDTH are the same.
  • SQL-WIDTH is used in Progress 9.x .DF files;
  • MAX-WIDTH is used in OpenEdge 10.x .DF files and later.
Error Message
Defect Number
Enhancement Number
Cause
Resolution
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
Workaround
Notes
Keyword Phrase
Last Modified Date11/20/2020 7:16 AM

Powered by