|
I must be having a senior moment here. On a V5R2 machine, I just ran a CPYF command where I substituted a variable in a CL program. The shortened version of the statement was this: crtfile(*no) increl((*if ptcmpy *eq &coa) + (*and ptloc *eq &loc) (*and ptpart *eq + &part)) fmtopt(*map *drop) In this example, ptloc is a 6 character field. The variable I entered were the 4 characters 0893. I was expecting to retrieve 1 record based on the combination of the ptcmpy, ptloc and ptpart fields. What I got was 7 records because the same part number exists 7 times for the company I requested. The location field in these 7 records looks like this: 0893 089303 089304 089311 089312 089323 089333 Why did CPYF pick up all 7 records? When I ran the command from a command line, and I typed 0893 as the value of the location. I got all 7 records. When I made the value '0893 ' it worked fine. I need this to have an absolute value, not a "looks like". Paul Nelson Arbor Solutions, Inc. 708-670-6978 Cell pnelson@xxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.