Hint

Description

Specifies a hint to assist in remembering the password specified for encrypting and decrypting data.

When to specify Hint You must specify the Hint parameter before connecting to the database.

Applies to

I10 Informix

Syntax

Hint='value'

Parameter	Description
value	A string that will be used as a hint to help you remember the password used for encrypting and decrypting data.

Default

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

Example 1

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'"