Forum Post: RE: Export from progress to SQL server Database - Error messages

  • Thread starter Thread starter Paul Koufalis
  • Start date Start date
Status
Not open for further replies.
P

Paul Koufalis

Guest
All Progress CHAR fields are VARCHAR with a max size of 32K. Since SQL absolutely wants a field width, Progress sets that using a special field attribute called sql_width. dbtool is the program provided by Progress to automatically adjust the SQL width attribute. IIRC, dbtool sets sql_width to twice the width of the widest instance if the field in question. I typically run dbtool and update statistics once per month.

Continue reading...
 
Status
Not open for further replies.
Back
Top