Inherited description: The EXTENTQUERYSPEC parameter defines the properties to be retrieved in
addition to the IDKEY value for the built-in Extent query.
Persistent classes should define a value of for EXTENTQUERYSPEC if they
wish to include additional properties in their built-in Extent query.
property FavoriteColors as list of %String (JAVATYPE = "java.util.List", POPSPEC = "ValueList("",Red,Orange,Yellow,Green,Blue,Purple,Black,White""):2");
A collection of strings representing the person's favorite colors.
Prints out data on all persons within the database using SQL to
iterate over all the person data.
classmethod StoredProcTest(name As %String, ByRef response As %String) as %Integer [ SQLProc = Stored_Procedure_Test ]
Projected as the stored procedure: Stored_Procedure_Test
This is a sample of how to define an SQL stored procedure using a
class method. This method can be called as a stored procedure via
ODBC or JDBC.
In this case this method returns the concatenation of a string value.
classmethod UpdateProcTest(zip As %String, city As %String, state As %String) as %Integer [ SQLProc = Person_UpdateProcTest ]
Projected as the stored procedure: Person_UpdateProcTest
This is a sample of how to define an SQL stored procedure using a
class method. This method can be called as a stored procedure via
ODBC or JDBC.
This method performs an SQL update operation on the database
using embedded SQL. The update modifies the embedded properties
Home.City and Home.State for all rows whose
Home.Zip is equal to zip.
SQL Query: SELECT ID, Name, DOB, SSN
FROM Sample.Person
WHERE (Name %STARTSWITH :name)
ORDER BY Name
A sample class query that defines a result set that returns Person data
ordered by Name.
This query can be used within another Caché method (using the
%ResultSet class), from Java, or from ActiveX.
This query is also accessible from ODBC and/or JDBC as the SQL stored procedure
SP_Sample_By_Name.
Indexes
index ($Person on ) [Extent, Type = bitmap];
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()