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.