CPYF ... INCREL issues

Hi list:

We are in V5R4 and I do not know what I am doing wrong with the CPYF
command.

Background:
a) I have a work file called I700W1
b) I have a master file called ITEMBL
c) I have item number "21737" and warehouse id "N1"
d) I want to copy the record information for this items from the ITEMBL
file into the I700W1 work file.
e) In both files, the item number field (ITNBR) and the warehouse id
(HOUSE) have the same field names.

Based on the previous scenario, my CPYF command looks like this:
CPYF FROMFILE(*LIBL/ITEMBL) TOFILE(*LIBL/I700W1) MBROPT(*REPLACE)
INCREL((*IF ITNBR *EQ &P1ITNBR) (*AND HOUSE *EQ &P1WHID)) FMTOPT(*MAP
*DROP)

The result of this command is bringing multiple items, all starting with
"21737" that exist on the warehouse "N1":
21737
217371
217371T
217372
217372T
217373
217374
217375

Even if I change the CPYF command to do this:
CPYF FROMFILE(*LIBL/ITEMBL) TOFILE(*LIBL/I700W1) MBROPT(*REPLACE)
INCREL((*IF ITNBR *GE &P1ITNBR) (*AND ITNBR *LE &P1ITNBR)
(*AND HOUSE *GE &P1WHID) (*AND HOUSE *LE &P1WHID))FMTOPT(*MAP *DROP)

I do not have different results. Any ideas?

TIA,


PETER VIDAL
PALL CORPORATION
SR System Analyst | WH Application Development
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
UC#: 262-2414 | Direct: 727-844-2414 | Fax: 727-815-3120 | www.pall.com

"Think like a wise man but communicate in the language of the people."
William Butler Yeats (1865 - 1939)

--------------------------------------------------------------------------------

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.


--------------------------------------------------------------------------------