Progress
Version 9
Product Update Bulletin
Check Width (-checkwidth)
n
The check-width mode.
Use Check Width (-checkwidth) to specify whether Progress compares CHARACTER, DECIMAL, and RAW field data against the metaschema _width field value before updating a database record. The _width field value specifies the maximum width of the data allowed in a field.
Progress allows for variable length data; SQL does not. This startup parameter lets you impose the SQL requirement that data cannot exceed the size specified in the _width field.
The valid check-width modes are:
- 0 — Ignore the _width field value and store the data. This is the default mode.
- 1 — Store the data, and generate a warning message if the data exceeds the size specified in the _width field.
- 2 — Do not store data that exceeds the size specified in the _width field, and generate an error. Specify this mode if you want Progress to behave like SQL.
NOTE: The _width field value for array fields is the size of all array elements after Progress converts the array element values to CHARACTER. This means that even with the -checkwidth startup parameter enabled, array fields can still surpass the _width field value.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |