New Book, Caché and MUMPS – Part II

By Paul Mike Kadow

Edited by Deborah Graham and John J. Mitchell

Go to http://cosmumps.org for a download of just the examples of the book and the table of contents.

From the Forward

     InterSystems, from a humble beginning, has grown into a worldwide company with its flagship product, Caché, leading the way.

     First, this book chronicles and explores some of the many areas InterSystems has grown into and has influenced over the years.

     Next, turning to the Caché and MUMPS developer, this book has multiple chapters on Globals, Classes, SQL/Query, etc.

New Book, Caché and MUMPS – Part IIBy Paul Mike KadowEdited by Deborah Graham and John J. MitchellGo to http://cosmumps.org for a download of just the examples of the book and the table of contents.From the Forward     InterSystems, from a humble beginning, has grown into a worldwide company with its flagship product, Caché, leading the way.     First, this book chronicles and explores some of the many areas InterSystems has grown into and has influenced over the years.     Next, turning to the Caché and MUMPS developer, this book has multiple chapters on Globals, Classes, SQL/Query, etc.

Hi, 

I want to splice a PID segement returned from a query, so I can use it in a DTL:

<assign value='context.pidSegment' property='target.{PIDgrp.PID}' action='set' />

I need to set the value of 'context.pidSegment' to something I can use in the DTL objectscript expression

but I'm not sure what method (or property) to use to get the class EnsLib.HL7.Segment segment into a datatype that can be used in the DTL?

I've tried the following to no avail;

• context.K21response.GetSegmentAt("PIDgrp.PID")
• context.K21response.FindSegment("PIDgrp.PID")
• context.K21response.GetSegmentAt("PIDgrp.PID").RawContent
• Hi, I want to splice a PID segement returned from a query, so I can use it in a DTL: <assign value='context.pidSegment' property='target.{PIDgrp.PID}' action='set' />I need to set the value of 'context.pidSegment' to something I can use in the DTL objectscript expressionbut I'm not sure what method (or property) to use to get the class EnsLib.HL7.Segment segment into a datatype that can be used in the DTL?I've tried the following to no

Hi,

I was wondering if there is any way to count elements from an array. I guess not as an array could be multi-dimensional and that would be a problem to return the number of elements inside the array.

As an example:

Information about arrays: https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KE…

Thanks

I have a server with rusw locale but in my cube the time dimension shows dates such as "JAN-2018". Is there a way to either localize that (preferably) or just output numbers  like "01-2018"?

Architect:

Analyzer:

Also in architect, in level settings there is a "Time Format" property, what's that? Tried setting it to 3 but it didn't help.

Note: with support for Overlay storage driver for InterSystems IRIS containers this article is no longer relevant. The article is left here for archive purposes.

Does anyone have any sample code for updating Caché users (and specifically Full Name and Comments) via SQL?  

Bonus points for knowing specifically what security resource needs to be assigned to allow someone to run the SQL.

Thanks in Advance!

Ben

I have a cache client with a list of several servers.

One of the server is working with an IIS server that is not the Cache DB server.

The connection to the IIS server is only through https (SSL)

I tried to define the Web Server IP Address to https://some.server.name but it didn't let me to specify the https

So I tried to define Web Server Port to 443 but when I chose the SMP it's trying to open http://some.server.name:443/csp/sys/UtilHome.csp

and the same for documentation it tries to open http://some.server.name:443/csp/docbook/DocBook.UI.Page.cls

I have a cache client with a list of several servers.One of the server is working with an IIS server that is not the Cache DB server.The connection to the IIS server is only through https (SSL)I tried to define the Web Server IP Address to https://some.server.name but it didn't let me to specify the httpsSo I tried to define Web Server Port to 443 but when I chose the SMP it's trying to open http://some.server.name:443/csp/sys/UtilHome.cspand the same for documentation it tries to open http://some.server.name:443/csp/docbook/DocBook.UI.Page.clsWhat should I do in order for the SMP to open the

I'm working on a task where I need to apply journal file records to another database. I can't use Journal.Restore class methods as I need to perform some data transformation, therefore I'm reading journal file record by record using %SYS.Journal.Record API.  

It seems that there are only few journal records that I need to process, namely:

Type TypeName
6    SET
7    KILL
8    KILLdes
9    ZKILL
10   RemoteSET
11   RemoteKILL
12   RemoteZKILL
14   BitSET

No problem, while I'm just curious: which COS command could provide KILLdes record? I've met it only once in the context like this:

