Re: CPYF ... INCREL issues

Ok, this is what worked for me:

Used OPNQRYF and CPYFRMQRYF and like Chuck basically mentioned before, this
is one of CPYF's weird features. Looks like the system examines the fourth
argument in the INCREL parameter to see how many characters are left after
stripping out trailing blanks. In my scenario, &P1ITNBR contains 5
non-blank characters followed by 10 blanks, so CPYF looks at the first 5
characters of ITNBR and nothing else.

On the other side, if we use Open Query File (OPNQRYF) and Copy from Query
File (CPYFRMQRYF) commands instead, I will have what I need because OPNQRYF
selects records with an exact match and doesn't ignore trailing blanks. As
a result, I ended up doing something like this:

OPNQRYF FILE((*LIBL/ITEMBL *FIRST *ONLY))
QRYSLT('ITNBR *EQ ''' *CAT &P1ITNBR *CAT ''' & +
HOUSE *EQ ''' *CAT &P1WHID *CAT '''')

CPYFRMQRYF FROMOPNID(ITEMBL) TOFILE(QTEMP/ITEMBL_LT) CRTFILE(*YES)

It works like a charm!

Thank you all for you valuable feedback and have an awesome day everybody!

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.


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