You may be right :) I do no programming with this system, I'm just an end user that's trying to understand better.
Field......... Type & Field........ Conversion.. Column......... Output Depth & Name.......... Field. Definition... Code........ Heading........ Format Assoc.. Number @ID D 0 CREDITCARD.FILE 10L S PACKET D 2 PACKET 8R M STATUS D 10 STATUS 15L M TRACKING.ID D 9 TRACKING ID 20L M PMT.DATE D 7 D4/ PMT DATE 10R M As far as WHEN clause, I tried: list creditcard.file packet status tracking.id pmt.date when pmt.date eq "11/19/2013" and it sorts those dates to be the first results, but it still lists all the other card entries on that packet before moving to the next record. Is this just a consequence of how the creditcard.file is set up? -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, November 19, 2013 12:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple question - selecting and listing records Could you post the exact statement you're using with the WHEN clause, a and also the contents of the DICT items? I suspect one or more of them is not actually setup as a multivalued field -----Original Message----- From: Hilk, Brandon <brandon.h...@iqor.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Tue, Nov 19, 2013 8:29 am 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users