I'm working on a task where I need to apply journal file records to another database. I can't use Journal.Restore class methods as I need to perform some data transformation, therefore I'm reading journal file record by record using %SYS.Journal.Record API.14   BitSETNo problem, while I'm just curious: which COS command could provide KILLdes record?

Without installing Kerberos has anyone Authenticated a SQL JDBC connection? Currently we are using local SQL Accounts to sign onto External SQL Databases, but we are being told that we need to switch to Service accounts that live on a Active Directory Domain. 

I wrote with a little help a ZAUTHENICATE to do the Authentication for Ensemble, can I use something like that to connect to an External SQL Database using a Service Account on a Active Directory Domain?

Thanks

Scott

Hi Everyone!

New video "The FHIR Gateway" is available now on  DC YouTube Channel:

Hi - has anyone successfully used the python binding on a mac. I carried out the install instructions per InterSystems documentation and it fails completely. 204 warnings and 9 errors. Obviously this was never tested by InterSystems. Is it even worth pursuing?

Thanks

Hi, Community!

This is just a short announcement what we did to make life better on DC for June Release.

What's inside?

Better tables formatting, anti-spam, better email notifications and bug-fixes.

See the details inside!

I need to send a PATCH call from the server to a given url.

Until now I was using %Net.HttpRequest to issue calls for get/post/put but today I had to make a PATCH and I can't find a way to do it.

Hi Guys,

have a file located in \\servername\Myfiles\pull.csv but for some reason my cache routine can't file, but can when using the local drive C:\servername\Myfiles\pull.csv.

FYI I can access \\servername\Myfiles\pull.csv via Win explorer with no problems. 

anyway how I can fix this?

Thanks Guys

Hi, Community!

$CASE is a fine syntax sugar for "Ifs" with one-line/one-word expressions, like in docs:

SET daynum=$ZDATE($HOROLOG,10)
  WRITE $CASE(daynum,
              1:"Monday",2:"Tuesday",3:"Wednesday",
              4:"Thursday",5:"Friday",
              6:"Saturday",0:"Sunday",:"entry error")

But if my expression for a current case is a multi-line business logic? Can I use "{}" somehow or better go with "IF" instead?

Hello community, simple question. I've been able to use a ternary operator equivalent by using $select for inline if statements using this pattern:

set x = 1

set result = $select(x = 1: "true", x = 0: "false")

These can be nested and can have a lot of options. But I'm curious if there is a native way of using ternary operators in ObjectScript?

Thank you

Hi Community!

Save the date for InterSystems Global Summit 2018! This year Global Summit is Sept. 30 – Oct. 3, 2018 at the JW Marriott Hill Country Resort & Spa in San Antonio, TX.

Registration for Global Summit is now open!

Is there a datatype class with validation for global references? I can't find one in a brief scan of the documentation / class reference.

In System Administration | Configuration |  System Configuration | Journal Settings there is a check box for Freeze on error.

From reading the documentation, it sounds like the choice to freeze on error is one of system availability vs system integrity.

Curious to know whether Ensemble users choose to freeze on error or not.

If you have a best practice recommendation based upon your experience or knowledge, that would be helpful information too.

I am working with a client to try and export a set of tasks defined in the Task Manager from one system to another.  I am not seeing any API for this.  I can query this information in SQL.  So I tried to use the Data Export Wizard from the System Management portal in the SQL window.  Export was fine.  Importing failed with a "can't insert into read only field" error.  Looking at the class definition does not help since the implementation details are not visible.

So how would one accomplish this?  Export scheduled tasks from one system to another?

Hi Everyone!

Enjoy a new session recording from Global Summit 2017 on InterSystems Developers YouTube Channel:

Tell Your Story With Dashboards

Hi guys, I'm helping one of our customer to use unattended install to standardize their deployment. I'm using Unattended Installation and Installation Manifest. 

Although I can use the combination to install HealthConnect and then create namespaces and DBs as they need, there are still several tasks that I did not find the solution yet. As following:

1. Configure mirrors

2. Set the directory to store journals

3. For a given Ensemble name space, configure the period length in purging messages.

4. Set up some scheduled tasks to PurgeErrorsAndLogs or PurgeAudit

Hi guys, I'm helping one of our customer to use unattended install to standardize their deployment. I'm using Unattended Installation and Installation Manifest. Although I can use the combination to install HealthConnect and then create namespaces and DBs as they need, there are still several tasks that I did not find the solution yet. As following:1. Configure mirrors2. Set the directory to store journals3. For a given Ensemble name space, configure the period length in purging messages.4.

