z/OS Values


When entering values on the z/OS criteria selection window, the following rules apply.

When defining formatted conditions, you may enter a value consistent with the selected field format: numbers for numeric fields and alphanumeric for character fields. You may specify multiple values separated by commas to create an OR test for this condition. For example, a,b,c means a or b or c. Alphanumeric data is case sensitive. To define case insensitive conditions you must use unformatted sets and conditions.

When using the special operators is a valid field and is an invalid field for numeric fields, do not specify a value. Leave it blank.

If the field is a FIXPIC or FIXDEC numeric format, your value must not exceed the size of the picture clause. For example, when using PIC S9(2)V9(3), you may enter no more than two digits to the left of the decimal point and no more than three digits to the right of the decimal point. The picture clause is displayed in the field selection dialog metadata. Some metadata attributes of a field are presented in a tool tip box when you hover over the field name.

Embedded blanks are permitted in a value for an alphanumeric field. When entering a value for an alphanumeric field, single quotes are not required, and if used they will be treated as data.

Since a comma is used to create an OR condition, if the alphanumeric value you are testing for contains a comma, or begins with a double quote, use double quotes to delimit the value you are looking for. Examples: A,B tests for A or B; "A,B" tests for A,B; A," tests for A or "; ",A is an error (a value starting with a double quote must end with a double quote and will test for anything between the double quote delimiters); "",A" tests for ",A.

For numeric data types (Binary (B), Numeric (N), Packed (P)) in unformatted sets and conditions, all values must be entered as signed or unsigned integers; no decimal points are allowed. In addition, the length of the number you enter must not exceed the length of the field you specify.

For Bit mask (M), you may enter 2 hex digits (0-9,A-F) or 8 binary digits (0-1), and you may use the comma to provide a list of values. (Examples: FF; 11111111; 0F,70 (hex 0F or hex 70).
For Hex (X), you may enter pairs of 2 hex digits (0-9,A-F) not to exceed the length of the field. You may use the comma to provide a list of values. (Examples: FFFF; AB0000FF; 000C,F1F2 (hex 000C or hex F1F2).

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*