Description
- password-variable
- Specifies a variable that contains an encryption password.
The variable:
- Must be a CHAR, VARCHAR, Unicode GRAPHIC, or Unicode VARGRAPHIC
variable. The actual length of the contents of the variable must be between
6 and 127 inclusive or must be an empty string. If an empty string is specified,
the default encryption password is set to no value.
- Must not be the null value.
- All characters are case-sensitive and are not converted to uppercase characters.
- password-string-constant
- A character constant. The length of the constant must be between 6 and
127 inclusive or must be an empty string. If an empty string is specified,
the default encryption password is set to no value. The literal form of the
password is not allowed in static SQL or REXX.
- WITH HINT
- Indicates that a value is specified that will help data owners remember
passwords (for example, 'Ocean' as a hint to remember 'Pacific'). If a hint
value is specified, the hint is used as the default for encryption functions.
The hint can subsequently be retrieved for an encrypted value using the GETHINT
function. If this clause is not specified and a hint is not explicitly specified
on the encryption function, no hint will be embedded in encrypted data result.
- hint-variable
- Specifies a variable that contains an encryption password hint.
The variable:
- Must be a CHAR, VARCHAR, Unicode GRAPHIC, or Unicode VARGRAPHIC
variable. The actual length of the contents of the variable must not be greater
than 32. If an empty string is specified, the default encryption password
hint is set to no value.
- Must not be the null value.
- All characters are case-sensitive and are not converted to uppercase characters.
- hint-string-constant
- A character constant. The length of the constant must not be greater
than 32. If an empty string is specified, the default encryption password
hint is set to no value.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.