Setting the Filter Parameter Value

You can use the following methods to set the value of a filter parameter:

Method 1: Supply a Literal Value

Supply a literal value—for example, (EMP-EMP-STATUS = 'FT').

This example assumes that a table called FILTER with the prefix FLT is set up with two fields. A is an alpha field of length 3 and S is a signed numeric field.

EVAL      E@FLTSTRING    = "((FLT-A = ?) OR (FLT-A = 'A  ') 
                                           AND (FLT-S = ?))"

Method 2: Use the Set Filter Value API Routine

Set a value with U@FLTS<Type> after calling U@FLTCREATE. In this case, the E@FLTSTRING statement includes the "?" parameter marker syntax. For example:

    EVAL      E@FLTSTRING      = "(ARO-TRANS-DATE <= ?)" 
    CALLP     U@FLTCREATE
    EVAL      E@LFTVDATETIME   = F1@SLTDTT
    CALLP     U@FLTSDATETIME