Function $zf(-1) just executes a command passed as the second argument, you passed only file name. it is not complete, you should add command del for Windows.
set status = $zf(-1, "del c:\sys\text.txt")
it should return 0 if the command was successful.
If you want just delete a file, you can use %File class, useful for many different operations with files and folders.
set result = ##class(%File).Delete("c:\sys\text.txt")This format does not contain information about timezone, so, you don't have any direct way how to convert it to the local time. You can use DATEADD function, to correct time, but you should use constant correction, or in another field.
SELECT DATEADD(hh, 3, CreationTime) FROM Table
Like, here I just add 3 hours.
If you work on versions 2016.1 and later you can use native JSON.
KILLdes only happens during transaction, so, it will be able to revert changes.
And it happens when you kill some node with existing subnodes. So, it will kill each subnode separately with KILLdes
dmg version of eclipse works well for me, not sure that homebrew package is up to date enough and good enough. But anyway, for Atelier it does not actually matter if it PHP or something else, only platform matter.
I successfully use atelier on Mac. Could you add some errors you faced?
Yes, it also works as expected, because
Write "123",456
Outputs
123456
Without any quotes, but it doesn't mean that there are no difference between "123" and just 123. You can see it if you would try to work with $zhex. Try by yourself
Write $zhex(32)
Write $zhex("32")And it works exactly as it should be. I the first example it as a Boolean, and next as a string. What would you do if you would need literal "true", if it would converted to Boolean all the time?
Such message can be shown when you don't have enough license units. Do you have activated license there?
As you trying to install 2018.1.1, I suppose that you trying to connect it to IRIS, and maybe you just don't have a license for IRIS.
Is this error happens only once, or you can reproduce it?
you said that classes not compiled after that, but what said $system.OBJ.Load, is there were some errors, too?
We are not WRC, it is developer community.
As Tom already mentioned, in Caché class is not just as routine, it is like a bunch of objects defined in %Dictionary package, methods code can be found with %Dictionary.MethodDefinition or %Dictionary.CompiledMethodDefinition, depends on the situation.
But it is possible to get a text of class like you can in Studio
%Compiler.UDL.TextServices with methods GetTextAsStream, GetTextAsFile and etc., and convert back from text to class
In versions since 2016.2 you can use export to file in UDL format with $system.OBJ.ExportUDL()
If you think you know exact column which fails this query, you can try to CAST it to another type which Cache will understand.
USER>zload dc.test.1 USER>do sub1() sub1_1 USER>do sub2() sub2_2 USER>do sub2(10) sub2_10 USER>do procPrivate(10) DO procPrivate(10) ^ <NOLINE>^dc.test.1 USER>do procPublic(10) procPublic_10 USER>do sub1 sub1_1
Pilar, could you please extend your post with a bit details about DNI, looks like it is used only in Spain.
And it would be better, to translate comments to English.
I would recommend to use more suitable class for it. %Stream.FileCharacter when you can set TranslateTable property
Set stream=##class(%Stream.FileCharacter).%New()
Set sc=stream.LinkToFile("c:\myfile.txt")
Set stream.TranslateTable = "UTF8"
While 'stream.AtEnd {
Set line=stream.Read()
; Process the chunk here
}And you don't need any conversions after that
It looks like you are going the wrong way. If it fails if even classes have not changed and have not recompiled.
Could you show exact error, which fails to run your reports?
I think, the issue may be in SQL cache, so, you can try to purge it
Do $SYSTEM.SQL.Purge()
Both of those formats do not have support out of the box. And better to use some external tools for it. And it is possible to implement it at least for docx files.
But, you can mark only one answer as accepted.
Collation 20 is Portuguese2. Looks like windows was localized in Portuguese or regional settings when Ensemble was installed. But later changed locale definition to something else. You should return back because the database was created with this collation, and if you want to use new collation you should create a new one and move all data to the new database.
I think your original locale was ptbw, so, you should choose it and press install, and in confirmation press install again.
Atelier is Eclipse plugin, and I think you can find eclipse plugin for Clear Case as well, so, you will not need SourceControl class anymore.
Looks like you want to get more than just hide CSPCHD. It is still possible. You can achieve with URL rewrite in IIS or Apache.
Let's say if you configure your DNS for lcda.omnidata.com.au or any other as you want, or just *.omnidata.com.au for all subdomains, to the same server. You can configure URL Rewrite's for the particular domain to another path.
Rewrite is different from Redirect, when Redirect will show new URL, when Rewrite works hidden and even can redirect to some internal server not available from outside.
May I ask, why do you need so?
With eclipse settings stored in workspaces, so, if you will install multiple eclipse's open the same workspace, you will get the same server's in Atelier.
But you can work with multiple servers in one workspace. So, I don't really see any reasons to have multiple installations.
You can find online documentation here
If you need to make integration with the local instance you can connect directly to the database, using Caché eXTreme, or just ODBC
I would suggest using JSON in another way.
If you caught some errors, please provide more details, sometimes it is quite difficult to predict whats going on, and it helps to find the solution faster.
If you doing SOAP, it should be XML. If you need JSON response it could not be SOAP, it can be REST.
Why did you use altJSONProvider instead of jsonProvider?
What kind of extension do you want to create?
If you set Always use cookies, CSPCHD will not appear in URL anymore.
I think it is possible to do, with little coding.
In CSP-Application you should choose Use Cookie for Session: Always
Or you can control it programmatically in %session with Property UseSessionCookie
property UseSessionCookie as %Integer [ InitialExpression = 1 ];
Indicates whether sessions should be maintained using cookies or not. There are three possible values:
- 0 - Never use cookies. This will pass the CSPCHD parameter around in all the url links and as hidden fields in the <FORM> elements.
- 1 - Auto detect cookie support. This will start by trying to insert a cookie into the browser, if this fails it will switch to mode 0 and never use cookies for this session. The initial page will send both cookies to the browser and it will include the CSPCHD parameter in all links and forms.
- 2 - Always use cookies. This will only use cookies so if the browser does not accept the cookie then the session state will not be maintained.