looks more like JSON than XML
You may try to apply $ZSTRIP(yourSegment,"*C") to remove all non-ASCII characters.Or just trailing $ZSTRIP(yourSegment,">C")
That looks good.But I can not use the index in SQL
. . . WHERE FOR SOME %ELEMENTS(Sample.Person1.AR) (%value......) works as expected.Buthow can I force the new index ?
. . . WHERE FOR SOME %ELEMENTS(Sample.Person1.AR.State) is not accepted. . . WHERE FOR SOME %ELEMENTS(Sample.Person1.AR_State) is not accepted.... ??? what else ??
Log in or create a new account to continue