#Caché

I need to do an UPDATE via SQL and I would like the statement to return the `ID` column of each row that is updated.  MS SQL has an "OUTPUT" statement, but I don't see anything similar in Cache.  Is there a way to do this?

Have you tried $Translate for date conversion?

USER>write $Translate("Dd.Mm.WwYy","WwYy-Mm-Dd","2015-08-02")

02.08.2015

Stolen from Russian forum and Alexander Koblov.

Is the possible for Multiple Streams using in single method?

I created on program . How to convert this application in .exe format.

NewBie's Corner Session 29 Documentation on the Caché/MUMPS Global Structure

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

This post contains several links to very good documentation of the Caché Globals Structure.

Like I said, "Perhaps the most difficult concept in Caché/MUMPS is its Global Structure."

universalNoSQL.pdf - http://mgateway.com/docs/universalNoSQL.pdf

by Rob Tweed and George James

Extreme Database programming with MUMPS Globals

http://gradvs1.mgateway.com/download/extreme1.pdf

by Rob Tweed

Documentation from InterSystems on Globals

http://localho

 Windows 7 and some other Microsoft Operating Systems can shutdown too fast for large applications, such as a Cache instance with a large amount of data and changes, to close gracefully. This results in the instance being forced down by the OS and so causing problems on the next start up.

To solve this we can change the OS shutdown timeout values to give Cache more time to close gracefully. We do this by editing some settings in the Registry.

1.Click Start (on Win 7) and type “regedit” and make sure you run registry editor as administrator.

2.Go to

We're developing Ensemble PoC and one day our frontend developer (who doesn't have Ensemble production running) said that Populate just doesn't cut it and he needs to see the real data. He needed only one object, but the problem was - it's a big object. Still, I checked ids of everything related and wrote this command (parts omitted, but you get the idea):

w

I tried to get a image from user . But It did not run. So please solve this problem

