Try this: PIPE CP QUERY NAMES | SPLIT AT /,/ | STRIP | SPECS W1 | CONSOLE You'll have a display of all users, each a single "record" that you can also do accurate "FIND"s against. PS: There is no "Q" command, "Q" is an abbreviation for "QUERY". It's good form to always spell out the full command, particularly in production-ready execs. As others have pointed out, QUERY is both a CP and CMS command so directing it to the proper environment is also important to get the right results. :) -Mike
-----Original Message----- From: The IBM z/VM Operating System [mailto:[EMAIL PROTECTED] On Behalf Of Lionel B. Dyck Sent: Friday, July 27, 2007 2:22 PM To: [email protected] Subject: Re: pipe question I like it - this pipe 'thingy' has lots of capability and lots for me to learn. Thanks _____ Lionel B. Dyck, Consultant/Specialist Enterprise Platform Services, Mainframe Engineering KP-IT Enterprise Engineering, Client and Platform Engineering Services (CAPES) 925-926-5332 (8-473-5332) | E-Mail: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] AIM: lbdyck | Yahoo IM: lbdyck Kaiser Service Credo: "Our cause is health. Our passion is service. We're here to make lives better." "Never attribute to malice what can be caused by miscommunication." NOTICE TO RECIPIENT: If you are not the intended recipient of this e-mail, you are prohibited from sharing, copying, or otherwise using or disclosing its contents. If you have received this e-mail in error, please notify the sender immediately by reply e-mail and permanently delete this e-mail and any attachments without reading, forwarding or saving them. Thank you. RPN01 <[EMAIL PROTECTED]> Sent by: The IBM z/VM Operating System <[email protected]> 07/27/2007 11:20 AM Please respond to The IBM z/VM Operating System <[email protected]> To [email protected] cc Subject Re: pipe question Find searches for things at the beginning of a record. Locate searches anywhere within a record. Given that you didn't do a split to put the userids on separate lines, I'd think that "pipe cms q n | locate /ESA/ | console" would work better. Also, q n is a CP command, not a CMS, so actually, you'd want "cp q n" as the first stage, just to avoid someone creating a "q" exec and messing you up. To really get down to the meat of it, you'd want to do something like: "pipe cp q names | split at /,/ | strip leading blank | locate /ESA/ | console" Someone will argue that the strip should be after the locate for efficiency sake, and that would be true for a huge list. For Q N, it shouldn't be an issue. -- .~. Robert P. Nix Mayo Foundation /V\ RO-OE-5-55 200 First Street SW / ( ) \ 507-284-0844 Rochester, MN 55905 ^^-^^ ----- "In theory, theory and practice are the same, but "Join the story... Ride Ural." in practice, theory and practice are different." On 7/27/07 1:11 PM, "Lionel B. Dyck" <[EMAIL PROTECTED]> wrote: I'm learning pipes in cms and am trying to issue a 'q n' command and filter it to only display selected names. I'm trying this with no success - can someone educate me on what I'm doing wrong: pipe cms q n | find ESA | console
