Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread Ed Clark
>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  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..
> 
> 
> 
> 5215216252152162 APPROVED25D6TGCD 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
> 
> 5643649556436495 APPROVED259l17j2 02/18/2013
> 
>56436495 APPROVED25a0hfg7 03/18/2013
> 
>56436495 APPROVED25adf4bt 04/18/2013
> 
>56436495 APPROVED25ar1ofv 05/20/2013
> 
>56436495 APPROVED25b7a92o 06/18/2013
> 
>56436495 APPROVED25bk0tpv 07/18/2013
> 
>56436495 APPROVED25c11rl1 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


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread George Gallen

If someone who has rights to be able to change them needs to add
"link1"  (example-but it can be used) into field 7 of the following DICT 
ITEMS

PACKET STATUS TRACKING.ID and PMT.DATE

That will link these fields together so next time you can do:

SELECT CREDITCARD.FILE WITH PMT.DATE = "11/19/2013"
LIST CREDITCARD.FILE WHEN PMT.DATE = "11/19/2013" PACKET STATUS TRACKING.ID 
PMT.DATE


George

-Original Message- 
From: Hilk, Brandon

Sent: Tuesday, November 19, 2013 1:31 PM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records

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

@IDD0CREDITCARD.FILE 10L
S
PACKET D2PACKET  8R
M
STATUS D   10STATUS  15L
M
TRACKING.IDD9TRACKING ID 20L
M
PMT.DATE   D7   D4/  PMT DATE10R
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 
To: U2 Users List 
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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

   56436495 APPROVED25a0hfg7 03/18/2013

   56436495 APPROVED25adf4bt 04/18/2013

   56436495 APPROVED25ar1ofv 05/20/2013

   56436495 APPROVED25b7a92o 06/18/2013

   56436495 APPROVED25bk0tpv 07/18/2013

   56436495 APPROVED25c11rl1 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 


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread Bill Haskett

Brandon:

Is this UV or UD?  There's a bit of a difference setting up the query 
language to use the "WHEN" clause within these two different U2 dbms 
products.  The task of setting up the query is to set up fields as 
multi-value first, then associating multi-valued field definitions into 
a group.


Bill
Untitled Page



- Original Message -
*From:* brandon.h...@iqor.com
*To:* U2 Users List 
*Date:* 11/19/2013 10:31 AM
*Subject:* Re: [U2] Simple question - selecting and listing records

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

@IDD0CREDITCARD.FILE 10L
S
PACKET D2PACKET  8R
M
STATUS D   10STATUS  15L
M
TRACKING.IDD9TRACKING ID 20L
M
PMT.DATE   D7   D4/  PMT DATE10R
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 
To: U2 Users List 
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..

 


5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

 56436495 APPROVED25a0hfg7 03/18/2013

 56436495 APPROVED25adf4bt 04/18/2013

 56436495 APPROVED25ar1ofv 05/20/2013

 56436495 APPROVED25b7a92o 06/18/2013

 56436495 APPROVED25bk0tpv 07/18/2013

 56436495 APPROVED25c11rl1 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


___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread Hilk, Brandon
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

@IDD0CREDITCARD.FILE 10L
S   
PACKET D2PACKET  8R
M   
STATUS D   10STATUS  15L
M   
TRACKING.IDD9TRACKING ID 20L
M   
PMT.DATE   D7   D4/  PMT DATE10R
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 
To: U2 Users List 
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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 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


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread Wjhonson
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 
To: U2 Users List 
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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 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


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread George Gallen
OOPS, meant field 7, not field 6.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, November 19, 2013 11:35 AM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records

I'm assuming you have multiple fields which are tied together that are all 
multivalued?
If so, make sure you field 6 in the dict all have the same linkcode otherwise 
WHEN
Will not be to pull the associated fields.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 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


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread George Gallen
I'm assuming you have multiple fields which are tied together that are all 
multivalued?
If so, make sure you field 6 in the dict all have the same linkcode otherwise 
WHEN
Will not be to pull the associated fields.

George

-Original Message-
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 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


Re: [U2] Simple question - selecting and listing records

2013-11-19 Thread Dave Davis
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: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] 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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 08/19/2013



___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users



Dave Davis
Team Lead, Research & Development

P: 614-875-4910 x108
F: 614-875-4088
E: dda...@harriscomputer.com
[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
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


[U2] Simple question - selecting and listing records

2013-11-19 Thread Hilk, Brandon
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..



5215216252152162 APPROVED25D6TGCD 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

5643649556436495 APPROVED259l17j2 02/18/2013

56436495 APPROVED25a0hfg7 03/18/2013

56436495 APPROVED25adf4bt 04/18/2013

56436495 APPROVED25ar1ofv 05/20/2013

56436495 APPROVED25b7a92o 06/18/2013

56436495 APPROVED25bk0tpv 07/18/2013

56436495 APPROVED25c11rl1 08/19/2013

 

___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users