The fields include the key field used in the sort option and merge option, the record summation field used in the record summation option, selection field (compared field and comparing field) used in the record selection option and reconstruction field used in the record reconstruction options.
The following shows the data formats that can be specified in each key field and its length. In the table, typ is used when specifying in the PowerBSORT command line interface or OCX and definition value is used in the BSORT function.
Type | Data format | typ | Defined value | Length(Byte) | |
---|---|---|---|---|---|
Character | ASCII code | asc | BSKEY_ASC | 1-Record length (Note 1) | |
EBCDIC code (Note 2) | ebc | BSKEY_EBC | 1-Record length (Note 1) | ||
Shift JIS code (Note 3) | sji | BSKEY_SJI | 1-Record length (Note 1) | ||
JEF code (Note 4) | jef | BSKEY_JEF | 2-Record length (Multiples of 2) (Note 1) | ||
Unicode UCS-2 form (Note 5)(Note 12) | uc2 | BSKEY_UCS2 | 2-Record length (Multiples of 2) (Note 1) | ||
Big endian | u2b | BSKEY_UCS2B | 2-Record length (Multiples of 2) (Note 1) | ||
Little endian | u2l | BSKEY_UCS2L | 2-Record length (Multiples of 2) (Note 1) | ||
Unicode UTF-32 form (Note 5)(Note 13) | u32 | BSKEY_UTF32 | 4-Record length (Multiples of 4) (Note 1) | ||
Big endian | u3b | BSKEY_UTF32B | 4-Record length (Multiples of 4) (Note 1) | ||
Little endian | u3l | BSKEY_UTF32L | 4-Record length (Multiples of 4) (Note 1) | ||
Unicode UTF-8 form (Note 5) | ut8 | BSKEY_UTF8 | 1-Record length (Note 1) | ||
Character form two digit years (Note 6) | yyc | BSKEY_YYC | 2, 4 or 8 (Note 7) | ||
Modify collation sequence (Note 8) | col | BSKEY_COL | 1-Record length (Note 1) | ||
Numeric | Unsigned binary number | bit | BSKEY_BIT | 1-8(bit) | |
Fixed-point binary number | fbi | BSKEY_FBI | 1-256 | ||
Unsigned fixed-point binary number | ufb | BSKEY_UFB | 1-256 | ||
Fixed-point binary number - little endian | fbl | BSKEY_FBL86 | 1-256 | ||
Unsigned fixed-point binary number - little endian | ufl | BSKEY_UFB86 | 1-256 | ||
Fixed-point binary number - system depend | fbm | BSKEY_FBIM | 1-256 | ||
Unsigned fixed-point binary number - system depend | ufm | BSKEY_UFBM | 1-256 | ||
IEEE floating-point binary number | ifl | BSKEY_IFL | 1-256 | ||
M floating-point binary number | mfl | BSKEY_MFL | 1-256 | ||
Packed decimal number | pdl | BSKEY_PDL | 1-256 | ||
Unsigned packed decimal number (with sign nibble) (Note 8) | BSKEY_PDF | 1-256 | |||
Unsigned packed decimal number (without sign nibble) | pdu | BSKEY_PDU | 1-256 | ||
External decimal number | zdl | BSKEY_ZDL | 1-256 | ||
Unsigned external decimal number | zdu | BSKEY_ZDU | 1-256 | ||
Packed decimal form two digit years (Note 6) | yyp | BSKEY_YYP | 2 | ||
External decimal form two digit years (Note 6) | yyz | BSKEY_YYZ | 2 | ||
Decimal form two digit years (Note 6) | yyd | BSKEY_YYD | 1 | ||
Number | Unsigned number | azu | BSKEY_AZU | 1-256 | |
Leading separate signed number | als | BSKEY_ALS | 2-256 | ||
Trailing separate signed number | ats | BSKEY_ATS | 2-256 | ||
Leading overpunch signed number | alo | BSKEY_ALO | 1-256 | ||
Trailing overpunch signed number | ato | BSKEY_ATO | 1-256 |
Type | Data format | typ | Defined value | Length(Byte) | |
---|---|---|---|---|---|
Character | ASCII code (Note 3) | asc | BSKEY_ASC | 1-Record length (Note 1) | |
EBCDIC code (Note 3) | ebc | BSKEY_EBC | 1-Record length (Note 1) | ||
Shift JIS code (Note 3) | sji | BSKEY_SJI | 1-Record length (Note 1) | ||
Unicode UCS-2 form (Note 9)(Note 12) | uc2 | BSKEY_UCS2 | 2-Record length (Multiples of 2) (Note 1) | ||
Big endian | --- | BSKEY_UCS2B | 2-Record length (Multiples of 2) (Note 1) | ||
Little endian | --- | BSKEY_UCS2L | 2-Record length (Multiples of 2) (Note 1) | ||
Unicode UTF-32 form (Note 10)(Note 13) | u32 | BSKEY_UTF32 | 4-Record length (Multiples of 4) (Note 1) | ||
Big endian | --- | BSKEY_UTF32B | 4-Record length (Multiples of 4) (Note 1) | ||
Little endian | --- | BSKEY_UTF32L | 4-Record length (Multiples of 4) (Note 1) | ||
Unicode UTF-8 form (Note 11) | ut8 | BSKEY_UTF8 | 1-Record length (Note 1) | ||
Character form two digit years (Note 6) | yyc | BSKEY_YYC | 2, 4 or 8 (Note 7) | ||
Modify collation sequence (Note 3)(Note 8) | col | BSKEY_COL | 1-Record length (Note 1) |
NOTES
When the record reconstruction option of the input file is specified, up to the record length after the reconstruction of the input record can be specified.
Can be specified if the code system of the input file is ASCII or EBCDIC.
Can be specified if the code system of the input file is ASCII.
Can be specified if the code system of the input file is EBCDIC.
Can be specified if the code system of the input file is other than the EBCDIC.
Years processing is executed according to the value specified by the environment variable BSORT_TOPYY.
When the code system of the input file is Unicode (UCS-2 form), the length is 4 bytes. When the code system of the input file is Unicode (UTF-32 form), the length is 8 bytes.
Cannot be specified when OCX is used.
Can be specified if the code system of the input file is Unicode (UCS-2 form).
Can be specified if the code system of the input file is Unicode (UTF-32 form).
Can be specified if the code system of the input file is Unicode (UTF-8 form).
When specifying data format in the bsort command, the bsortex command, and OCX, byte order follows the specification of the environment variable BSORT_UCS2TYPE.
When specifying data format in the bsort command and the bsortex command, byte order follows the specification of the environment variable BSORT_UTF32TYPE.
The following shows the data formats that can be specified in the summation field and its length. In the table, typ is used when specifying in the PowerBSORT command line interface or OCX and the definition value is used in the BSORT function.
Type | Data format | typ | Defined value | Length(Byte) |
---|---|---|---|---|
Numeric | Fixed-point binary number | fbi | BSKEY_FBI | 1-16 |
Unsigned fixed-point binary number | ufb | BSKEY_UFB | 1-16 | |
Fixed-point binary number - little endian | fbl | BSKEY_FBL86 | 1-16 | |
Unsigned fixed-point binary number - little endian | ufl | BSKEY_UFB86 | 1-16 | |
Fixed-point binary number - system depend | fbm | BSKEY_FBIM | 1-16 | |
Unsigned fixed-point binary number - system depend | ufm | BSKEY_UFBM | 1-16 | |
Packed decimal number | pdl | BSKEY_PDL | 1-16 | |
Unsigned packed decimal number (with sign nibble) (Note 1) | BSKEY_PDF | 1-16 | ||
Unsigned packed decimal number (without sign nibble) | pdu | BSKEY_PDU | 1-16 | |
External decimal number | zdl | BSKEY_ZDL | 1-32 | |
Unsigned external decimal number | zdu | BSKEY_ZDU | 1-32 | |
Number | Unsigned number | azu | --- | 1-32 |
Leading separate signed number | als | --- | 2-32 | |
Trailing separate signed number | ats | --- | 2-32 | |
Leading overpunch signed number | alo | --- | 1-32 | |
Trailing overpunch signed number | ato | --- | 1-32 |
Type | Data format | typ | Defined value | Length(Byte) | |
---|---|---|---|---|---|
Character | ASCII code (Note 3) | asc | BSKEY_ASC | 1-256 or Record length (Note 4) | |
Unicode UCS-2 form (Note 5)(Note 8) | uc2 | BSKEY_UCS2 | 2-256 or Record length (Multiples of 2) (Note 4) | ||
Big endian | --- | BSKEY_UCS2B | 2-256 (Multiples of 2) (Note 4) | ||
Little endian | --- | BSKEY_UCS2L | 2-256 (Multiples of 2) (Note 4) | ||
Unicode UTF-32 form (Note 1)(Note 6)(Note 9) | u32 | BSKEY_UTF32 | 4-256 or Record length (Multiples of 4) (Note 4) | ||
Big endian | --- | BSKEY_UTF32B | 4-256 or Record length (Multiples of 4) (Note 4) | ||
Little endian | --- | BSKEY_UTF32L | 4-256 or Record length (Multiples of 4) (Note 4) | ||
Unicode UTF-8 form (Note 7) | ut8 | BSKEY_UTF8 | 1-256 or Record length (Note 4) |
NOTES
Cannot be specified when OCX is used.
Can be specified only in the bsortex command.
Can be specified if the code system of the input file is ASCII.
When the bsortex command is used, up to the record length can be specified. With the bsort command, OCX, and the BSORT function, up to 256 bytes can be specified. When the record reconstruction option of the input file is specified, up to the record length after the input record is reconstructed can be specified.
Can be specified if the code system of the input file is Unicode (UCS-2 form).
Can be specified if the code system of the input file is Unicode (UTF-32 form).
Can be specified if the code system of the input file is Unicode (UTF-8 form).
When specifying data format in the bsort command, the bsortex command, and OCX, byte order follows the specification of the environment variable BSORT_UCS2TYPE.
When specifying data format in the bsort command and the bsortex command, byte order follows the specification of the environment variable BSORT_UTF32TYPE.
The selection fields specified in the record selection option include the compared field and comparing field.
This section shows the combination of the data formats that can be specified in the compared field, comparing field and literal value.
Data formats that can be specified in the compared field and comparing field
The following shows the data formats that can be specified in the compared field and comparing field. In the table, typ is used when specifying in the PowerBSORT command line interface or OCX and the definition values are used in the BSORT function.
Type | Data format | typ | Defined value | Length(Byte) | |
---|---|---|---|---|---|
Character | ASCII code (Note 1) | asc | BSKEY_ASC | 1-256 | |
EBCDIC code (Note 2) | ebc | BSKEY_EBC | 1-256 | ||
Shift JIS code (Note 3) | sji | BSKEY_SJI | 1-256 | ||
Unicode UCS-2 form (Note 1)(Note 10) | uc2 | BSKEY_UCS2 | 2-256 | ||
Big endian | u2b | BSKEY_UCS2B | 2-256 | ||
Little endian | u2l | BSKEY_UCS2L | 2-256 | ||
Unicode UTF-32 form (Note 1)(Note 6)(Note 11) | u32 | BSKEY_UTF32 | 4-256 | ||
Big endian | u3b | BSKEY_UTF32B | 4-256 | ||
Little endian | u3l | BSKEY_UTF32L | 4-256 | ||
Unicode UTF-8 form (Note 1) | ut8 | BSKEY_UTF8 | 1-256 | ||
Character form two digit years (Note 4) | yyc | ---- | 2, 4 or 8 (Note 5) | ||
Modify collation sequence (Note 6) | col | BSKEY_COL | 1-256 | ||
Numeric | Unsigned binary number | bit | BSKEY_BIT | 1-8(bit) | |
Fixed-point binary number | fbi | BSKEY_FBI | 1-256 | ||
Unsigned fixed-point binary number | ufb | BSKEY_UFB | 1-256 | ||
Fixed-point binary number - little endian | fbl | BSKEY_FBL86 | 1-256 | ||
Unsigned fixed-point binary number - little endian | ufl | BSKEY_UFB86 | 1-256 | ||
Fixed-point binary number - system depend | fbm | BSKEY_FBIM | 1-256 | ||
Unsigned fixed-point binary number - system depend | ufm | BSKEY_UFBM | 1-256 | ||
Packed decimal number | pdl | BSKEY_PDL | 1-256 | ||
Unsigned packed decimal number (with sign nibble) (Note 6) | BSKEY_PDF | 1-256 | |||
Unsigned packed decimal number (without sign nibble) | pdu | BSKEY_PDU | 1-256 | ||
External decimal number | zdl | BSKEY_ZDL | 1-256 | ||
Unsigned external decimal number | zdu | BSKEY_ZDU | 1-256 | ||
Packed decimal form two digit years (Note 4) | yyp | ---- | 2 | ||
External decimal form two digit years (Note 4) | yyz | ---- | 2 | ||
Decimal form two digit years (Note 4) | yyd | ---- | 1 | ||
Number | Unsigned number | azu | BSKEY_AZU | 1-256 | |
Leading separate signed number | als | BSKEY_ALS | 2-256 | ||
Trailing separate signed number | ats | BSKEY_ATS | 2-256 | ||
Leading overpunch signed number | alo | BSKEY_ALO | 1-256 | ||
Trailing overpunch signed number | ato | BSKEY_ATO | 1-256 |
Type | Data format | typ | Defined value | Length(Byte) | |
---|---|---|---|---|---|
Character | ASCII code (Note 3) | asc | BSKEY_ASC | 1-256 | |
Shift JIS code (Note 3) | sji | BSKEY_SJI | 1-256 | ||
Unicode UCS-2 form (Note 7)(Note 10) | uc2 | BSKEY_UCS2 | 2-256 | ||
Big endian | --- | BSKEY_UCS2B | 2-256 | ||
Little endian | --- | BSKEY_UCS2L | 2-256 | ||
Unicode UTF-32 form (Note 6)(Note 8)(Note 11) | u32 | BSKEY_UTF32 | 4-256 | ||
Big endian | --- | BSKEY_UTF32B | 4-256 | ||
Little endian | --- | BSKEY_UTF32L | 4-256 | ||
Unicode UTF-8 form (Note 9) | ut8 | BSKEY_UTF8 | 1-256 | ||
Character form two digit years (Note 4) | yyc | ---- | 2, 4 or 8 (Note 5) | ||
Modify collation sequence (Note 3)(Note 6) | col | BSKEY_COL | 1-256 |
NOTES
Can be specified if the code system of the input file is other than the EBCDIC.
Can be specified if the code system of the input file is EBCDIC.
Can be specified if the code system of the input file is ASCII.
Can be specified in the bsortex command only. Years processing is executed according to the value specified by the environment variable BSORT_TOPYY.
When the code system of the input file is Unicode (UCS-2 form), the length is 4 bytes. When the code system of the input file is Unicode (UTF-32 form), the length is 8 bytes.
Cannot be specified when OCX is used.
Can be specified if the code system of the input file is Unicode (UCS-2 form).
Can be specified if the code system of the input file is Unicode (UTF-32 form).
Can be specified if the code system of the input file is Unicode (UTF-8 form).
When specifying data format in the bsort command, the bsortex command, and OCX, byte order follows the specification of the environment variable BSORT_UCS2TYPE.
When specifying data format in the bsort command and the bsortex command, byte order follows the specification of the environment variable BSORT_UTF32TYPE.
Combinations of the data formats that can be specified in the compared field and comparing field
The following shows the combinations of data formats that can be specified in the compared field and comparing field.
Type | Data format of compared field | Data format of comparing field |
---|---|---|
Character | ASCII code | ASCII code |
EBCDIC code | EBCDIC code | |
Shift JIS code | Shift JIS code | |
Unicode UCS-2 form | Unicode UCS-2 form | |
Unicode UCS-2 form (Big endian) | Unicode UCS-2 form (Big endian) | |
Unicode UCS-2 form (Little endian) | Unicode UCS-2 form (Little endian) | |
Unicode UTF-32 form | Unicode UTF-32 form | |
Unicode UTF-32 form (Big endian) | Unicode UTF-32 form (Big endian) | |
Unicode UTF-32 form (Little endian) | Unicode UTF-32 form (Little endian) | |
Unicode UTF-8 form | Unicode UTF-8 form | |
Character form two digit years | Character form two digit years | |
Modify collation sequence | Modify collation sequence | |
Numeric | Unsigned binary number | Unsigned binary number |
Fixed-point binary number | Fixed-point binary number | |
Unsigned fixed-point binary number | Unsigned fixed-point binary number | |
Fixed-point binary number - little endian | Fixed-point binary number | |
Unsigned fixed-point binary number - little endian | Unsigned fixed-point binary number | |
Fixed-point binary number - system dependent | Fixed-point binary number | |
Unsigned fixed-point binary number - system dependent | Unsigned fixed-point binary number | |
Packed decimal number | Packed decimal number | |
Unsigned packed decimal number (with sign nibble) | Packed decimal number | |
Unsigned packed decimal number (without sign nibble) | Packed decimal number | |
External decimal number | Packed decimal number | |
Unsigned external decimal number | Packed decimal number | |
Packed decimal form two digit years | Character form two digit years | |
External decimal form two digit years | Character form two digit years | |
Decimal form two digit years | Character form two digit years | |
Number | Unsigned number | Unsigned number |
Leading separate signed number | Unsigned number | |
Trailing separate signed number | Unsigned number | |
Leading overpunch signed number | Unsigned number | |
Trailing overpunch signed number | Unsigned number |
Type | Data format of compared field | Data format of comparing field |
---|---|---|
Character | ASCII code | ASCII code |
Shift JIS code | Shift JIS code | |
Unicode UCS-2 form | Unicode UCS-2 form | |
Unicode UCS-2 form (Big endian) | Unicode UCS-2 form (Big endian) | |
Unicode UCS-2 form (Little endian) | Unicode UCS-2 form (Little endian) | |
Unicode UTF-32 form | Unicode UTF-32 form | |
Unicode UTF-32 form (Big endian) | Unicode UTF-32 form (Big endian) | |
Unicode UTF-32 form (Little endian) | Unicode UTF-32 form (Little endian) | |
Unicode UTF-8 form | Unicode UTF-8 form | |
Character form two digit years | Character form two digit years | |
Modify collation sequence | Modify collation sequence |
Combinations of data formats that can be specified in the compared field and literal value
The following shows the combination of the data formats that can be specified in the compared field and literal value.
Type | Data format of compared field | Literal value |
---|---|---|
Character | ASCII code | Character, Hexadecimal |
EBCDIC code | Character, Hexadecimal | |
Shift JIS code | Character | |
Unicode UCS-2 form | Character, Hexadecimal | |
Unicode UTF-32 form | Character (Note 1), Hexadecimal | |
Unicode UTF-8 form | Character, Hexadecimal | |
Character form two digit years | Character, Hexadecimal, Decimal number | |
Modify collation sequence | Character, Hexadecimal | |
Numeric | Unsigned binary number | Decimal number |
Fixed-point binary number | Decimal number | |
Unsigned fixed-point binary number | Decimal number | |
Fixed-point binary number - little endian | Decimal number | |
Unsigned fixed-point binary number - little endian | Decimal number | |
Fixed-point binary number - system depend | Decimal number | |
Unsigned fixed-point binary number - system depend | Decimal number | |
Packed decimal number | Decimal number | |
Unsigned packed decimal number (with sign nibble) | Decimal number | |
Unsigned packed decimal number (without sign nibble) | Decimal number | |
External decimal number | Decimal number | |
Unsigned external decimal number | Decimal number | |
Packed decimal form two digit years | Decimal number | |
External decimal form two digit years | Decimal number | |
Decimal form two digit years | Decimal number | |
Number | Unsigned number | Decimal number |
Leading separate signed number | Decimal number | |
Trailing separate signed number | Decimal number | |
Leading overpunch signed number | Decimal number | |
Trailing overpunch signed number | Decimal number |
Type | Data format of compared field | Literal value |
---|---|---|
Character | ASCII code | Character, Hexadecimal |
Shift JIS code | Character | |
Unicode UCS-2 form | Character, Hexadecimal | |
Unicode UTF-32 form | Character (Note 1), Hexadecimal | |
Unicode UTF-8 form | Character, Hexadecimal | |
Character form two digit years | Character, Hexadecimal, Decimal number | |
Modify collation sequence | Character, Hexadecimal |
NOTES
Only the character within the range of ASCII code can be specified.
The following shows the data formats that can be specified in the literal value of reconstruction field and their length. In the table, typ is used when specifying in the PowerBSORT command line interface or OCX.
Literal value | Data format | typ | Length(Byte) | |
---|---|---|---|---|
Character | ASCII code (Note 1) | asc | 1-256 | |
EBCDIC code (Note 2) | ebc | 1-256 | ||
Shift JIS code (Note 3) | sji | 1-256 | ||
Unicode UCS-2 form (Note 1)(Note 9) | uc2 | 2-256 | ||
Big endian | u2b | 2-256 | ||
Little endian | u2l | 2-256 | ||
Unicode UTF-32 form (Note 1)(Note 4)(Note 8)(Note 10) | u32 | 4-256 | ||
Big endian (Note 8) | u3b | 4-256 | ||
Little endian (Note 8) | u3l | 4-256 | ||
Unicode UTF-8 form (Note 1) | ut8 | 1-256 | ||
Hexadecimal | ASCII code (Note 1) | asc | 1-256 | |
EBCDIC code (Note 2) | ebc | 1-256 | ||
Unicode UCS-2 form (Note 1)(Note 9) | uc2 | 2-256 | ||
Big endian | u2b | 2-256 | ||
Little endian | u2l | 2-256 | ||
Unicode UTF-32 form (Note 1)(Note 4)(Note 10) | u32 | 4-256 | ||
Big endian | u3b | 4-256 | ||
Little endian | u3l | 4-256 | ||
Unicode UTF-8 form (Note 1) | ut8 | 1-256 | ||
Decimal number | Fixed-point binary number | fbi | 1-16 | |
Unsigned fixed-point binary number | ufb | 1-16 | ||
Fixed-point binary number - little endian | fbl | 1-16 | ||
Unsigned fixed-point binary number - little endian | ufl | 1-16 | ||
Fixed-point binary number - system depend | fbm | 1-16 | ||
Unsigned fixed-point binary number - system depend | ufm | 1-16 | ||
Packed decimal number | pdl | 1-16 | ||
Unsigned packed decimal number (with sign nibble) (Note 4) | 1-16 | |||
Unsigned packed decimal number (without sign nibble) | pdu | 1-16 | ||
External decimal number | zdl | 1-32 | ||
Unsigned external decimal number | zdu | 1-32 | ||
Unsigned number | azu | 1-32 | ||
Leading separate signed number | als | 2-32 | ||
Trailing separate signed number | ats | 2-32 | ||
Leading overpunch signed number | alo | 1-32 | ||
Trailing overpunch signed number | ato | 1-32 |
Literal value | Data format | typ | Length(Byte) |
---|---|---|---|
Character | ASCII code (Note 3) | asc | 1-256 |
Shift JIS code (Note 3) | sji | 1-256 | |
Unicode UCS-2 form (Note 5)(Note 9) | uc2 | 2-256 | |
Unicode UTF-32 form (Note 4)(Note 6)(Note 8)(Note 10) | u32 | 4-256 | |
Unicode UTF-8 form (Note 7) | ut8 | 1-256 | |
Hexadecimal | ASCII code (Note 3) | asc | 1-256 |
Unicode UCS-2 form (Note 5)(Note 9) | uc2 | 2-256 | |
Unicode UTF-32 form (Note 4)(Note 6)(Note 10) | u32 | 4-256 | |
Unicode UTF-8 form (Note 7) | ut8 | 1-256 |
NOTES
Can be specified if the code system of the input file is other than EBCDIC.
Can be specified if the code system of the input file is EBCDIC.
Can be specified if the code system of the input file is ASCII.
Cannot be specified when OCX is used.
Can be specified if the code system of the input file is Unicode (UCS-2 form).
Can be specified if the code system of the input file is Unicode (UTF-32 form).
Can be specified if the code system of the input file is Unicode (UTF-8 form).
Only the character within the range of ASCII code can be specified.
When specifying data format in the bsort command, the bsortex command, and OCX, byte order follows the specification of the environment variable BSORT_UCS2TYPE.
When specifying data format in the bsort command and the bsortex command, byte order follows the specification of the environment variable BSORT_UTF32TYPE.