Modifying existing Teradata configurations

To upgrade to Teradata release V2R5 and above, you can modify your existing Teradata wrapper.

About this task

If you already use the Teradata wrapper, you can upgrade to Teradata release V2R5 and above by modifying your existing Teradata wrapper configuration or by recreating your entire Teradata wrapper configuration of servers, user mappings, type mappings, function mappings, and nicknames.

To modify your existing Teradata wrapper configuration:

Procedure

Change the Teradata server product version, for example to 2.5, on all of your Teradata servers by using the ALTER SERVER statement:
```
ALTER SERVER MYTERASERVER VERSION 2.5
```
Remove the TUPLE_ID_TYPE nickname option on all of your Teradata nicknames by using the ALTER NICKNAME statement:
For example:
```
ALTER NICKNAME TERANICKNAME OPTIONS (DROP TUPLE_ID_TYPE)
```
To get a list of all nicknames that need to be changed, use the following SQL statement to return nickname object names, server object names, and server versions for all nicknames that are associated with a TERADATA server type:
```
SELECT T.tabname, S.servername, 
	S.serverversion 
  FROM syscat.servers AS S, syscat.taboptions AS T 
   WHERE T.option = 'SERVER' AND S.servername = T.setting 
   AND S.servertype = 'TERADATA' 
		AND S.serverversion IN ( '2.3', '2.4', '3', '4' )
```