Specifies a password for encrypting and decrypting data.
When to specify EncryptionPass
You must specify the EncryptionPass parameter before connecting
to the database.
I10 Informix
EncryptionPass='value'
Parameter |
Description |
|---|---|
value |
A string that will be used as the password for encrypting and decrypting data. |
None.
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 I10 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.
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'"
