docs.intersystems.com
MultiValue Quick Start Tutorial
Executing Queries
[Home] [Back] [Next]
InterSystems: The power behind what matters   
Search:    

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.


Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA