Download Structured Data Environment (SDE)

Command Line (Primary) Commands
FIND
is not necessarily the same as the unformatted record data.)
Where a BOUNDS column occurs within a field definition, then the following rules apply:
1. For character data type fields, only the area of the field that falls within the BOUNDS columns is eligible for the search.
2. For numeric data type fields, the field is not eligible to be included in the search.
If one or more field columns are specified on the FIND command (using field_col or field_col1:field_col2) that do not reference at
least one field defined by the BOUNDS columns as being eligible for search, then the following error message is returned:
ZZSD280E No fields selected within the current bounds for the FIND command.
If a field column is specified on the FIND command that is not part of the display (e.g. a group field or a field that has been removed
from display by a SELECT command), then the following error message is returned:
ZZSD179E Data element field_col is not selected in the current view
of record type record-type of structure struct_name.
For character data type fields, a string compare is performed. For numeric data type fields (binary, packed decimal, floating point,
zoned, etc.), then the following will occur:
1. If pos1, pos2 positional parameters are not specified, the search string is interpreted as a signed numeric value and an
arithmetic compare is performed against the field's formatted numeric value.
The length and data type of the numeric field, and the number of digits in the search value are not significant. e.g.
FIND
67
Finds numeric fields with value "67" (e.g. "0067", "67.00", "0.0670E+03") and character fields containing the string "67"
(e.g. "167 Baker Street").
If the search string is non-numeric, then numeric data type fields are not searched. Therefore, to bypass searching
numeric data type fields, explicitly set the search string to be character or hex using 'string', C'string' or X'string' formats
respectively. e.g.
FIND
FIND
FIND
'67'
C'67'
X'F6F7'
Finds only character fields containing the string "67".
2. If pos1, pos2 positional parameters are specified, the search string is interpreted as being a character string and so a
string compare is performed against the unformatted representation of the field data for fields falling entirely or partly
within the range of record positions.
Although the range of positions may span a number of fields, the search is still performed against individual fields within
the range. i.e. a match for the search string will not occur for data that spans a field boundary.
A match for the search string may occur on just part of the unformatted data representation of a numeric field. e.g.
FIND
476
21
100
This will find a match in any numeric field where unformatted representation of the data contains the string "476". (e.g. a
zoned decimal field with value "14760" or "-4762")
Any match of the search string on data in a numeric field will highlight the entire formatted display of the field. If the numeric field is
also the current, identified occurrence of the search string, the cursor is positioned at the start of the formatted numeric field
display.
Parameters:
op
A relational operator used in the compare operation which determines the relationship that the data must have with the
search string in order for it to be identified as a successful match.
Valid values for op are as follow:
Operator
EQ
NE
GT
GE
LT
LE
Description
Data must be equal to string. (Default)
Data must be not equal to string.
Data must be greater than string.
Data must be greater than or equal to string.
Data must be less than string.
Data must be less than or equal to string.
If a character string compare is performed, the EBCDIC values assigned to characters in the search and data strings
determine the relationship (equal to, greater than or less than) between the two strings.
2013-11-13 13:03:23
Structured Data Environment (SDE)
127