Filter examples more than one data element

Example: Filter by range

The following example reproduces the query created using filter by list value for NAME and SURNAME, where the values are:

ALBERT,TOM and STEPHEN for NAME
LENNON, ROSS and MORANIS for SURNAME

SELECT * FROM "DELGT"."CUSTOMER" A, OWUR41SV.HSENVPAR B WHERE B.METHOD = 'DOUBCOND3 ' AND B.MCRECID = 0028 AND B.CLATYPE = 0202 AND B.FLTPRG = 0001 AND A."NAME" = ( ( SUBSTR(B.VALUE, 001, 040) ) ) AND A."SURNAME" = ( ( SUBSTR(B.VALUE, 041, 040) ) ) AND B.PARMPRG > 2

Example: Filter by list value

The following example reproduces the query created using filter by list value for NAME and SURNAME, where the values are:

ALBERT,TOM and STEPHEN for NAME
LENNON, ROSS and MORANIS for SURNAME

SELECT * FROM "DELGT"."CUSTOMER" A, OWUR41SV.HSENVPAR B WHERE B.METHOD = 'DOUBCOND3 ' AND B.MCRECID = 0028 AND B.CLATYPE = 0202 AND B.FLTPRG = 0001 AND A."NAME" = ( ( SUBSTR(B.VALUE, 001, 040) ) ) AND A."SURNAME" = ( ( SUBSTR(B.VALUE, 041, 040) ) ) AND B.PARMPRG > 2

Example: Filter by filter list

. The following example reproduces the query created using filter by filtered where class NAME and class SURNAME have been previously created like output class for another entry within the same method:

SELECT * FROM "DELGT"."CUSTOMER" A, OWUR41SV.ANENVLST B WHERE B.METHOD = 'DOUBCOND5 ' AND B.MCRECID = 0028 AND B.CLATYPE = 0202 AND B.FLTPRG = 0001 AND A."NAME" = ( ( SUBSTR(B.VALUE, 001, 040) ) ) AND A."SURNAME" = ( ( SUBSTR(B.VALUE, 041, 040) ) )