Adding Lawson Table Process?

Ron, what code do you have prior to PERFORM 850-FILTER-BEGRNG-PRDSET2 ??

It should look something like this:
MOVE xxx TO DB-COMPANY.
MOVE xxx TO DB-EMPLOYEE.
MOVE PRDSET2-EMPLOYEE TO WS-DB-BEG-RNG.

Also please post the code you are using to create the filter.

Here is the actual code including the PERFORM:

     MOVE PRM-COMPANY            TO DB-COMPANY.
      MOVE SPACES                 TO FILTER-STRING.
      MOVE WS-PRD-FILTER          TO FILTER-STRING.
      PERFORM 890-CREATE-FILTER.
      MOVE PRM-FROM-DATE          TO FILTER-STRING.
     PERFORM 890-SET-DATETIME-FILTER-VALUE.
     MOVE PRM-FROM-DATE          TO FILTER-STRING.
      PERFORM 890-SET-DATETIME-FILTER-VALUE.
      MOVE "0"                     TO FILTER-STRING.
      PERFORM 890-SET-ALPHANUM-FILTER-VALUE.

      MOVE PRDSET2-COMPANY        TO WS-DB-BEG-RNG.
     PERFORM 850-FILTER-BEGRNG-PRDSET2.

Below is the Filter definition in Working Storage:
     02  WS-PRD-FILTER-GROUP.
         03  FILLER              PIC X(23) VALUE
                               "((PRD-GL-DATE < ?) AND ".
         03  FILLER              PIC X(23) VALUE
                               "(PRD-RUN-DATE < ?) AND ".
         03  FILLER              PIC X(19) VALUE
                               "(PRD-CHECK-ID > ?))".
     02  FILLER REDEFINES WS-PRD-FILTER-GROUP.
         03  WS-PRD-FILTER       PIC X(65).

This should equate to the SQL statement:
SELECT * FROM PRDISTRIB
WHERE PRM-COMPANY = COMPANY
AND GL_DATE < PRM-FROM-DATE
AND RUN_DATE< PRM-FROM-DATE
AND CHECK_ID > 0   (zero)

You kept overwriting FILTER-STRING with the values that you want inserted into the string.
Also changed the check-id to a numeric...

See if this works...

MOVE WS-PRD-FILTER TO FILTER-STRING.
PERFORM 890-CREATE-FILTER.

MOVE PRM-FROM-DATE TO DATETIME-FILTER-VALUE.
PERFORM 890-SET-DATETIME-FILTER-VALUE.

MOVE PRM-FROM-DATE TO DATETIME-FILTER-VALUE.
PERFORM 890-SET-DATETIME-FILTER-VALUE.

MOVE 0 TO NUMERIC-FILTER-VALUE.
PERFORM 890-SET-NUMERIC-FILTER-VALUE.

MOVE PRM-COMPANY TO DB-COMPANY.
MOVE PRDSET2-COMPANY TO WS-DB-BEG-RNG.
PERFORM 850-FILTER-BEGRNG-PRDSET2.

THANK YOU, THANK YOU.  Can't believe I have been looking at that code for so long and missed that.  That solved the connection problem. Thanks again!!!