InterSystems Caché is a multi-model DBMS and application server
The steps are as follows：
1. create global
For I=1:1:200 Set ^ABC(I)=""
For I=1:1:200 Set ^XYZ(I)=""
For I=1:1:100 Kill ^ABC(I)
2. create ZJRNFILT
ZJRNFILT(jid,dir,glo,type,restmode,addr,time) /*Filter*/
Set restmode=1 /*Return 1 for restore*/
If glo["^ABC",type="K" Set restmode=0 /*except if a kill on ^ABC*/
Quit
;
3. restore
Hi Guys,
I'm having trouble accessing the snapshots EnsLib.SQL.Snapshot in %Library.ListOfObjects that are returned from method ExecuteProcedure in EnsLib.SQL.OutboundAdapter. The Microsoft SQL stored procedure I am executing returns multiple resultsets.
The issue I am having is that my code works fine when executed in the business operation (commented out in the code below) but when it is executed in the business process it errors. Any ideas as to why this happens? The error I get is:
Hello Community,
Hope someone can assist me to POST a JSON to the below URL. It works perfectly with POSTMAN. But when trying with cache/Ensemble i receive Method not found error
Below is the configuration.
.png)
Hello community,
I am trying to parse the below HttpResponse in Cache. Cannot get the Iterator to work. Is there a single loop which can parse both or single messages and grab the error?
{
error:[
{ txt1:'error msg1'},
{ txt2:'error msg2'},
]
}
{
error: {
txt1:[
'error msg1',
'error msg2'
]
}
Thanks,
Jimmy Christian
Can I connect to Cache using SSMS (SQL Server Management Studio) and view schemas and build queries as I do for SQL Server?
If yes, step-by-step instructions for setting up the connection would be greatly appreciated.
I googled the topic but didn't find any results that were on target.
Thanks,
Christian Bahnsen
I am fairly new to Cache and ObjectScript. I have a new task I have created with a corresponding method that I am trying to debug in Studio (2013).
My ClassMethod looks like this
ClassMethod DoMyWork(Output pWorkCount as %Integer, pInput1 As %Integer = 30)
{
/* Does some work here and increments pWorkCount */
}When I try to debug this using studio, I browse to my method but I am not certain what to put in here for the input parameter 'pWorkCount'.
Hi,
let me apprise you with my problem:
I want to install Ensemble by Unattended Custom Instalation which use my Installation Manifest. It should start from cmd. So I've got everything in .cmd file to start whole installation by only double click. The problem is that I want to set some variables here in .cmd file and use them in Installation Manifest for installation Ensemble. It is about variable with path to some packages which should be imported during instalation.
CSP pages extend %CSP.Page. What about html/css/js/etc that are hosted on the same web application? Is there any way to override how they're processed like with how you can override a CSP page and CSP REST logic?
Thank you!
David
Hi,
I am looking for an Objectscript example to calculate PI (3,14) with at least 100 Decimals.
There are many examples on the internet (https://rosettacode.org/wiki/Pi), but I want to use it for testing purposes.
Regards,
Peter van Voorthuysen
In various tests I used both and found no real reason to prefere the one or the other.
Eventually I missed some limits. At least I didnt' hit any.
What is the general opinion?
Where to use the one or the other?
All,
I'm using Cache 2014.1 in an openVMS environment.
If I have multiple RMS files to clean up, for example.
!DIR MEMBER_EXTRACT.*;*
MEMBER_EXTRACT.CSV;2 MEMBER_EXTRACT.CSV;1
MEMBER_EXTRACT.PROC;1 MEMBER_EXTRACT.TXT;3
MEMBER_EXTRACT.TXT;2 MEMBER_EXTRACT.TXT;1
S FILE="MEMBER_EXTRACT.*;*"
Do ##class(%Library.File).ComplexDelete(FILE)
Hello ,
I am trying to make a REST call using the example given in documentation for Creating REST Services and Clients with Ensemble.
Class Test.REST.WeatherOperation Extends EnsLib.REST.Operation
But i receive below mentioned error. If anyone can help me out here.
I am looking to get the exec statement when we call the SP with
What would a sample DbContext look like and how would you register the DbContext in the Startup.cs ConfigureServices method?
I'm currenlty searching the developers coummnity , but thought I asked this question while I search. How can I use the task schedulrer to purge backups? Do i have to create my own class? Examples on doing this?
Hey Intersystems-Developer,
I have already used that and know its possible, but can't find it anymore :(
I need dynamic access on proxy objects. For example:
set key = "lastName"
set name = obj.name
set lastName = obj.key <- Not possible
set lastName = obj.GetAt(key) <- Not possible
How can I get access to that object with my dynamic variable "key" ?
Best regards.
Using ZZDUMP command in terminal is a nice debugging feature.
But it is useless in background jobs.
How can I get the output into a variable or - less attractive - in a stream object ?
I have a process that receives a EnsLib.DICOM.Document, and then attempts to extract a PDF from the dataset to save to a folder.
When I use the GetValueAt method to get the pdf from the document (from the EncapsulatedDocument section), the status returned is 1, but I'm only getting the first 32648 characters(?) from the PDF.
I thought it was a string max length problem, but long strings are enabled and the final PDF is tiny (94kb) so it's not hitting the long string.
Is there some form of limit to using the GetValueAt method that I'm missing?
When publish my application on the iis server below function not working..
Public Shared Sub Connection()
Try
factory = CreateObject("CacheObject.Factory")
If Not factory.IsConnected() Then
Dim connectstring As String
connectstring = ConfigurationManager.AppSettings.Get("con")
Dim success As Boolean
success = factory.Connect(connectstring)
End If
Hello,
I'm trying to set Caché-Python Binding on Mac, but there is a problem.
I performed installation and configuration of Caché-Python binding module based on the manual (URL)
including setting of PATH and LD_LIBRARY_PATH in "bash_profile",
and they seems to be done successfully (there was no error in the process).
■Setting up CACHÉ preferred connection server.
server name:localhost
ip adress:127.0.0.1
port:1972
Telnetport:23
web server port:57772
web server ip adress:
CSP server instance:
comment:
Authentication method=>password
■hosts
localhost 127.0.0.1
■os
windows10 (virtual box)
Downloading the release notes for 2018.1 gives the 2017.1 PDF release notes.
Can someone please correct this or direct me where the release notes could be found
I used Cache 2016.
I used the following statement to sort after paging, but suggested an error:
When we go to specific name space to search messages in message viewer, at the moment we are adding the search criteria to add criterion type as SearchTable Field, and clicking the dropdown in Class field, there is an error says below in the image:
Could anyone please let me know what exactly the error is from? Thanks so much.
Hi, i have a problem, i need to put some Caché Code into a .JS file. Is this possible?
Hi guys!
As you know there are two (at least) ways to get the stored value of the property of InterSystems IRIS class if you know the ID of an instance (or a record).
1. Get it by as a property of an instance with "Object access":
ClassMethod GetPropertyForID(stId As %Integer) As %String
{
set obj=..%OpenId(stId)
return obj.StringData
}
2. Get it as a value of a column of the record with "SQL access":
Hi all
Is there a data model for the Ensemble EnsLib_HL7 tables in the database? A client wants to run some SQL and would like some documentation about table relationships.
Thanks in advance
Ian
Hi All,
I'm just taking a look at IRIS and what it has to offer, and if this is something the organisation I work for should be looking to take advantage of.
I think I've come across an early sticking point, and I wondered if anyone knew of any options.
