To create a persistent class and its corresponding SQL table, you can do any of the following:
-
Use your IDE to define a class based on %PersistentOpens in a new tab. When you compile the class, the system creates the table.
-
In the Management Portal, you can use the Data Migration Wizard, which reads an external table, prompts you for some details, generates a class based on %PersistentOpens in a new tab, and then loads records into the corresponding SQL table.
You can run the wizard again later to load more records, without redefining the class.
-
In the Management Portal, you can use the Link Table Wizard, which reads an external table, prompts you for some details, and generates a class that is linked to the external table. The class retrieves data at runtime from the external table.
-
In InterSystems SQL, use CREATE TABLE or other DDL statements. This also creates a class.
-
In the Terminal (or in code), use the CSVTOCLASS() method of %SQL.Util.ProceduresOpens in a new tab. For details, see the Class Reference for %SQL.Util.ProceduresOpens in a new tab.