Use of IBM Netezza SQL Extension
Importing and storing XML data in a SQL database,manipulating XML within the database, and publishing both XML and conventional SQL data in XML form.
Transforming data by compressing, encrypting, or uuencoding, and restoring to the original form using decompress, decrypt, and uudecode
Using hash functions for cryptography, checksums, and lookups.
Using hash functions for cryptography, checksums, and lookups
Using date and time functions to compare values of type date or of type timestamp.
Performing "fuzzy" comparisons (approximately matching a search key) and using regular expressions to match precise patterns of characters
Converting between ASCII hexadecimal and ASCII, substituting strings, and extracting strings.
Creating, combining and splitting arrays, and retrieving, deleting, replacing and counting array elements.
Grouping heterogeneous pieces of data, i.e. data of different types
Determining the greatest/least value, correlation coefficient, covariance, and generating random numbers.
How to find how many data base is using Sql Ext
How to find which version of Sql Ext is installed
nzsql db_name -c "SELECT CRYPTO_VERSION();"
nzsql db_name -c "SELECT REGEXP_VERSION();"
Likes before 03/04/2016 - 0
Views before 03/04/2016 - 315