The MAX-WIDTH term in the ABL refers to the max width of a datatype for OE sql.
The sql width, for a column defined in the ABL, depends on the datatype.
The character type will have a default sql width of twice the format size.
For decimal types, width is proportional to number of digits in the entire number (before and after dec pt).
These are the types where the sql width matters.
For integer, and date types, sql width is 4.
For int64, timestamp types, sql width is 8.
For datetime and datetime-tz width is 12
For these number types and others, sql width does not affect sql behavior.
For varchar, max length is 31,995.
The MAX-WIDTH is for SQL because OpenEdge is truly a variable length field but SQL must have a maximum length. Their variable length for SQL means the field will contain what is assigned to it up to a maximum size. The number fields default to the actual storage size.
