Help with global mapping with two namespaces with a static subscript

@John Bradshaw Converted from comment to a separate question, please update the zversion which you using 

 TEXT: %0KmBx2 s 1=$O(^|%objcsd(%qHandle,5)|CB(1,1))

this cannot be right. the solution to the $O is always a variable starting and ending with (null-"")

your comment was:

If I make that "1" a variable (and set it to {L2}) and set an invalid condition {L2}'=1 then I do get this table to compile and work but I don't think that should be necessary.

also the $O() terminates with null so {L2}'=1 looks wrong ie {L2}'=""

the ref; <Invalidcondition name=..L2

this does say NAME ie a variable

I do not do mapping, but your definitions appear to break the rules

The attached class should provide what you are looking for based on my testing.  This follows work I did while at a prior position.

Some things to note about this class

• I'm declaring SqlRowIdName = Id so that I don't end up with an Id1 column in the SQL view of the table
• I've set Parameter STORAGEDELIMITERCHECK = 1; so that when an Save/Insert/Update is done it ensures that the data fields do not contain a delimiter and then "throw off" the piecing strategy, if you aren using delimited data but instead using $list data then you wouldn't need this.
• I've overridden %OnNew so as to establish an array of namespaces where the data lives
• You would also want to call SetServerInitCode in %SYSTEM.SQL or the corresponding SetOption in %SYSTEM.SQL.Util  so as to build up the namespaces array.
• My usage of the namespaces array is for demonstration purposes only, your application probably already has some array that defines where the CB global is defined.
• If you want to only provide read access thru objects and SQL you could set the class Parameter READONLY=1;

seems like uploading a file doesn't work.. here's the class definition .. this will work on Cache or IRIS although on a Cache based system you would have to change <Type>%Storage.SQL</Type> to the proper Cache type.

Class Mapping.Test1 Extends%Persistent [ SqlRowIdName = Id, StorageStrategy = SQLStorage ]
{

/// NamespaceProperty NS As%String [ Required ];/// Contact Row IDProperty RowID As%Library.String(SELECTIVITY = 1, TRUNCATE = 1) [ Required ];Property Field1 As%String;Property Field2 As%String;

Index RowIDBasedIDKeyIndex On (NS, RowID) [ IdKey ];/// <Example>/// Set tSC=##class(Mappting.Test1).Populate()/// </example>ClassMethod Populate() As%Status
{
    #dim tSC 			As%Status=$$$OK#dim eException  	As%Exception.AbstractExceptiontry {
        Set tObject=..%New()
        Set tObject.NS="LAB"Set tObject.RowID=1$$$THROWONERROR(tSC,tObject.%Save())
        Write !,tObject.NS,": ",tObject.RowID
        
        Set tObject=..%New()
        Set tObject.NS="ARK"Set tObject.RowID=1$$$THROWONERROR(tSC,tObject.%Save())
        Write !,tObject.NS,": ",tObject.RowID
        
        &SQL(insertinto Mapping.Test1 (NS,Rowid) values ('LAB',2))
        If SQLCODE $$$ThrowStatus(##class(%Exception.SQL).CreateFromSQLCODE(SQLCODE,%msg))
        
    }
    catch eException {
        Set tSC=eException.AsStatus()
    }
    Quit tSC
}

Storage SQLStorage
{
<SQLMap name="Map1">
<Data name="Field1">
<Delimiter>"^"</Delimiter>
<Piece>1</Piece>
</Data>
<Data name="Field2">
<Delimiter>"^"</Delimiter>
<Piece>2</Piece>
</Data>
<Global>namespaces</Global>
<Subscript name="1">
<Expression>{NS}</Expression>
</Subscript>
<Subscript name="2">
<Expression>1</Expression>
</Subscript>
<Subscript name="3">
<DataAccess>^[{L1}]CB({L2})</DataAccess>
<Expression>{RowID}</Expression>
</Subscript>
<Type>data</Type>
</SQLMap>
<StreamLocation>^Mappting.Test1S</StreamLocation>
<Type>%Storage.SQL</Type>
}

/// This callback method is invoked by the <METHOD>%New</METHOD> method to /// provide notification that a new instance of an object is being created./// /// <P>If this method returns an error then the object will not be created./// <p>It is passed the arguments provided in the %New call./// When customizing this method, override the arguments with whatever variables and types you expect to receive from %New()./// For example, if you're going to call %New, passing 2 arguments, %OnNew's signature could be:/// <p>Method %OnNew(dob as %Date = "", name as %Name = "") as %Status/// If instead of returning a %Status code this returns an oref and this oref is a subclass of the current/// class then this oref will be the one returned to the caller of %New method.
Method %OnNew() As%Status [ Private, PublicList = namespaces, ServerOnly = 1 ]
{
    
    #dim tSC		As%Status=$$$OK#dim eException	As%Exception.AbstractExceptionTry {
        Set namespaces("LAB")=""Set namespaces("ARK")=""
    }
    Catch eException {
        Set tSC=eException.AsStatus()
    }
    Quit tSC
}

Parameter STORAGEDELIMITERCHECK = 1;

}