Like in host variable in DB2 Query

[malifiecient]

I am writing a cursor and in where condition I am using like variable
for e.g
CUST-ID LIKE (:WS-CUST-ID)


in WS-CUST-ID, I wam paasing value ABC%,while fethcing records from cursor, I am getting SQLCODE= 100.

simply checking the query in the DB2 table, records are getting selected.