Updating the createvarcharunicode.sql file

1. Log in to the server as the user with the required permissions.

2. Navigate to the /opt/protegrity/databaseprotector/teradata/sqlscripts/ directory.

3. To update the output buffer length in the createvarcharunicode.sql file, run the following command:

   vim createvarcharunicode.sql
   

4. Press ENTER.
   The vim utility starts and the contents of the createvarcharunicode.sql file appears.

   Ensure to update the value of the output buffer length for the PTY_VARCHARUNICODEINS, PTY_VARCHARUNICODESEL, and PTY_VARCHARUNICODESELEX UDFs as per your requirements.

5. To save changes to the createvarcharunicode.sql file, run the following command:

   # :wq
   

   Important: To reflect any changes made to the createvarcharunicode file, you must restart the Teradata Database.

6. To restart the Teradata Database, run the following command:

   # tpareset -f <reason for restart>
   

   Important: Updating the createvarcharunicode.sql file does not require a tpareset.

7. Press ENTER.
   A prompt to continue with restarting the database appears.

   You are about to restart the database
     on the system
        'localhost'
   Do you wish to continue (default: n) [y,n]
   

8. To continue with restarting the database, type y.
   The Teradata Database restarts successfully.