>From the dictionary listing, looks like you are on universe (as opposed to >unidata. Useful information to have, along with the flavor you're using. To >find the flavor, use:
.L RELLEVEL RELLEVEL 001 X 002 10.3.7 003 PICK 004 PICK.FORMAT 005 10.3.7 which in my example show I am in pick flavor). try: SELECT CREDITCARD.FILE BY-EXP PMT.DATE EQ "11/19/2013" LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE On Nov 19, 2013, at 11:28 AM, Hilk, Brandon <[email protected]> wrote: > 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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
