Skip to main content


Use the PROTOCLASS utility to create a Caché class definition based on MultiValue dictionary definitions. Dictionary items become properties in the class. After creating the class definition, you have both SQL and Object access to your data:

Object Access:

  1. Server access through Caché object syntax: MVBasic, ObjectScript, and Caché Basic.

  2. Client access through projections: Java, .NET, C++, Perl, Python, and others.

SQL Access:

  1. Server access through Caché SQL: Embedded SQL, Dynamic SQL.

  2. Client access through JDBC and ODBC: standard tools, applications.

Note that PROTOCLASS is an MVBasic routine. A standard Caché installation includes the source code for PROTOCLASS in <cachesys>\Dev\mv\samples. The code is fully customizable and contains extensive documentation describing how to customize it.


The name PROTOCLASS is meant to emphasize that typically the resulting class definition is a prototype or starting point. Frequently, you will have to run the utility repeatedly, each time making adjustments to the MV dictionaries, until you get your desired result. In addition, you may have to edit the class definition manually.

In a standard Windows Caché installation, <cachesys> is C:\InterSystems\Cache.

For more detailed information on PROTOCLASS, see Using PROTOCLASS.

FeedbackOpens in a new tab