Question Jorge de la Garza · Jan 9, 2020 Provide FROM table name to query as a parameter I have an array of table names that I want to iterate over and for each table, get the number of rows. I was hoping I could do something like: #ObjectScript #SQL #InterSystems IRIS 0 2 0 576
Question Jorge de la Garza · Mar 10, 2017 Process private global versus percent variable What are the differences between a process private global and a percent variable? Basically I have some code running in an Ensemble operation that processes requests, and it needs access to pieces of data that are scattered throughout XData blocks in various classes. Rather than opening the XData object and deserializing the XML on each request, I opted to cache this data in a percent variable, something like:set %MyVar(sub1,sub2) = myValue #Caché #ObjectScript 0 10 0 1.8K