15 + years Solutions-oriented Integration Interface Specialist with notable success directing a broad range of corporate IT initiatives while participating in planning and implementation of Integrated solutions in direct support of business objectives. Specialties: Design/Development of MS and Oracle SQL Databases, HL7 Ancillary Solutions, and Intersystem Ensemble Solutions. Integrating it all together to create a more robust environment.
While working with Intersystems Ensemble and now IRIS, I have greatly expanded my knowledge of Ensemble and Cache Object Script by asking questions and watching the Developer Community. I tend to ask questions, then figure out the answers on my own or with a little help from others.
Before Intersystems Ensemble, I spent many years as an eGate developer. Specializing in DART, JDBC, and other out of the normal odds and ends.
The Class name is osuwmc.Epic.Clarity.DepartmentMaster and it is storing data in
- Data - ^E2C8.D9IS.1
- BitmapExtent Index - ^E2C8.D9IS.2
- IDIndex Index - ^E2C8.D9IS.3
- IDKey Index - ^E2C8.D9IS.1
- Indexes - ^E2C8.D9IS.I
- Stream - ^E2C8.D9IS.S
I am not sure what to put in as the Global Name, would that be E2C8? and then the subscript to be mapped would be D9IS.*?
I am also trying to map a Database table from one namespace to another. When I enter the following into the %ALL namespace as the global map, when I select from that table in the second namespace I get no results.










I was able to get it to work. I found that in Cache I need to call %Get("<column>") name vs what I am doing in a BPL.
s Loc = "" s tStatement = ##class(%SQL.Statement).%New() s execall= "CALL osuwmc_Utils_EnterpriseDirDb.InterfaceCheckConnectMedCtrID(?)" s qStatus = tStatement.%Prepare(execall) if $$$ISERR(qStatus) {write "%Prepare failed:" do $SYSTEM.Status.DisplayError(qStatus) quit} set rset = tStatement.%Execute(pInput) while rset.%Next() { set Loc = rset.%Get("OSUguestRoleDTL") } if $Length(Loc) = 0 { set Loc = "OSUWMC" }