Description
Specifies a password for encrypting and decrypting data.
When to specify EncryptionPass
You must specify the EncryptionPass parameter before connecting to the database.
Applies to
INF Informix
Syntax
EncryptionPass='value'
|
Parameter |
Description |
|---|---|
|
value |
A string that will be used as the password for encrypting and decrypting data. |
Default value
None.
Usage
In IDS 10.0 and later, the SQL statement SET ENCRYPTION PASSWORD can improve the confidentiality of data and support data integrity by defining or resetting a password for encryption and decryption of data at the column level.
You can set the EncryptionPass and Hint static DBParms on the System tab page in the Database Profile Setup dialog box for INF connections to specify a password and an optional hint to help you remember the password. The password does not display in the database Profile Setup dialog box and is encrypted in the database profile in the registry. The application uses built-in Informix functions to encrypt and decrypt character data.
Examples
To specify Archimedes as the password for data encryption and Eureka as the hint to help you remember the password:
-
Database profile
Enter Archimedes in the Encryption Password box and Eureka in the Hint box on the System page in the Database Profile Setup dialog box.
-
Application
Type the following in code:
SQLCA.DBParm="EncryptionPass='Archimedes', Hint='Eureka'"
See also
