ПримерClass my.b Extends %Persistent [ SqlRowIdPrivate, StorageStrategy = sql ]
{

Index idx On ID [ IdKey, PrimaryKey ];

Index idxMy On (Field1, Field2);

Property ID As %Integer;

Property Field1 As %String;

Property Field2 As %String;

/// d ##class(my.b).Fill()
ClassMethod Fill()
{
  k ^my.bD,^my.bI
  
  &sql(insert into my.b(ID,Field1,Field2) values(1,'a','b'))
  &sql(insert into my.b(ID,Field1,Field2) values(2,'c','c'))
  &sql(insert into my.b(ID,Field1,Field2) values(3,'c','d'))
  
  zw ^my.bD,^my.bI
}

Storage sql
{
<SQLMap name="data">
<Data name="Field1">
<Piece>1</Piece>
</Data>
<Data name="Field2">
<Piece>2</Piece>
</Data>
<Global>^my.bD</Global>
<RowIdSpec name="1">
<Expression>{L1}</Expression>
<Field>ID</Field>
</RowIdSpec>
<Subscript name="1">
<AccessType>Sub</AccessType>
<Expression>{ID}</Expression>
</Subscript>
<Type>data</Type>
</SQLMap>
<SQLMap name="index">
<Condition>{Field1}'={Field2}</Condition>
<Global>^my.bI</Global>
<PopulationType>conditional</PopulationType>
<RowIdSpec name="1">
<Expression>{L3}</Expression>
<Field>ID</Field>
</RowIdSpec>
<Subscript name="1">
<Expression>{Field1}</Expression>
</Subscript>
<Subscript name="2">
<Expression>{Field2}</Expression>
</Subscript>
<Subscript name="3">
<Expression>{ID}</Expression>
</Subscript>
<Type>index</Type>
</SQLMap>
<StreamLocation>^my.bS</StreamLocation>
<Type>%CacheSQLStorage</Type>
}

}