890-SET-Type-FILTER-VALUE

Name

The APIs have names built with the type of filter parameter that is being set.

Filter parameter type API name
Alphanumeric 890-SET-ALPHANUM-FILTER-VALUE
Numeric 890-SET-NUMERIC-FILTER-VALUE
Date and time 890-SET-DATETIME-FILTER-VALUE
Signed

There is a separate call for every signed value for the number of decimal places 0 to 7. The total number of digits is limited to 18.

  • 890-SET-SIGNED-FILTER-VALUE0

  • 890-SET-SIGNED-FILTER-VALUE1

  • 890-SET-SIGNED-FILTER-VALUE2

  • 890-SET-SIGNED-FILTER-VALUE3

  • 890-SET-SIGNED-FILTER-VALUE4

  • 890-SET-SIGNED-FILTER-VALUE5

  • 890-SET-SIGNED-FILTER-VALUE6

  • 890-SET-SIGNED-FILTER-VALUE7

Description

Sets the filter for subsequent database calls.

Using the API in a Program

There are working storage values defined for data storage depending on what you are setting. The "?" symbols in the filter are declared in order using the SET-<Type>-FILTER-VALUE commands. You move the value you want set to the working storage corresponding to that call, and then you perform that call. Set all "?" values in the filter string.

Programming Example

In the example, the database declaration (dbdef) has six decimal places. Because of the use of six decimal places, the SIGNED6-FILTER-VALUE in working storage is used, and then the call 890-SET-SIGNED-FILTER-VALUE6 . There is a separate call for every signed value for the number of decimal places 0 to 7. The total number of digits is limited to 18 for signed values and 18 for numeric values.

MOVE "JKL"               TO ALPHANUM-FILTER-VALUE
PERFORM 890-SET-ALPHANUM-FILTER-VALUE
MOVE -1.2                TO SIGNED6-FILTER-VALUE
PERFORM 890-SET-SIGNED-FILTER-VALUE6