Mapping Globals To Classes - Variable Number of Subscripts
I am trying to create an ODBC class that includes all of these as records, but I don't see how I can since the first record has 3 subscripts, the rest have 4 subscripts:
Here is my current storage definition:
<ExtentSize>100000</ExtentSize>
<SequenceNumber>25</SequenceNumber>
<SQLMap name="Test">
<Data name="ModificationDate">
<RetrievalCode> set {ModificationDate}={L4}</RetrievalCode>
</Data>
<Data name="Operator">
<Delimiter>":","|"</Delimiter>
<Piece>36,2</Piece>
</Data>
<Data name="CreationDate">
<Delimiter>":",","</Delimiter>
<Piece>24,1</Piece>
</Data>
<Data name="CreationTime">
<Delimiter>":",","</Delimiter>
<Piece>24,2</Piece>
</Data>
<Data name="TestField">
<Delimiter>":"</Delimiter>
<Piece>16</Piece>
</Data>
<Global>^DMHIS</Global>
<Subscript name="1">
<Expression>{Account}</Expression>
</Subscript>
<Subscript name="2">
<Expression>{PGC}</Expression>
<Invalidcondition name="1">
<Expression>{L2}'="P"</Expression>
</Invalidcondition>
</Subscript>
<Subscript name="3">
<Expression>{Entity}</Expression>
</Subscript>
<Subscript name="4">
<Expression>{DateTime}</Expression>
</Subscript>
<Type>data</Type>
</SQLMap>
<StreamLocation>^Test</StreamLocation>
<Type>%CacheSQLStorage</Type>
</Storage>