to dismount/mount a database, use Dismount() and Mount() methods in SYS.Database class available in %SYS namespace. NB: the database ID is its Directory
You'll find some examples of how to dismount/mount and check if a database is mounted (Mounted=1) or not (Mounted=0), and quickly see all the attributes of a database (via zwrite)
I was editing the properties of a persistent ObjectScript class the other day and noticed that the storage definition wasn't updating to reflect my latest changes.
In this case, I deleted a property that was no longer needed from the class definition, saved, recompiled, and still saw it in the storage definition.
I want to make the LOCATION for a %Stream.FileCharacterGzip property we have in a class parameterisable (as in stored in a global), so it can be different for different customers. Is that possible? I've tried doing it a few different ways: Creating a parameter Parameter STREAMLOC = {^websystem("auditstream-location")}; then I tried to reference that in the
Property HTMLZIPDoc As %Stream.FileCharacterGzip(LOCATION = ..#STREAMLOC);
Millions of professionals use a wonderful tool, spreadsheets, for engineering calculations and financial analysis. It attracts a user-friendly interface and clear data organization. Cell formulas provide rich opportunities for automating calculations. No programming is required.
I have an auditing class that defines some sqlComputed properties and can be extended by other persistent classes to enable auditing of its properties.
Is there any information regarding using Cache ODBC DSN's to connect to SAP Crystal Server 2020? We have added all the necessary DSN on the server, and yet when running reports to access the required ODBC connections, we cannot seem to get the connections to establish.
I see that a new Apache bug has been discovered, and since various InterSystems products use an Apache webserver, have Intersystems released any news or updates on this? I'm not seeing any updates, press releases from them. Anyone know anything?
Hello everyone I'm newb using COS and I would like to know What is the definition of ROUTINE in COS ? is there anything related to Global? is it all information that it's possible to persist on the database?
I've been accessing Cache tables from a developer/reporting side, but am now involved in a project to create a data warehouse for our application. I'm trying to find a query I can use to return the sizes of all the tables in the database, so we can identify the largest tables and handle those individually. Can someone give me a query I can run against our Cache database to return the sizes of all the tables from largest to smallest?
I need to generate a DDL file from a .cls class that already exists, the idea is to create a mirror table in SQL. Is it possible to do this export or do I need to do the CREATE TABLE manually?
When i use &sql(SELECT ......) in Cache I can watch the generated code In the generated .int code and see what is happening. Just with my normal rights
Now in IRIS I have just 4 line calling some class %sqlcq.*** With enough rights i find there is no such class but the generated .int routine %sqlcq.IRISAPP.xEZgUjdXCCgQdZQPpRdOye1Ci2ue.1 That holds the code that i had in my .int on Cache
I'm in need of a lot of help from you. I work in a company with all system cached script, using global.
I need to develop web applications accessing the cache database, and global.
Could you help me indicate the best language option to develop web applications, and easier to access cache, and if possible send me some examples of applications accessing globals.
Created by Daniel Kutac, Sales Engineer, InterSystems
Warning: if you get confused by URLs used: the original series used screens from machine called dk-gs2016. The new screenshots are taken from a different machine. You can safely treat url WIN-U9J96QBJSAG as if it was dk-gs2016.
Part 2. Authorization server, OpenID Connect server
Is InterSystems ODBC driver backwards compatible? If I use cache version 2018, can I upgrade the ODBC drivers to the 2021 version or it is better to upgrade to the 2018?
I recently needed to interrogate some folders/sub-folders to retrieve filenames using cache object script(COS) and I implemented it in the following way.
I programmed some server command by my own. That server commands worked fine for a long time.
Suddonly I received
Studio Action "Attempted Edit" not supported on 127.0.0.1:57772[CTAE01]
by using one of my server commands.
There is an explanation:
Error running command vscode-objectscript.serverCommands.contextOther: Running the contributed command: 'vscode-objectscript.serverCommands.contextOther' failed.. This is likely caused by the extension that contributes vscode-objectscript.serverCommands.contextOther.
Pouring The Coffee: Creating and scheduling a task
Don't you wish a fresh, hot cup of coffee could be waiting for you right when you get into the office? Let's automate that!
Cache and IRIS come with a built-in Task Manager, which should have a familiar feel to those used to using the Windows task scheduler or using cron on Linux. Your user account will need access to the %Admin_Task resource to use it, and you can access it in the management portal under System Operation -> Task Manager. When first installed, there are roughly 20 types of task that you can schedule.
By update
