Problem:

Receiving a -170 syntax error on SELECT statement containing a WHERE clause.

The WHERE clause contains a host variable declared as a group item.

Resolution:

Although you can use groups of data items as a single host variable in embedded SQL, group items are not permitted in the WHERE clause.