If this is unidata ECLTYPE "U": LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE WHEN ASD(PMT.DATE EQ "11/19/2013")
You may want to try lowercase "list" if your default ECLTYPE is "P" to force it to use the "U" parser. And your CREDITCARD.FILE dictionary should have PACKET STATUS TRACKING.ID PMT.DATE belonging to the same association. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Hilk, Brandon Sent: Tuesday, November 19, 2013 11:29 AM To: U2 Users List Subject: [U2] Simple question - selecting and listing records Hello, I have a quick question regarding listing multivalued fields. I hope the formatting is retained on this email so my example doesn't get confusing. This file is structured for multiple credit card entries under one @id. How can I alter my LIST command to only show the entries for the date specified? I tried using "when" in both the LIST and SELECT statements but didn't get the results I was looking for. I feel like I'm missing something really basic. Thanks in advance. }SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013" 303 record(s) selected to SELECT list #0. }}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE CREDITCARD.FILE PACKET.. STATUS......... TRACKING ID......... PMT DATE.. 52152162 52152162 APPROVED 25D6TGCD 11/19/2013 52152162 12/31/2013 52152162 01/31/2014 52152162 02/28/2014 52152162 03/31/2014 52152162 04/30/2014 52152162 05/30/2014 52152162 06/30/2014 52152162 07/31/2014 52152162 08/29/2014 52152162 09/30/2014 52152162 10/31/2014 56436495 56436495 APPROVED 259l17j2 02/18/2013 56436495 APPROVED 25a0hfg7 03/18/2013 56436495 APPROVED 25adf4bt 04/18/2013 56436495 APPROVED 25ar1ofv 05/20/2013 56436495 APPROVED 25b7a92o 06/18/2013 56436495 APPROVED 25bk0tpv 07/18/2013 56436495 APPROVED 25c11rl1 08/19/2013 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ________________________________ Dave Davis Team Lead, Research & Development P: 614-875-4910 x108 F: 614-875-4088 E: [email protected] [http://www.harriscomputer.com/images/signatures/HarrisSchools.jpg] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif]<http://www.harriscomputer.com/> 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com<http://www.harris-schoolsolutions.com> This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
