InterSystems Caché is a multi-model DBMS and application server
Hi,
How do I generate JSON strings instead of integers, as follows:
{ "MyProperty":"1"}
all we seem to be able to generate is
{ "MyProperty":1}
Its for an api that requires the former and as the former is valid JSON I'm surprised I am having so much trouble.
(Obviously I'm new, please be kind :D
Does anyone know if there is a table or query to get the Application Error Log (^ERRORS) by SQL?
cache 2017.2 windows 10
Is there any way to change the sql Shell interface to output a <TAB> between the fields instead of outputting one or more spaces between columns
I needed to run an sql ( that took a while to run) and then cut and paste the generated output into excel, trouble was the paste into excel was not very good for columns when there's spaces used between the columns
kev
We use the %Net.FtpSession class to perform FTPS file transfers. This has worked fine with Implcit FTPS servers but crashes when trying to connect to an Explicit FTPS server. Explicit FTPS has a slightly diffferent negotiation in the intitial connection and different ports.
Has anyone gotten Explicit FTPS working with the Cache classes?
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:
{
Hi!
I need to export some data from a table on CACHE and then import this data to a POSTGRESQL table.
Is this possible? I know I can export this data as a CSV format, but I prefer if there is a way to export that data as SQL format.
Thanks!!!
Hello people!
I am Brazilian and I am starting to work with the latest version of CACHE, and I would like to know where I can see an example of a TRIGGER, I would like to validate the fields before writing the actual data in the database.
in advance, thank you very much! and sorry for any mistake in concordance in english
I face the challenge to have a bunch of classes on IRIS and CACHÉ in parallel
until all systems are migrated to IRIS.
Applying changes in Caché development environment and moving to IRIS is no problem
But if I have to apply a fix on IRIS there seems to be no clean way back to Caché.
where can I find a list of all command line utilities with a short description?
I'm looking for some existing solutions to compare 2 global structures.
- by subscripts
- if subscripts match then by content.
Hi,
Below To_Char function is not working as expected
SELECT TO_CHAR('12/31/1840','mm/dd/yyyy') ---01/12/1841
I expect the result to be 12/31/1840. Let me know If there are any suggestion to get the correct result.
Thanks,
Meena
Been cleaning up our production 2017.1 instance of Health Connect in preparation to a move to Health Connect 2020.1 (on IRIS!)
One thing I have found I we have built up a number of old classes and other configuration files.
It would be nice to start on the new server with a clean slate.
Is there any way to identify classes that haven't been used for a long time so they can be reviewed and removed?
Kind regards,
Stephen
Hi,
I get this error [Cache ODBC][State : HYC00][Native Code 469] and zero rows returned with the following query.
SELECT "Timestamp","Skillset" FROM "dbo"."iSkillsetStat"
WHERE (Timestamp >= '2020-06-29 00:00:00'
AND Timestamp < '2020-06-30 00:00:00')
I'm using Qlik Attunity Replicate to extract data, the query was formatted by the tool. The query will return data in excel and SSIS, but not using Replicate.
So far I've tried using two ODBC drivers
-----------------------------------------------------
Hi,
I want to use Single Sign On(SSO) in SAML tokens using SOAP. I need X.509 certificate.
Where can I get that certificates from a trusted source?
Is any other way to do SSO in Intersystem Cache 2017.
Can anyone please help me on this.
Thanks.
Hey everyone.
I have a use case where I need to write files to a handful of locations, and 2-3 subfolders in each location.
My plan was to extend EnsLib.File.PassthroughOperation and then pass that operation the file and the subfolder details, and then have an operation per destination.
Has anyone done anything similar and can highlight any pitfalls I may be about to make?
Hi everyone,
when I'm using the %JSONExport-function on Caché-Objects containing properties of type %integer, %numeric or %boolean, this properties are all automatically converted to Strings in the JSON-Output.
Is there a way to get around this type-cast?
Example:
Result with %JSONExport:
maxOrderable and maxReserveable are of type %integer, deliverable and assembly of type %boolean. All 4 properties are shown as quoted Strings.
.png)
Hi,
Can anyone please describe me how to connect Java (JDBC) with Cache database.
From where i can download the cache import files.
Thanks
Jude
I need to set and use some context variables in a transformation (written in DTL), but the code is manually written.
When writing the same as BPL I define context variables and they are visible in transformations called by that process.
In something like this my.DTLtransform sets HL7 message fields to values in context variables:
Running cache 5.0.21 64 bit on Windows server 2016 in virtual environment. Trying to understand why every single process disk read speed (simple sql data walks) caps around ~20MB/s, however 2 paralell such tasks on different data areas can reach 19MB/s each, four - 17MB/s each, that is 70MB/s total, etc. Also simple copy file to nul on that system reach ~400MB/s.
What can keep single query on idle system from reaching for example 200MB/s? Virtualization? Windows? Cache? Processors are below 1-3%
Hi,
Could someone help me in identifying all characters in a column is whole number 0 or greater
CASE WHEN '123' %MATCHES '[0-9]*' then 'VALID' else 'INVALID' end
The above statement is finding only for first character.
Thanks
Hello.
We're trying to create a script that compiles everything on a certain namespace, for that we are depending on CompileAll. However it seems that this method doesn't check for a dependency tree even when using flags like: curb.
Hello,
We wonder how could we get the following attribute:
.png)
Which is found in the response Header being sent from a Operation to a Process, when there is an exeptionWwe would need to access the Response ErrorStatus text in the Process
We have already tried:
I know that 1-1 relationships are not officialy supported by intersystems cache/iris so I want to know the best way to store data with this kind of data model.
Currently I have two classes that where implemented some time ago:
Table A with a relationship type one on table B
Table B with a relationship type one on table A
To compile I have a double compile with qualifyer U.
What is the best way to implement a data model with 1-1 relationships?
Thank you
How do I compile a file through the command line?
I am generating a very basic csp page in a bash shell, it is generating fine and displays what I want to see as long as I go into studio and compile it . This defeats my purpose of having the page and I am having no luck figuring out what I am doing wrong. I think the issue has to do with the file not being included when I compile from command line.
Ver is 2017 running RHEL 7
From command line I see
TST 3f2>DO $SYSTEM.OBJ.Compile("csp.vvmaccessnewrds","h")
Hi, I am doing a stream read so that I can do some inserts to the table however other language read is not supported, any idea what I need to do to achieve this?
Thanks
Is there any way to execute many SQL commands at once as an (anonymous)block?
for example in PostgreSQL there is
.png)
.png)
DO $$
BEGIN
--here is Inserts/Updates/Deletes
END $$Or in Oracle
BEGIN
END; Thanks for the answers!