Archive for Month: August 2013
Caché Monitor automatically downloads the required InterSystems Caché database driver
No manual intervention is required to use a Driver for InterSystems Caché. The driver is automatically downloaded from the web. Just select the driver for a Server. On the first connection the driver download starts, after the download is finished the connection is established. Select the driver and go: If […]
Caché Globals
Caché’s multidimensional arrays are called globals. Data can be stored in a global with any number of subscripts. What’s more, subscripts are typeless and can hold any sort of data. One subscript might be an integer, such as 34, while another could be a meaningful name, like “LineItems” – even […]
New features in Caché Monitor
Caché Monitor 2.03 (What is new in this release?) Main enhancements since last version are: Caché Server passwords are encrypted The password from a registered Server is now automatically encrypted. This is done by changing a property at the registered server or by adding a new server. It is also possible […]
Bitmap Index
Bitmap indexes consist of a bitmap (bit vector) for each distinct column value. Each bitmap has one bit for every row in the table. The bit is on if the related row has the value represented by the bitmap. The advantage of bit map indexes is that complex queries can […]
Support
If you have any questions or problems, please send a email to: support@cachemonitor.de
Use it for free!
Caché Monitor Home Edition is free of charge!
Combine tables across namespaces in a SQL Query – Part 2
The function in Caché Monitor is called “Create mapped table”. Create a new Namespace with a databaseTo try this feature it is recommended to create a new empty Namespace (and database for this namespace), e.g. called “CM_FEDERATED” as the federated namespace. All tables you want to JOIN in a query must […]