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.