EncryptionPass
database parameter
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
I10 Informix
Syntax
|
1 |
EncryptionPass='value' |
|
Parameter |
Description |
|---|---|
|
value |
A string that will be used as the password for |
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 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.
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:
12SQLCA.DBParm="EncryptionPass='Archimedes',Hint='Eureka'"
See also