SQL — ENCRYPT Function
Syntax
ENCRYPT (string1,string2)
Description
In BBj 4.00 and higher, the ENCRYPT() function, and counterpart DECRYPT() function, supports encrypted fields. In the syntax, string1 is the string to encrypt, string2 is the mode line for encryption, as described in the ENCRYPT verb documentation. The return value is the binary encrypted string as produced by the ENCRYPT verb.
|
Mode |
Value | Description |
|---|---|---|
| CRYPTPASS= |
String |
The encryption key. BASIS recommends a password of at least 20 characters when using AES-128, and at least 40 characters when using AES-256. |
|
CRYPTALG= |
|
Uses AES-128 bit encryption which is also the default. Uses AES-256 bit encryption in BBj 6.00 and higher and PRO/5 6.0 and higher. |
|
CHARSET= |
String |
In BBj 16.00 and higher, specifies the character set encoding of the password string. |