We have an existing method to update the length of character fields in the WTDD as follows:
https://bida.ro/2021/01/13/hd0007-how-do-i-set-character-field-lengths-in-the-wtdd/
However, given that we now have the ability to have the WTDD in a different database to the actual database being queried we propose that we will write a C++ program to improve this process.
The proposed C++ Program will read the WTDD to get the table name and column name.
Then it will issue the statement to find the maximum length down a second ODBC connection.
Then, finally, it will issue the update statement against the WTDD ODBC connection making note that if the max length has not changed then it will not be updated.
This process can then be scheduled on a regular basis just to check on the character lengths of fields to make sure that if one has increased it is caught and updated to protect against failures in Meta5 capsules.
We will update this post when (if) this program is released.