Elardus Engelbrecht wrote: >So, after reading the replies to you, it seemed to me you need to sort >according to first item_nbr and then location. >After that, you select the FIRST of these numbers. After that you only select >those with CORPORATIVO. >Or reject any/all duplicates of item_nbr and then only subselect location >after that rejection.
>Other than that, I don't think there is an easy way to select more than one >records based on two different unrelated selections, unless Sri h Kolusu has a >magic wand for this one too. I am wondering/believing that JOINKEYS could do all of this in one single swoop... I like solutions where you can parse input in one single step and be finished. You can probably use REXX, but REXX is heavy on resources, while DFSORT and ICETOOL have their own magic handling of resources. Now, waiting for Sri ... ;-) Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
