[progress Communities] [progress Openedge Abl] Forum Post: Re: Would Like Some Info On Dbtool

  • Thread starter Thread starter rfarver
  • Start date Start date
Status
Not open for further replies.
R

rfarver

Guest
DBTOOL updates the width parameter of a field to be some percentage (user specified) larger than the largest piece of data in the field. If the width of a field is 20 characters and you have a field with 30 characters, the SQL call will fail. Running DBTOOL with a 50% increase will change the width of the field from 20 to 45. This gives some buffer in case the field is overstuffed again. This change only applies to SQL and has no effect on ABL, but it is passed on to the target databases. In our environment we run DBTOOL on a weekly basis to prevent SQL issues (we use JDBC). We also run JDBC queries against our target database in addition to the source. In 11.5.1 there is a new feature called Automated Data Truncation that can be turned on to truncate the data being sent to SQL queries to match the current width. In 11.6 there is the option to increase the width automatically when making a SQL call.

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