HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide
For a SAM file in PDM2 E2 log format, the extraction redefinition statements specify information about fields defined with PDM2 E2 to redefine multiple fields as one field or one field as multiple fields or to extract part of the data. An extraction redefinition statement is required for each dataset. You can specify the extraction redefinition statements in any order.
If you omit an extraction redefinition statement, Datareplicator uses the field defined with PDM2 E2 in the update information definition to execute update processing.
[{{ restruct DBM-name.dataset-name
{{ field redefined-field-name [position data-start-position]
attr redefined-field-attribute(length)[not null]}} ...}} ...]
The specified DBM name, dataset name, and redefined field names must correspond to the target HiRDB's authorization identifier, table name, and column names, respectively.
Table 5-23 Field attributes and lengths permitted for redefined fields
| Field attribute (length) | Description | Field (bytes) |
|---|---|---|
| CHAR(n) | Character string data n: Number of characters (1 <= n <= 30000) |
n |
| NCHAR(n) | Japanese-language character string data n: Number of characters (1 <= n <= 15000) |
n x 2 |
| PACK(m[,n]) | Signed packed decimal data m: Integer section. n: Fraction part. (0 <= m <= 29,0 <= n <= 29,1 <= m + n <= 29) |
(m + [n] + 1) / 2 Value is rounded up. |
| PACKNS(m[,n]) | Unsigned packed decimal data m: Integer section. n: Fraction part. (0 <= m <= 29,0 <= n <= 29,1 <= m + n <= 29) |
(m + [n] + 1) / 2 Value is rounded up. |
| UNPACK(m[,n]) | Signed zoned decimal data m: Integer section. n: Fraction part. (0 <= m <= 29,0 <= n <= 29,1 <= m + n <= 29) |
m + [n] |
| UNPACKNS(m[,n]) | Unsigned zoned decimal data m: Integer section, n: Fraction part (0 <= m <= 29,0 <= n <= 29,1 <= m + n <= 29) |
m + [n] |
| COMP(m[,n]) | COBOL fixed-point binary data m: Integer section. n: Fraction part. (0 <= m <= 18,0 <= n <= 18,1 <= m + n <= 18) |
1 <= m [ + n] <= 4: 2 5 <= m [ + n] <= 9: 4 10 <= m [ + n] <= 18: 8 |
| BINARY(m[,n]) | PL/I fixed-point binary data m: Precision. n: Scaling. (1 <= m <= 31,0 <= n <= 31,m >=n) |
1 <= m <= 15: 2 16 <= m <= 31: 4 |
| FLOAT(n) | Floating-point data n: Length in bytes (n = 4,8) |
n |
All rights reserved. Copyright (C) 2007, 2013, Hitachi, Ltd.