Skip to main content


Now that we have created our Contact class, we can populate it with test data using the Caché auto-population tools. These are available to us because Contact extends %PopulateOpens in a new tab.

Invoke the populate utility from the Terminal. Here are the steps:

  1. Launch the Terminal. Do this by clicking the InterSystems Launcher (Caché cube generated description: cube, Ensemble icon generated description: ensemble icon 20112, or HealthShare icon, depending on your system) in your system tray and then clicking Terminal on the launch menu.

    generated description: cubemenu terminal 20112

  2. If the terminal is not pointing at the USER namespace, use the ZN command to switch to USER.

  3. Populate the namespace with ten Contact instances using the following command:

    USER>Do ##class(ContactDB.Contact).Populate(10)

Here are the steps displayed in the Terminal:

generated description: terminalswitchnamespace 20112

We can also launch an SQL shell from within terminal to view the newly created data. Here are the steps:

  1. Execute the following command to launch the shell:

    USER>Do $SYSTEM.SQL.Shell()
  2. Next, enter an SQL query:

    USER>>SELECT NAME FROM ContactDB.Contact WHERE Type='Personal'

Here are the steps displayed in the Terminal:

generated description: terminalsqlshell 20112


To learn more about the Caché auto-population tools, read The Caché Populate Utility in Using Caché Objects.

FeedbackOpens in a new tab