Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?

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.
Feedback