It seems like any classes defined in %SYS would also returned by this method.

Any way to filter them out? Thanks.

I want to evaluate the performances of different query plans.

I dont really need TuneTable since I don't really care the statistics is correct or not.

I just have to evaluate impact of those different parameters feed into optimizer.

Below is my sample test program and it should reveal my intention.  It seems like BlockCount is not fetching the newest value from ^Blk when I compile. Any solution for this ?

<SQLMap name="Index">
<BlockCount> ^Blk</BlockCount>
</SQLMap>

set Blks = $lb(-100,-200,-300)

for r = 1:1:$ll(Blks){
set ^Blk = $li(Blks,r)

do $system.SQL.Purge()
w !,$system.OBJ.Compile("User.Table")
set query = "select XXXX"
set stat = ##class(%SQL.Statement).%New()
if 'stat.%Prepare(query) w !,"prepare failed "_query
set startT = $zts
set r = stat.%Execute()
set endT = $zts

//record startT and endT

}

Never mind, it works now. Thanks you.

I did, but it still remain the same.

Is this field of SMP corresponding to the global buffer [Memory Allocated for 8KB Database Cache (MB)] ?

I would like to 10G memory to global buffer, is there any constraint about the upper limit ?

BTW, what if i would like to compare SSN with aaa'aa (ie: single  quote is also the content  I would like to compare.) ?

Thanks.

if  "ReturnResultsets" specified in the SqlProc definittion, 

could I just directly use "call SqlProcName" instead of "? = call SlqProcName" ?

 

I try triple single quote in $system.SQL.Shell(), but it still does not work.

ERROR #5540: SQLCODE: -1 Message:  ) expected, ? found^ Call USER. SP ( ? ? [Generate+1247^%SYS.DynamicStatement:SAMPLES]

The double single quote does not work.

THanks.

Thank, it seems to work. I have a follow-up question.

Not only instance B, I also configure instance C as ECP data server and I also expose one database on instance C as a remote 

database on instance A. Is it possible that I could map both exposed databases on instance B and instance C to the same namespace on instance A ?

Thanks.

Hi Laura,

Thanks for your response, but this is not what I want.
Since when COS fail, some error messages would also get returned and I need to how to access these messages from Java side.