Skip to main content

Executing Queries

MyAccount contains some sample data. Once it is loaded we can execute standard MultiValue queries against it.

First, use the LOGTO command to switch to MyAccount:


USER:LOGTO MyAccount
MyAccount:            

Now enter a MultiValue query like the following:


MyAccount:LIST PERSON NAME

Caché displays the following:


LIST PERSON NAME                             11:51:24am  08 Jan 2014  PAGE    1
PERSON....    NAME.....................
 
1             IDLE,JIM
2             SMITH,JANE
3             SMITH,JOHN
4             JONES,JANE
5             DOE,ELIZABETH
 
5 Items listed.         

Try executing another query like the following:


MyAccount:LIST PERSON NAME PHONE ID.SUP        

Caché displays the following:


LIST PERSON NAME PHONE ID.SUP                11:56:26am  08 Jan 2014  PAGE    1
NAME.....................    PHONE.......
 
IDLE,JIM                     555-123-1234
                             555-432-4321
                             666-435-0101
 
SMITH,JANE                   111-222-3333
                             222-333-4444
 
SMITH,JOHN                   111-000-0000
                             111-111-0000
 
JONES,JANE                   222-111-1111
                             222-222-1111
 
DOE,ELIZABETH                222-333-4444
                             333-111-1616
 
 
5 Items listed.
FeedbackOpens in a new tab