HKY control statement
The HKY control statement specifies the high key value of each unload data set that is to be produced in each scan phase. This control statement is used in the parallel migration unload.
For information about parallel migration unload, see Parallel migration unload.
Note: The
key value in the n-th NPT control statement specifies
the low key of (n+1)-th unload phase. For parallel
migration unload, specify the high key value of each HALDB partition
in the HKY control statement.
The HKY control statement must immediately follow the CTL control statement. If no HKY or NPT control statements are provided, the entire database will be scanned in a single phase.
0........1.........2.........3.........4.........5.........6.........7.........8
12345678901234567890123456789012345678901234567890123456789012345678901234567890
HKYt'keyvalue'
HKYt'keyvalue.......................................
...............................................................................'- Position
- Description
- 1
- Code the HKY keyword to identify the HKY control statement.
- 4
- This required 1-character entry t identifies
the value type. It indicates the format of the node point value field.
Use one of the following keywords:
- C
- Indicates that the high key value field contains keys in character format.
- X
- Indicates that the high key value field contains keys in hexadecimal display format.
- 5 - 80
- This high key value field is a required field.
- Specify a character value up to 256 characters or a hexadecimal value up to 512 characters on one or more lines.
- The high key value must be enclosed by single quotation marks.
- The hexadecimal string must contain an even number of characters (0-F) and be left-aligned in the field.
- FABHFSU pads the key value with X'FF's up to the key length of the root segment.
Note: If you are using a Data Conversion exit for the database and you want to specify a node point value by using a key value (that is, setting a node point value type of 'C' or 'X'), you must specify the key value in the stored form, not in the application form.