Progress
Version 9
Product Update Bulletin
4GL -checkwidth startup parameter
Progress 4GL programmers can override Data Dictionary column definitions in 4GL programs. However, a SQL application cannot read a record if a column contains data greater than the SQL
_width
value defined in the Data Dictionary. When the SQL engine attempts to retrieve a column that exceeds the metaschema_width
field definition, an error message is generated and the attempt to access the record fails.Use the
-checkwidth
startup parameter to specify whether the Progress 4GL client 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.The syntax for the
-checkwidth
startup parameter is:
The
-checkwidth
startup parameter can be employed in the following modes:
- 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 4GL to behave like SQL.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |