Download Structured Data Environment (SDE)

Command Line (Primary) Commands
CHANGE
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.
CHANGE
476
850
21
100
This will find a match in any numeric field where unformatted representation of the data contains the string "476" and
replaces it with "850". (e.g. a zoned decimal field with value "14760" would become "18500".)
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.
If replacing a string in a character field would exceed the defined maximum length of the field then no update will take place.
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 string1. (Default)
Data must be not equal to string1.
Data must be greater than string1.
Data must be greater than or equal to string1.
Data must be less than string1.
Data must be less than or equal to string1.
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.
string1
The CHANGE search string. The seach string may be any of the following:
◊ An unquoted numeric value. The search string is treated as a numeric value when a numeric field is searched in
a formatted record view. In all other cases a numeric search string is treated as a character string.
◊ An unquoted character string containing no commas or blanks. The search for the character string will be
case-insensitive so that uppercase and lowercase characters are treated as being the same.
◊ A character string enclosed in single (') or double (") quotation marks. The search string may contain embedded
commas and blanks and the character string will be case-insensitive. A string enclosed in quotes may still be
interpreted as a numeric value.
Two adjacent quotation mark characters that are embedded in a search string which is enclosed by the same
quotation mark characters, will be treated as a single occurrence of the character. e.g.
CHANGE
'Jim O''Brien'
'James O''Brien'
Find the character string "Jim O'Brien" and replaces it with "James O'Brien".
◊ A character string enclosed in single (') or double (") quotation marks with the prefix C. This is equivalent to
specifying a quoted search string but that the string search will be case-sensitive. (e.g. C'Book')
◊ A hexadecimal string enclosed in single (') or double (") quotation marks with the prefix X.
◊ A picture string enclosed in single (') or double (") quotation marks with the prefix P.
Picture strings use special characters to represent a generic group of characters as described below. Any
character in a picture string that is not one of these special characters is untranslated.
String
P'='
P'¬'
P'.'
P'#'
P'-'
P'@'
2013-11-13 13:03:23
Description
Any character.
Any non-blank character.
Any non-displayable character.
Any numeric character, 0-9.
Any non-numeric character.
Any uppercase or lowercase alpha character.
Structured Data Environment (SDE)
84