Class Quadramed.Chennai Extends %Persistent
{
Property Image As %Stream.FileBinary(LOCATION = "C:/Images");
Method imagefile()
{
s obj = ##class(Sam.binary).%New()
r "enter your name",img
d obj.Image.Write(img)
s status = obj.%Save()
}
 

NewBie's Corner Session 1 Installing Caché

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

Session 1 - InterSystems Inc. allows you to download a single copy of Caché to your personal computer at no cost. This is available from www.InterSystems.com.  It is at this link: https://download.InterSystems.com. You will first need to register yourself with InterSystems. Follow the instructions on how to download the install file. Choose the full version of Caché, not the Client Components.

After you have downloaded the Caché install file, double click on the

NewBie's Corner Session: 9 Documentation and books

Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.

To access your documentation:

Assuming you have installed Caché, (see NewBie's Corner, Session:1),

Click on the InterSystems cube in the Windows system tray, then choose Documentation.

Or – another method you can use to access your documentation:

Assuming you have installed Caché, (see NewBie's Corner, Session:1),

Click on the InterSystems cube in the Windows system tray, then choose Preferred Server,

From the drop down menu choose Add/Edit

Then from the row that has

I have setup an async reporting mirror member with Read only access.  My problem is that if I try to do any sql reporting against that data I am getting errors.  I am sure that this is because the DB is read only, but I had assumed that setting up a reporting mirror would handle this.

I there a setting or mapping  I am missing?

How to get a input in array collection with class properties.

Class collect.arraylist Extends %Persistent
{
Property DOB As %Collection.ArrayOfDT;
ClassMethod valu()
{
s list = ##class(collect.arraylist).%New()
r ""your DOB:", DOB1
do list.arraylist.SetAt("DOB1",0)
}
 

I get a input from user.How to I retrieve the data from these input. I enter the program but its occurred Some error .So give an idea of how to retrieve the data from properties.

ClassMethod Getvalue()
{
S Details = ##class(Sample.Employeedetails).%New()
r "Enter Your Name:" , Name1
s Details.Name = Name1
r "Enter Your Address :", Address1
s Details.Address = Address1
r "Enter your Phone Number:",Phonenumber1
s Details.Phonenumber = Phonenumber1
r "Enter your Blood Group:", Bloodgroup1
s Details.Bloodgroup = Bloodgroup1
r "Enter Your Desination:",Desiation1
s Details.Desination = Desiation1
r "Enter your

Hi,

The OnHTTPHeader method not support in cache 14 but it support cache 13.

OnHTTPHeader(ByRef OutputBody As %Boolean) As %Status [ ServerOnly = 1 ] this method return Some special character.

Thanks,

sanasa

Hello,

we build a COS-application which includes classmethods for running a simulation calculation (differential equations by Runge Kutta procedure) which runs well but needs too much time. This is embeded in Cache Server Pages and we tried already to start the simulation as a JOB to avoid the CSP-timeout.However the Job needs of course also too much time.May be this could be solved by a different strategy to run the simulation calculation by an external Windows -Programm (developed with Delphi).

Hi All,

         The onHTTPHeader using for redirect body statement.but this not support cache 2016.

     This method return the following text.

�Xmw�:�ܜ��0��-��4�ܒ&��Ro)�����XA�D���=����6༴��������h4#���\�d��iH�Լ'K�Y��P8��juf׾��=<����+6�#�w�9��!�\��'�dK*O����a�a��7��@&\�ǰ�?�=Az(���^�+IU((�2�����n^N��#��SP�i��Q��!d��0a��A �Ѫ��%&��׉�@��o�)���"���Jy��̄��ԝ�#��� \$.[������R�!���K���G�{�c��׺���r�w�P�?�g�w�녫��Y[0һ�����ly~w�[�������?�������ߟ?_N���ym|k��ϟD�Z�pt�����C����M٧�&&�b���0.�����f��d�ŚPx�ԣ )} +�q���^&�'�8�Ȕ0�����(�'����C"���5�n�p���}�]

Hi all,

         In CSP page we get data from Class via Query method.

         <TD valign=top>#(DEOBJ.Get("Comments").Read())#</TD>

         The problem is we couldn't get the stream property value.

        (Property Comments As %Stream.GlobalBinary)

Thanks,

sansa.

Do you have any experience / recommendations / best practice on how to update server-side data residing in a Cache database via a REST service?

A naïve approach would be to send a full JSON representation of the data object via an http POST to a method on a REST handler class: 

<Route Url="/mydata/:id" Method="POST" Call="Update"/>

The problem I see here is, if only one of the data object's properties has changed, how do we know which? Or do we simply overwrite all properties? 

Hi-

This almost seems like a silly question, but I am new to REST services.

I have a rest service that has a method for adding records to my database. 

<Route Url="/userdetails" Method="POST" Call="SaveUserDetails"/>
 

My REST client sends data using json in the body of the request.  I have verified using debugging tools that the data is actually being sent.

On the server side in my SaveUserDetails method where do I find the json?

What is the proper way to serialize that json into an object?

What's the difference between a Login Cookie and a Session Cooke Path?

What's that cookie in my browser from? 

Thanks,

Laura

Hello, guys.

Say I have two horologs or timestamps, how can I compare them? I know that just time1 > time2 doesn't work because it will compare them as strings which is not correct. 

Why $ZF(-1) not workers in Windows 10 ? Is there Any reason for that ?

I have been using the query below and it was working fine but now it's giving a SQL error. There were no changes made that could cause this to stop working. There is no Field 'APPLICATIONID' in the table.

QueueSQL=select distinct (convert(char(5),SkillsetID)+'='+Skillset) from iagentbySkillsetStat where ApplicationID > 10000
QueueMappingSQL=SELECT DISTINCT (convert(char(5),SkillsetID)+'='+Skillset), SkillsetID FROM iagentbySkillsetStat iagentbySkillsetStat WHERE (iagentbySkillsetStat.ApplicationID>10000)

DB- Intersystems Cache

Error details for the log files are below.

14/09/2016 11:20:05 a.m.

Let's say I have a global named ^a and I need to export its nodes 1, 2, 3, 5 only.

Currently I write something like this:

Write $SYSTEM.OBJ.Export("a(1).gbl,a(2).gbl,a(3).gbl,a(5).gbl", "C:\Users\eduard\Desktop\a.xml")

Is there a way to write it shorter? I want to write global node once and list all the subscripts I need.

Hi,

  I was set one session in user namespce (%session.Data("sup")="login User ").but i couldn't get this session(%session.Data("sup")) in  another namespace.

Cache version:cache 16

but i can acces in cache 5.02.

What are the difference between method()  and ClassMethod()  in Cache Class definition

Hi All,Cache is not starting ,I checked the cconsole log it is showing the below error. The following parameters are missing from section [Journal]: '2,12' at line 143,but i checked in last cpf file, In cpf file consist of that particular line [Journal] AlternateDirectory=C:\InterSystems\CACHE16\mgr\journal\ BackupsBeforePurge=2 CurrentDirectory=C:\InterSystems\CACHE16\mgr\journal\ DaysBeforePurge=2 FileSizeLimit=1024 FreezeOnError=0 JournalFilePrefix= JournalcspSession=0

Listout the Difference between Cache object script and Mumps

A “Dummy” SOAP Web Service

When dealing with SOAP in Caché, it is sometimes necessary to debug errors by directly accessing (and sometimes editing) the XML which is sent, i.e. the SOAP request and subsequent SOAP response. If you’re debugging a Caché web service, it is often useful to use a tool such as SoapUI (https://www.soapui.org/) to manually create and control the SOAP request, so that the effect of adjustments can easily be seen on the Caché web service.

But what if you have a web service (possibly not Caché), and you want to debug the associated Caché web client?