Simultaneous use of multiple versions of the IBM® SQL Extensions toolkit

You can install a new version of the SQL Extensions toolkit in a database for testing and comparison purposes. After you complete testing and choose the version of the toolkit that you want to use for your production databases, register the functions in those databases so that the functions are available to your users.

Because you install the toolkit in a specific database on the Netezza Performance Server system, it is possible to unpack a new or different version of the kit, install it in a different database, and thus use different versions of the API simultaneously on the Netezza Performance Server system. However, this is not recommended for long-term use, because the functions might have different behaviors and output.