How to find SQL extention toolkit version?
To find the SQL extention toolkit version / functions installed on your Netezza server, we can run below select queries in system database or database where SQL Extention toolkit is enabled.
1) To find the version of xml functions installed on the server:
SYSTEM(ADMIN)=> SELECT regexp_version();
IISI XML / Regular Expression Library Version 1.4 Build ()
2) To find the version of all the functions except xml functions run:
SYSTEM(ADMIN)=> SELECT CRYPTO_VERSION();
IISI Crypto Library Version 1.4 Build ()
Normally both wil have same version but it posisble that someone may have installed one component and missed the other because when we install SQL Extention toolkit and enable for a databsae we have two steps each, one to install xml functions and other for non-xml.