When you want to have two or more classes pointing to the same storage. Sometimes it can be useful to have one persistent class with full definition and another with only a few properties. I used this approach to test indices building on a test class - it does not affect existing class and it's indices.
2. Write a routine to copy (duplicate) all the data from old classes to new ones. (which is not trivial at some point)
Why is it not trivial? If you're not changing class definition three merges per class should be enough.
Also check that storage definition in the new class is the same as in old class, only pointing to the new globals.
MANAGEDEXTENT=0 may be easier to do, but it raises the risk of accidentally deleting old globals (what are these globals not corresponding to any class? Let's free some space)
I don't think that order of indices in first argument affects anything. They are converted into tBuildFlags which also follows by ASSCII sorting of index names
It's available in the docs, another doc.
On previous versions you can use ^%GSIZE utility:
do ^%GSIZE
Directory name: c:\intersystems\cache\mgr\mdx2json\ =>
All Globals? No => No
Global ^Git("TSH")
Global ^
1 global selected from 54 available globals.
Show details?? No => Yes
Device:
Right margin: 80 =>
directory: c:\intersystems\cache\mgr\mdx2json\
Page: 1 GLOBAL SIZE 16 Nov 2017
11:49 AM
Global Blocks Bytes Used Packing Contig.
-------- -------- --------------- ------- -------
Git("TSH") 1 132 2 % 0
TOTAL Blocks Bytes Used Packing Contig.
-------- -------- --------------- ------- -------
1 132 2 % 0
<RETURN> to continue or '^' to STOP:Check that your XML declaration (encoding) corresponds to the actual stream).
I have a Cache-compatible sql script file and each query is separate by white space.
How do you escape white spaces in a query?
Anyway, the general approach is:
set file = ##class(%Stream.FileCharacter).%New()
do file.LinkToFile(filename)
while 'file.AtEnd {
set query = file.ReadLine() // ???
set rs = ##class(%SQL.Statement).%ExecDirect(, query)
set sc = rs.%DisplayFormatted(format, outfile)
}Where:
I assumed query separation by newline.
Also outfile needs to change between queries as %DisplayFormatted recreates it.
Thank you!
Would it work on linux, provided correct paths?
Duplicates are very similar.
You can try to use %SIMILARITY function available in Cache SQL.
You can use Session Events for logging, it provides OnStartRequest and OnEndRequest callbacks.
Is it possible to know the user through the session, in the broker, or in the triggers?
Yes, you can store data in %session object and retrieve it on a later date.
Also, check out my series of articles (part1, especially part2) on web debugging.
@Murray Oldfield wrote a great series of articles focused on performance and detecting bottlenecks. Check it out.
Here's some steps you can take to debug this query:
1. Add BREAK after executing query
2. Start BO in a terminal
3. Get to BREAK
4. Execute:
Only after authenticated.
You'll need to:
There's no reason to do that, as standard Caché tools, such as Login page provide all required capabilities.
Do you mean web-app settings like in the following screenshot?
Yes.
But why not using basic authentication? Can I consider using it?
It's way better to use CLP because this way Caché tracks authorization and licenses and you don't need to think about it in your app.
Here's some recommendations on securing REST + CSP web apps:
Client web application can have a custom Login Page (or just use default login page, that's okay too).
I'm not adding any method to existing classes or adding new superclass.
Hello, Amir!
That said I do agree that idea with method generators is good, just not applicable in this exact case.
write stream.ContentTypeProvided stream is an object of %CSP.Stream class.
Thank you, Robert!
That's what I'm looking for.
Hello, Amir!
Can ECP be configured in the case where one of the server is on the internal network? So server1 can see and get replies from server2 but server2 can't access server1 by itself?
What do you want to do?
You need to parse CSV. Here's how to do that in Caché:
Provided you have this csv:
car,2000,100.51,27.10.2016, phone,2003,65.8,15.01.2017,
You can import it into class Test.CSV:
1. Generate a persistent class Test.CSV
set rowtype = "name VARCHAR(50),year INTEGER,amount NUMERIC(9,2),date DATE" set filename = "D:\data.csv" do ##class(%SQL.Util.Procedures).CSVTOCLASS(2, .rowtype, filename,,,,"Test.CSV")
2. Import file or files
do ##class(Test.CSV).Import(2,filename)
Usually you can't import your CSV right away - the dates are in a different format, etc. You need to modify Import method and property definitions. For example I often:
if $$$ISOK(tStatus) { set tCounter = tCounter + 1 } else { w $System.Status.GetErrorText(tStatus) return}If you have a tab separated file, you need to change Import method signature from:
pDelimiter As %String = ","
to:
pDelimiter As %String = {$c(9)}You may need to additionally modify Import method to accept streams instead of files.
Additionally in web app settings specify:
Note, that it would disable caching completely.
Kill the old queue and be done with that?
XPAth can solve that, you dont need to parse XML to object in that case.
Not sure if choiceGetCount is a public API to do that.
You want to count a number of occurances of a particular node in some path?
Simplified example:
set xml = ##class(EnsLib.EDI.XML.Document).%New().ImportFromString("<root><RepeatingElement>Content</RepeatingElement><RepeatingElement>Content</RepeatingElement></root>") #Dim sc As %Status =$$$ERROR($$$SQLError, SQLCODE, $g(%msg))
Please provide code sample.