Try OpenEdge Now
skip to main content
SQL Development
OpenEdge SQL and Advanced Business Language Interoperability : ABL and OpenEdge SQL interaction in an OpenEdge application : Working with SQL column widths

Working with SQL column widths

An ABL database can contain fields, also referred to as columns, of variable length. However, SQL CREATE TABLE statements specify the maximum width of each column in a table. ABL programs have the ability to insert data whose length exceeds the Data Dictionary value of SQLWidth. SQL applications will not be able to read a row if a column contains data greater than the SQLWidth value defined in the Data Dictionary.
Two tools enable you to compensate for column width discrepancies:
*The -checkwidth startup parameter
*The DBTool utility
* Using the -checkwidth startup parameter
* Using the DBTool utility