Beginner tag unites articles and questions for those who are getting started with InterSystems Data Platform
Thanks for all replies in advance.
Is it possible to modify a users security from a batch script? If it is possible can someone point me to some examples or documentation?
With a routine like this one, you can quickly calculate how many lines of code you are working with. And it is not only for routines, it works for classes because remember that classes generate routines !
Here you have the routine source code:
LinesOfCode ;
new SQLCODE,tRoutine
set tTotalLOC = 0
&sql(DECLARE ROUTINES CURSOR FOR
SELECT NAME
FROM %Library.RoutineIndex
WHERE TYPE = 'MAC'
ORDER BY NAME)
&sql(OPEN ROUTINES)
&sql(FETCH ROUTINES INTO :tRoutine)
while (SQLCODE=0)
{
write !,$j($i(tCount),5),": ",tRoutine
set tLOC = $get(^rMAC(tRoutine,0,0))
write "("_tLOC_")"
set tTotalLOC = tTotalLOC + tLOC
&sql(FETCH ROUTINES INTO :tRoutine)
}
&sql(CLOSE ROUTINES)
write !!,"Total lines of code = "_tTotalLOC
Beginner’s guide to RESTful Application Program Interface (API) design and documentation. Through the example you will learn some common pattern for RESTful API.
You need to know
What is an Application Programming Interface? Is it something materialized? Is it a single programming unit? What is an API for? From my point of view an API is something which is determined by the program code in an indirect way.
Very new to this side of cache....
So, currently in the habit of keeping all users forever, up to over 5000... ? is what if we decided to start deleting old users who have been gone from the company, how would it affect any account level information? notes, payments etc.... Is there any documentation anywhere that would answer this or describe this process or maybe best practices??
Sorry if this seems stupid but i am working on a proof theory for work.
Difference between function , routine and procedure in object script.
I have an operation which calls an external web service, returning a long XML string.
Passing the string into Excel creates a table like this:
Each row above relates to a document on a server. In Ensemble, I need to parse the XML similarly to Excel, where I can loop over each document and take various actions depending on the different values.
I created a BPL to call the operation and return the XML string, which I've converted it to an %XML.TextReader object, and I'm using a While loop to loop through each element.
A beginner’s guide to Exception Handling in RESTful web services. The article gives an example how the various error conditions during processing a service request can be handled.
We expect our client – server communication working in a flawless operational condition, running error free software. But we are prepared to handle exceptions. Are we? So far in the examples of the previous sessions were not. We did not care about exceptions. The result? In any error incident it took ages to figure out what the problem is and more importantly how to fix it.
Remember, REST leans on HTTP.
I can't able to access the management portal in tcp the cache is run on different port no 57812 plz i want immediate rply soon
This article gives a brief introduction how a RESTful service consumer and a RESTful service provider exchange data. It is a beginner’s guide. Data is transferred from a consumer to a provider as parameters of the service. Parameters are part of a service request. The result of the service action a response is returned from a provider to a consumer. Both the service request and response are standard HTTP messages. Since HTTP is a flexible standard regarding to the message contents, RESTful services also enjoy the versatility of data transfer methods.
Good Morning and thanks in advance for all replies. I have created a PowerShell script for backing up CACHE and all related files to be run on a nightly basis. My script works as long as the Unknownuser has %all access which is not acceptable in our production environment. I have tried every format I can thank of to get the script to use a specific id with no luck. How can I get this command to run under a specific id?
..\bin\cache -s. -U%SYS "##Class(Backup.General).ExternalFreeze() <d:\backup\login.scr"
The file just has
userid`r`n password`r`n
`r
NewBie's Corner Session 27 Traversing A Global with $Order Part 1
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Traversing A Global
Perhaps the most difficult concept in Caché/MUMPS is its Global Structure. This session and several that follow it deals with the Global Structure. However, just presenting the material will not guarantee your understanding of it. You must experiment with the data and concepts that are presented.
In this session, we are going to create a small Global of three levels deep, and then show the code to Traverse the Global.
NewBie's Corner Session 28 Various Methods to Traverse a Global
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Judging from the number of responses to Session 27 Traversing A Global, developers are passionate about their methods. I am not here to judge the merit of the various methods.
Over the next few pages I will demonstrate a number of methods to Traverse a Global. If you don't already have a favorite they may help you pick one.
I will repeat the method from Session 27 just to have all methods in one post.
The article is a step by step guide for beginners to learn how to build a RESTful web service consumer (or client) in Ensemble. The provider can be any RESTful service, but the example is based on the service we made during the previous sessions.
It is more than obvious that many client development environment has programming libraries or containers to build a RESTful client. For example in the earlier sessions we used Java Script to access services. Ensemble as a container also offers client functionality. Let us have a quick list what Ensemble offers.
We are using object EnsLib.EDI.XML.Document and the method OutputToString -- ( context.XMLObject.OutputToString("C(utf-8)") ), In the string that we get back, Hebrew characters are unknown and we get question mark instead.
How can we overcome it?
Cross-origin Resource Sharing (CORS) is one of the basic security features built into browsers. CORS controls accessing resources from a HTML page in domains other than the original domain. It is particularly important for AJAX calls. Since RESTful services can be used as data provider to any AJAX call, you have to be able to control cross-origin access. By default services are not allowed to do CORS. You are going to learn how to enable it for Ensemble RESTful services.
The Resource Map class (the subclass of %CSP.REST) controls whether CORS is enabled. There are two approaches to do.
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
by Rob Tweed
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: . 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.
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.
NewBie's Corner Session 26 Globals and Arrays Part 2
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Globals, Arrays, and Variables Part 2
A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.
Uniqueness of the Caché Global Structure or database
The Caché Database Structure is unique among databases; it was designed and created in the 1960s to be used primarily with HealthCare applications. It has thrived in the Healthcare Industry as well as Financial Information systems and others.
NewBie's Corner Session 25 Globals, Variables, and Arrays Part 1
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Globals, Arrays, and Variables
A thorough understanding of Globals, Arrays, and Variables is foundational for every Caché developer.
A Global may be:
Scalar (a single element), as in a Global Variable
NewBie's Corner Session 20 Parameters and Status Part I
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Parameters
Parameters are another name for Variables when used in passing data from one Routine to another.
Let us say we have 2 routines (RtnA and RtnB), and we want to pass 3 parameters (Parm1, Parm2, Parm3) from RtnA to RtnB.
NewBie's Corner Session 17 New command
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
New command
The New command limits a variable's scope or range of use. In theory the New command is simple, in reality the New command is powerful and needs to be respected and understood. In Caché ObjectScript and MUMPS an entire chapter is devoted to it.
NewBie's Corner Session 3 More Read and Write commands & Multiple commands
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Click on the Caché Cube in your system tray and select Terminal to try out the commands.
Write command with carriage return and line feed
When the exclamation point "!" is inserted after a Write command, a carriage return and line feed combination is produced. Note in this example, that a comma separates the exclamation point from the variable "X".
NewBie's Corner Session 8 Not
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Click on the Caché Cube in your system tray and select Terminal to try out these commands.
NOT operator ('), single quote or apostrophe
The "NOT" operator reverses the truth-value and is intended for numeric operands, however it can be used on alphanumeric operands.
NewBie's Corner Session: 5 Operator Precedence
Welcome to NewBie's Corner, a weekly or biweekly post covering basic Caché Material.
Click on the Caché Cube in your system tray and select Terminal to try out the commands.
Order Precedence means the order in which mathematical operators are executed. In a Mathematical expression, you may have Multiplication, Addition, Subtraction, and Division. Which of these are executed first, second, third, etc.
Hi
In studio when I right-click a package there is no option to delete it.
Also how do I upload an image to this post without linking to an external site?
Currently when class is saved in Atelier it is automatically saved on disk and on server (if there is an active connection).
Is there any way to save file with class or routine just on disk, but not on server?
In MSSQL I think you can do something like this:
select *
from HS_IHE_ATNA_Repository.COLUMNS
where TABLE_NAME='Aggregation'How can I do this in Cache SQL?
[%msg: < Table 'HS_IHE_ATNA_REPOSITORY.COLUMNS' not found>]
Does Caché support a relationship property ordered according to a specifc value?
What shoud be the best approach?