I have a code block in a BPL. I have the below SQL and code. All variables have been declared and set. When I run the SQL, if there are no values returned, I get 100 for the value of SQLCODE when I perform the FETCH, which is correct. If values are returned, I get a -400 error when I perform the first FETCH. I've investigated, but cannot find the reason for a -400 error. Hoping someone out here understands this and knows what's wrong.
Hello Community members, am newbie here Already learning and working through Studio & Terminal and since am from C# background and trying to use VS Code for ObjectScript coding, appreciate you help, unable to edit files, please see below snapshot
If a global node contains special characters, (eg : a line returns), it will be displayed like this in Portal ("System > Globals > View Global Data" panel) :
^A(1) = "this is"_$c(13,10)_"a test"
I would like to export global data to a txt file using a similar format.
I already wrote the main code (that loops on all nodes and dump them to file), the problem is how to handle special characters. For the moment I replace them manually one by one. It works, but it's far from perfect :
I'm trying to setup the JDBC Gateway Server so customers can connect to IRIS remotely using JDBC and not ODBC. But I'm facing a problem connecting, as our system department tells me IRIS is using the loopback address (127.0.0.1) and that makes remote systems cannot connect to port 53773 (the default port for that).
So, I would like to change this 127.0.0.1 host for the hostname but I cannot see where to do it:
Hello! I have basic web services application that c# clients connect to the cache web services. Using the browser, the user enters in the following url.
I need to convert an array with an unknown number of indices to a JSON string for transmission (which is why it isn't possible to iterate through it using $ORDER). Does ObjectScript provide functionality to convert an array to a JSON string?
Edit 1: As Joel mentioned, the array is subscripted and has an arbitrary structure like:
Where can i get the latest odbc providers from SQL Server 2012/2016?
I see some posts on line to an ftp site out there but I am unsuccessful at getting access to it. I have a version loaded on my server but get errors when querying cache'.
"[Cache ODBC][State : 22005][Native Code 22005]"
Any help would be appreciated.
the one we have might be version 2014.01.05851 64 bit (would that make sense?)
Is there a way to query the database structure? In SSMS there are queries for finding tables with a column with a certain name (using LIKE). And there is the redgate tool SQL Search. But I'm not sure how to go about looking for columns that have say a value of 'PATID' and returning all tables that match. Does anyone know?
Product is Caché
Version is 2018.1
Hi
I'm working in a security issue of the system that says that once you are logged into a session
and you save this cookie. You can go to another navigator and use this cookie to be registered.
I would like to chenge this cookie once user is logged into my system but I can't logout and
login again because all my cookies are removed.
Is there a way to change to cookie or renew it?
Thanks a lot.
Caché running on Windows Server includes a built in telnet service. Unfortunately though telnet is a plain text protocol, which generates a security violation from our network security scanner. Is there a way to replace telnet with SSH to connect to a Caché system running on Windows 2012 R2?
I searched to see if there was a previous question on this, but I didn't quite find anything. Please link if you think this has been answered before (I have a feeling it has): what are the barriers to source control using Cache 2018 and Studio?
Okay, we've got a quite useful way to very easily Import and export our objects as JSON, similar to what we already had before for XML.
So, It's a %JSON.Adaptor. But the issue here I faced with, working with Stream properties.
I have an example, when I generate an object, with stream binary stream properties. Export and Import the same, but getting the different resulting objects, depends on the original size of streams.
I have a set of strings that contains special characters. Im trying to write a sql query to remove all the special characters in the string. Im using Intersystems cache sql.
I am brand new to Cache and have been tasked with extracting data from the dB. I see that there are a bunch of tools that can be used to extract via SQL Server statements. DataGrip and DBeaver to name 2. I've gone through some documentation and it doesn't look as if SSMS can connect directly. Is there a preferred extraction tool that anyone can recommend. Does the Cache dB have anything built in where I can access the data while seeing a visual of the tables/schema?
I work as a contractor for the Department of Veterans Affairs. I want to read data from an Excel workbook. I searched posts here and saw Apache POI suggested. I believe Apache POI is not approved for use within VA. I also believe we should be able to run SQL query against Excel. Has anybody done such a thing or are there other ways to read data from Excel workbooks?
This may not be the right place to ask, but I am having some issues with the VSCode setup. I have installed the InterSystems Extensions but I am not seeing the InterSystems icon on the Action Bar long the left side of the screen.
Can someone point me in the correct direction of what I need to do to fix this issue?
I have been looking into using abstract classes and methods. In other languages, if a superclass is defined as abstract, subclasses inheriting from the superclass will not compile until all abstract methods have been implemented in the subclass. I have created the following classes to try this in Cache: Class User.Music.AbstractClass [ Abstract ] {
We receive an HL7 order message into our integration engine containing OBX segments. I would like to create a PDF file and take the values from all instances of OBX-5 in the message and write them to that PDF file, which I would then like to embed into an outgoing message to another system.
By views.png)
.png)
.png)
