Field List for Extraction Condition Settings
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|
|---|---|---|---|---|---|
|
Setting type |
(#1) |
All records, Custom |
No |
|
|
|
Setting type = Custom |
|||||
|
|
Field list |
|
Display only |
|
|
|
Extraction condition element name |
|
Select from field list |
Yes |
|
|
|
#1 |
: |
Set as All records if the details of settings in the Input Settings screen are any of the following:
If XML is selected for Format and Element is selected for XML record unit in the Input Settings screen, Custom is applied. |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|
|---|---|---|---|---|---|
|
Extraction condition number |
|
Display only |
|
|
|
|
Comment |
|
Characters |
Yes |
255 bytes or fewer |
|
|
Format |
|
Multi Format key specified with input settings, and format information |
No |
|
|
|
Group or record |
|
Hierarchy format group specified with input settings, and record information |
No |
|
|
|
Record unit element name |
|
Custom element name specified when adding extraction conditions |
No |
|
|
|
Conditions |
|||||
|
|
No. |
|
Display only |
|
|
|
Condition |
|
Display only |
|
|
|
|
Conditional logic formula |
|
Alphanumeric characters, symbols (#1), and halfwidth spaces |
No |
9999 bytes or fewer |
|
|
Automatically combine AND conditions |
ON |
ON, OFF |
No |
|
|
|
If a condition is met, do not evaluate any subsequent conditions |
OFF |
ON, OFF |
No |
|
|
|
Processing of the length of compared character strings and values |
Pad with null values |
Pad with null values, Pad with spaces |
No |
|
|
|
#1 |
: |
You can use only numeric values, left parenthesis ((), right parenthesis ()), AND, OR, and ! (NOT). |
|
Field name |
Initial value |
Possible settings |
Omission possible |
Remarks |
|
|---|---|---|---|---|---|
|
Comparison source |
|||||
|
|
Comparison source type |
Record |
Record, Input field, Matching field, Variable |
No |
|
|
Comparison source type = Record |
|||||
|
|
Matching number |
If there is a matching setting: 1 |
Matching number of matching file |
No |
(#2) |
|
Units for comparison |
Target records |
Target records, Total number of input records, Number of input records hit |
No |
(#2) |
|
|
Comparison source type = Input field (ID specified) |
|||||
|
|
Specification method |
Field name |
Field name, Field number |
No |
|
|
Field name (Field number) |
|
Result of the Select field screen |
No |
|
|
|
Output method |
Skip processing |
Skip processing, Function (#8), Common Components (#7) |
No |
|
|
|
Comparison source type = Input field (no ID specified) |
|||||
|
|
Field No. |
|
1 to 9999 |
No |
|
|
Output method |
Skip processing |
Skip processing, Function (#8), Common Components (#7) |
No |
|
|
|
Comparison source type = Matching field (ID specified) (#2) |
|||||
|
|
Matching number |
If there is a matching setting: 1 |
Matching number of matching file |
No |
|
|
Field No. |
|
Result of the Select field screen |
No |
|
|
|
Output method |
Skip processing |
Skip processing, Function (#8), Common Components (#7) |
No |
|
|
|
Comparison source type = Matching field (no ID specified) (#2) |
|||||
|
|
Matching number |
If there is a matching setting: 1 |
Matching number of matching file |
No |
|
|
Field number |
|
1 to 9999 |
No |
|
|
|
Output method |
Skip processing |
Skip processing, Function (#8), Common Components (#7) |
No |
|
|
|
Comparison source type = Variable |
|||||
|
|
Variable name |
|
Result of the Select variable screen |
No |
|
|
Output method |
Skip processing |
Skip processing, Function (#8), Common Components (#7) |
No |
|
|
|
Field information (Comparison source) |
|||||
|
|
No. of occurrences |
|
Display only |
|
(#3) |
|
Field type |
|
Display only |
|
(#3) |
|
|
Variable type |
|
Display only |
|
(#4) |
|
|
Initial value |
|
Display only |
|
(#4) |
|
|
Operator (#6) |
|
<, >, <=, >=, ==, !=, Begins with, Ends with, Contains, Equals, Not equal |
No |
|
|
|
Comparison target |
|||||
|
|
Comparison target type |
Fixed value |
Fixed value, Runtime argument, Input field, Matching field, Variable |
No |
|
|
Comparison target type = Fixed value |
|||||
|
|
Type |
Numeric value |
Character string, Numeric value, Date, Character string (Hexadecimal), Null |
No |
|
|
Value |
|
Characters (#1) |
No |
1024 bytes or fewer |
|
|
Comparison target type = Runtime argument |
|||||
|
|
Type |
$DSTR |
$DSTR, $DSTR (Hexadecimal), $DSTR (Date), $DNUM (Numeric value) |
No |
|
|
No |
01 |
01 to 20 |
No |
|
|
|
Comparison target type = Input field (ID specified) |
|||||
|
|
Type |
Character string |
Character string, Numeric value, Date |
No |
|
|
Specification method |
Field Name |
Field name, Field number |
No |
|
|
|
Field Name |
|
Result of the Select field screen |
No |
|
|
|
Field number |
|
Result of the Select field screen |
No |
|
|
|
Comparison target type = Input field (no ID specified) |
|||||
|
|
Type |
Character string |
Character string, Numeric value, Date |
No |
|
|
Field number |
|
1 to 9999 |
No |
|
|
|
Comparison target type = Matching field (ID specified) (#2) |
|||||
|
|
Matching number |
If there is a matching setting: 1 |
Matching number of matching file |
No |
|
|
Type |
Character string |
Character string, Numeric value, Date |
No |
|
|
|
Field number |
|
Result of the Select field screen |
No |
|
|
|
Comparison target type = Matching field (no ID specified) (#2) |
|||||
|
|
Matching number |
If there is a matching setting: 1 |
Matching number of matching file |
No |
|
|
Type |
Character string |
Character string, Numeric value, Date |
No |
|
|
|
Field number |
|
1 to 9999 |
No |
|
|
|
Comparison source type = Variable |
|||||
|
|
Variable name |
|
Result of the Select variable screen |
No |
|
|
Variable Type |
|
Display only |
|
|
|
|
Initial Value |
|
Display only |
|
|
|
|
Field information (Comparison target) (#5) |
|||||
|
#1 |
: |
External characters cannot be used. Operations are not guaranteed if you use any platform-dependent characters. If Character string is selected for Type, control characters can be used. To use control characters, specify 1 for Use control characters inside a fixed value (ed_fixvalue_ctrlchar_flag) in the system environment settings file (huledenv.conf). |
|
#2 |
: |
This field is displayed only if a matching file has been set. |
|
#3 |
: |
This field is displayed only if Input field or Matching field with an ID specified is selected in Comparison source type. |
|
#4 |
: |
This field is displayed only if Variable is selected in Comparison source type. |
|
#5 |
: |
Same as Field information (comparison source). |
|
#6 |
: |
Operator that is displayed varies depending on the details of the selected comparison target. |
|
#7 |
: |
If you select Common components for Output method, the arguments and comment are displayed as defined for the target common component ID. |
|
#8 |
: |
If you select Function for Output method, you can select a function from the list of functions. You can input a maximum of 10 functions. |