tdcrypto /

Filename Size Date modified Message
836 B
1.4 KB
4.2 KB
6.5 KB
248 B
254 B
253 B
4.9 KB
6.6 KB
5.0 KB
10.4 KB
92 B
1.9 KB

tdcrypto

Teradata cryptographic UDFs. Currently BLAKE2 is being used as the underlying cryptographic function.

Installation

You'll need CREATE FUNCTION privilege on database or the user that'll own the UDFs. You'll also need ALTER FUNCTION privilege if you want to alter the UDFs execution mode from protected to not protected.

  • Switch to the repo directory.
  • Set appropriate default database if UDFs need to be owned by a specific User or Database.
  • If UDFs will be run in PROTECTED execution mode, edit CryptoHash.sql file and comment out the ALTER FUNCTION statements.
  • Run CryptoHash.sql file.

Usage

Note: The UDF parameter must be be either VARCHAR or VARBYTE.

SELECT InfoKey, InfoData, CryptoHash(InfoData) AS HashedData
  FROM DBC.DBCInfoV