In the past, I've created custom SQL operations, but now I had something trivial to do, so I decided to take EnsLib.SQL.Operation.GenericOperation out for a spin. There's no example in the docs, so it was a little tricky. Here's what I ended up doing:
In my external database, I have 'mytable' with two fields 'id1' and 'id2'. Here are the pertinent Business Operation settings:
https://www.youtube.com/embed/knn0-pGPbtQ [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
I'm trying to connect to an IRIS instance using VSCode, the problem is, there are 2 IRIS instances installed on this server, published by the same hostname using https (port 443) under 2 different subfolders (e.g., iris.demo.com/base & iris.demo.com/test).
When connecting via studio, I was able to connect by using the hostname (e.g., iris.demo.com) and specifying the super server port, while when connecting through VSCode, when specifying the web server port 443, the connection is always defaulted to one of the instance.
Users of the InterSystems Change Control Record application (CCR) often ask for useful resources which can help them learn CCR and stay in the loop on updates. Please see this list of resources below and post ideas for additional resources or questions you may have!
I have a BPL iterating over Dynamic arrays. Can I add Dynamic Array (%Dynamic Abstract Object) and also %Iterator.Array to BPL context? I tried and I see Error: %AddToSaveSet method does not exist for %Iterator.Array
Access the platform using >> [this link]<< and log in with your InterSystems SSO.
Please note: during recent tests, we discovered that some users are encountering errors when trying to log in this way. We’re currently investigating the issue with the vendor. If you experience this error, just ping me via DM, and I will send you a manual invitation!
I am experiencing an issue while executing a stored procedure in InterSystems Cache. Here’s the procedure I created
CREATE PROCEDURE Silk.sp_InsertRecord ( IN RecordDate TIMESTAMP, IN UserName VARCHAR(50), IN RecordType INT, IN RecordID VARCHAR(50), IN CategoryID INT, IN ApprovalDate TIMESTAMP, IN FileSize BIGINT, IN WorkstationName VARCHAR(50) ) BEGIN INSERT INTO DummyRecords ( RecordKey, FilePath, RecordDate, UserName,
I try to generate JWT tokens in Cache (not in IRIS).
In IRIS I managed to generate tokens using ##class(%OAuth2.JWKS).AddOct("HS256",secret,.jwks).
But In Cache there is no such routine.
Could you provide me a place to find an example how to use JWT, please ? I am interested to generate a token in Cache, send it to javascript client, and read a token provided by the client and check it is valid.
We use $ZF(-1 synchronous call to generate the pdf files. Now I want to change to asynchronously. So, I use $ZF(-100 with "/ASYNC" function. I use "/ASYNC" directly write $ZF(-100,"/ASYNC","notepad.exe") in windows/linux it throws the <NOTOPEN> error, However If I use $ZF(-100,"/ASYNC /SHELL","notepad.exe") it opens the notepad without issues.
I have an IRIS installation that is using 8-bit charset encoding (set to deu8 / Latin 1). I would like to convert everything (database and system) to Unicode
Charset encoding is something asked during installation, is it possible to change this on the fly ? The installer clearly say that Unicode systems cannot be converted. What about 8 bit ?
Same for database : is there possible conversion ?
We've just made a change to Server Manager with the aim of it coping better when a stored password is no longer valid, for example because it has been changed.
https://www.youtube.com/embed/Z-x6Rk7Bi3I [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
Many programming languages use the try-and-catch construct to handle runtime errors gracefully. If the code within the try block encounters an error, it will throw an exception to the catch block, where the error handling occurs.
I've the below databinding on a combobox and the issue that the binding is coming with the display value of my levels so eg. I'm getting normal instead of 1 which mean the combobox in my form is not showing, so how get the binding to bring the VALUELIST rather then DISPLAYLIST ?
Hi everyone, My name is Emmanuel Katto. What performance tuning techniques have you found most effective when working with InterSystems IRIS? Any specific metrics to monitor?
I'm hoping that someone may be able to point me in the right direction to get started with working with files in Intersystems. I am currently trying to build an interface that will consume a text file containing a list of IDs (one per line) and then write those IDs to an external database. I am comfortable working with the database end but have not worked with files/Stream containers etc yet.
https://www.youtube.com/embed/Q-7dfmwkvt0 [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]
By update.png)
.png)
.png)
Open Exchange app