MB0001 – How Do I Set Character Field Lengths In the WTDD

BIDA Forums Forums Product Improvements 4-Meta5 To BIDA Integration MB0001 – How Do I Set Character Field Lengths In the WTDD

Tagged: ,

Viewing 0 reply threads
  • Author
    Posts
    • #997
      Peter Jones
      Keymaster

        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.

        Best Regards
        Peter Jones

    Viewing 0 reply threads
    • You must be logged in to reply to this topic.