Ensemble 2017.2.

I am writing a DTL code action based on the solution described in the posting "How to avoid truncation in HL7 messages with very large fields (32K+)". Because the source value is in a repeating segment, and the specific repetition in which the value is located can vary, I would like to use a variable (specifically the k1 key) to specify the repetition to get.  I have been unable to get it to work.

OBXgrp is the location in the path at which the repetition occurs. Hard-coding an index, as in the example below, works.

Ensemble 2017.2.I am writing a DTL code action based on the solution described in the posting "How to avoid truncation in HL7 messages with very large fields (32K+)". Because the source value is in a repeating segment, and the specific repetition in which the value is located can vary, I would like to use a variable (specifically the k1 key) to specify the repetition to get.  I have been unable to get it to work.OBXgrp is the location in the path at which the repetition occurs.

Good afternoon, I have a tabGroup where I populate tabs with images using the scr property. If a user scrolls to the bottom of the image on a tab, when they go to the next tab, they are also at the bottom. When moving between tabs, I would like the user to always be presented with the top of the tab content. I have not been unsuccessful in doing this. Would someone have input on how to make this happen? Thank you in advance for any and all feedback.

I  have generated a class using the linked procedure wizard however  I can't get it to work if the  datatype  of one of the parameters is VARCHAR(MAX).  It works fine if I change it to say VARCHAR(500) and  rerun the  stored procedure wizard. 

I get the following  error returned.:

ErrorMsg:   SQLState: (07002) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error

Can anyone see what I am doing wrong?  I think it is to do with the way I am using the  %Stream.GlobalCharacter?   Any help is much appreciated.

Class generated by linked procedure wizard:

I  have generated a class using the linked procedure wizard however  I can't get it to work if the  datatype  of one of the parameters is VARCHAR(MAX).  It works fine if I change it to say VARCHAR(500) and  rerun the  stored procedure wizard. I get the following  error returned.:ErrorMsg:   SQLState: (07002) NativeError: [0] Message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax errorCan anyone see what I am doing wrong?  I think it is to do with the way I am using the  %Stream.GlobalCharacter?

Hi, Community!

This post is a digest of the Developer Community postings in May 2018.

Most viewed

Atelier 1.2 has landed!  190 views

Replacing ZEN - Part 2 - Strategic Issues  156

Atelier 1.2 Beta Updates - May 2018  149

##class( autocomplete for class names  136

working with Angular   132

Load data from excel   130

How to move defined tasks from one Instance of Cache to another  127

Database not mounting  124

Create table for the results of a SQL statement  123

Using Source Control with Atelier on existing code  116

Continuous Delivery of your InterSystems solution using GitLab - Index  109

Hi, Community!This post is a digest of the Developer Community postings in May 2018.Most viewedAtelier 1.2 has landed!

In old Caché versions it was possible to create a new role based on predefined %Developer by copying it and adding some resources as needed. It was true at least from 2010.1 to 2015.1.

After upgrade from 2015.1.4 to 2017.2.1 it turned that it's only partially true now. User with a "New-Developer" role can enter Studio and open existing cls/mac/etc for editing and everything is OK unless he tries to create something new (Ctrl-N), than he gets a pop-up with %msg: <User xxx does not have enough privilege to execute stored procedure %CSP.StudioTemplateMgr_Templates>

In old Caché versions it was possible to create a new role based on predefined %Developer by copying it and adding some resources as needed. It was true at least from 2010.1 to 2015.1.After upgrade from 2015.1.4 to 2017.2.1 it turned that it's only partially true now.

Hi I am getting below error after rebooting Linux system and restarting cache services.

Daemons are running (shared memory object is missing)

cconsole giving error 3 Daemon WRTDMN (pid 28161) died. Freezing system

I was wondering if there is a way of adding additional headings under the settings tab for services etc?

I'm aware its possible to add items under the additional settings heading, but being able to split these out into separate headings would look a lot nicer.

While trying to start the instance INSTANCE001, getting below error, where cache.shid file doesnot contains anything.

This is in a Linux server.

Any help is appreciated.

$ ccontrol start INSTANCE001INSTANCE001 startup failed: Instance is down although there is process attached to shared memoryYou can get the shared memory ID in cache.shid filethen run 'ipcs -m -a' to see the number of processes still attached.