Enhanced encryption routine added to SQL Simon Hutchinson

​Included within the latest Technology Refreshes, IBM i 7.5 TR3 and 7.4 TR9, is an improved encryption algorithm for AES, which uses a 256 bit key. It is as easy to use as the older versions of encryption I wrote about over a year ago. I just wanted to take this opportunity to reinforce the best ways of using it.
It is a scalar function that does the encryption. Its syntax is just:

ENCRYPT_AES256(< string or variable >, < password string >, < hint >)

In its simplest for I can just use it like:

01 VALUES BINARY(ENCRYPT_AES256(‘This is RPGPGM.COM’,’Password’))

Read more » Read More 

Verified by MonsterInsights