U@FLTS<Type>

Name

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

Filter parameter type API name
Alphanumeric U@FLTSALPHANUM
Numeric U@FLTSNUMERIC
Date and time U@FLTSDATETIME
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.

  • U@FLTSSIGNED0

  • U@FLTSSIGNED1

  • U@FLTSSIGNED2

  • U@FLTSSIGNED3

  • U@FLTSSIGNED4

  • U@FLTSSIGNED5

  • U@FLTSSIGNED6

  • U@FLTSSIGNED7

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 U@FLTS<Type> 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 E@FLTVSIGNED6 in working storage is used, and then the call U@FLTSSIGNED6. 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.

    EVAL      E@FLTVALPHANUM = "JKL" 
    CALLP     U@FLTSALPHANUM
    EVAL      E@FLTVSIGNED6  = -1.2
    CALLP     U@FLTSSIGNED6