All
Accepted answers
Dmitry Maslennikov · Nov 20, 2016 go to post 
SAMPLES>do $system.OBJ.ExportPackage("Sample","samples.xml")

Exporting class: Sample.Address
Exporting class: Sample.Company
Exporting class: Sample.CustomResultSet
Exporting class: Sample.Customer
Exporting class: Sample.Employee
Exporting class: Sample.Installer
Exporting class: Sample.ListOfPersonIdentification
Exporting class: Sample.MyException
Exporting class: Sample.Person
Exporting class: Sample.PersonIdentification
Exporting class: Sample.ResultSets
Exporting class: Sample.Task
Exporting class: Sample.TaskExample1
Exporting class: Sample.TaskExample2
Exporting class: Sample.TaskExample3
Exporting class: Sample.USZipCode
Exporting class: Sample.Utils
Exporting class: Sample.Vendor
Dmitry Maslennikov · Nov 19, 2016 go to post

It is not so simple. Before decoding, you should strip any special characters, like line endings. Then you should read input stream in fixed size devisable by 4, and decode this value.

set stream1=##class(%Stream.GlobalBinary).%New()
set stream2=##class(%Stream.GlobalBinary).%New()

while 'base64.AtEnd {
	set temp=base64.Read()
	set temp=$translate(temp, $c(13,10))
	
	do stream1.Write(temp)
}

do stream1.Rewind()
while 'stream1.AtEnd {
	set temp=stream.Read(4000)
	set temp=$system.Encryption.Base64Decode(temp)
	
	do stream2.Write(temp)
}
Dmitry Maslennikov · Nov 19, 2016 go to post

You can read this article about it here. Something like this.

set ^CacheMsg("EnsColumns","en","RemoteArchivePath")="Remote Archive Path"
Dmitry Maslennikov · Nov 18, 2016 go to post

We can use TSQL from Caché side, with changing dialect to MSSQL, and this statement will work. But not sure how it would be possible with JDBC.

Dmitry Maslennikov · Nov 18, 2016 go to post

cconsole.log, it is a server's main log, where logged start/stop and some crash errors. You have an error when communication was terminated from the server side, in this case, I may expect that process which worked on it was crashed unexpected, and it should be logged there.

Dmitry Maslennikov · Nov 18, 2016 go to post

Needs some more details.

You tagged post both ODBC and JDBC, but it is different. For ODBC as I know you can set logging in DSN settings. For JDBC, you can set it with JDBC connection URL. 

Then, how long this query usually takes. I see that you query just 10 rows, but anyway.

Also, you should look, at all levels logging cconsole.log and Application error logs, for any errors, at the same time.

Unfortunately, I don't know about the difference between HSBUS and HSREG, and can't say something useful about it.

Dmitry Maslennikov · Nov 16, 2016 go to post

System Administration -> Configuration -> System Configuration -> Local Databases

select database, uncheck mark, and Save

Dmitry Maslennikov · Nov 15, 2016 go to post

You should look at this page in the documentation.

so, you should do this, in your %SYS namespace

Set ^SYS("Security", "CSP", "AllowClass", 0, "%MW.Web") = 1
Dmitry Maslennikov · Nov 14, 2016 go to post

The title says, removal tool for System Methods. While such methods appeared only in JSON classes, like %DynamicObject which you mentioned. But this tool scans all code in all classes, for using these methods, and change it.

Dmitry Maslennikov · Nov 10, 2016 go to post

Caché does not have any such limitations, please provide more information (update you post), how you use to load files to Caché, and how you check size for saved file after that.

Dmitry Maslennikov · Nov 10, 2016 go to post

Well, you have a version 2012.1, and this version was a last one where we have a limit for memory per process something about 48MB, while by default just only 16Mb. But beginning from 2012.2, by default we have about 260Mb and this value can be increased, but I would not recommend doing so.

Dmitry Maslennikov · Nov 9, 2016 go to post

Really, do you want to retrieve data from another database and show it with CSP ?

Well, it still possible, but needs more details. You can do it by creating some connection via JDBC or ODBC or in any other ways to this particular database, and call queries to get needed data. But it means you should know, how to connect to this database. Can you say, which database you should connect to? And maybe you can describe reasons why you should do so?

Dmitry Maslennikov · Nov 9, 2016 go to post

What do you mean by without creating a link to a particular table? You can create CSP with any of your ways to get table name which it should return.

Dmitry Maslennikov · Nov 9, 2016 go to post

It doesn't matter what you have on server side you connect for. 

And it does not work, just because this server did not get what it is expected. And you should know exactly what it expect, you can update your post and add some examples from fiddler, so we can see what you want to achieve with Caché.

Dmitry Maslennikov · Nov 8, 2016 go to post

This issue is not with with emoji. As you can see in html source for your post, you will see an IMG tag. And post just was splitted in wrong place, automatically. I fixed it by manually inserting separator. 

Dmitry Maslennikov · Nov 5, 2016 go to post

Ok, it was known that on non-Windows systems, used more then one write daemon. But why 8, and is it configurable somehow ? And as I know mgstat, shows activity of writedaemon, I understand and know how it looks like on Windows, but how it will looks like on Linux ? I think we need more information, about multiple write daemons, how they works.

Dmitry Maslennikov · Nov 4, 2016 go to post

And also, I forgot to mention about method CreateDirectoryChain in %File class. And you should use it, if you want just create a folder.

But back to $zf, can you try this command ?

set cmd="mkdir e:\Sample\new" > output.log 2> output.log"
set res=$zf(-1, cmd)

and what will be in res variable, and in output.log file which you can find in database folder for your namespace.

Dmitry Maslennikov · Nov 4, 2016 go to post

I would recommend to use $zf instead of pipes, in this way you can get errorlevel. But in any way you can redirect error output to some file, to see what's going wrong. I suppose, that your E disk is a network disk, or you don't have e:\Sample path, where will be possible to create folder new

Dmitry Maslennikov · Nov 2, 2016 go to post

In Caché you can't do so, without any external tools. And anyway, most of beautifiers works only in some IDEs, you can just copy output and beautify in VisualStudio Code as example.

Dmitry Maslennikov · Nov 1, 2016 go to post

I think it depends what you want to achieve. This method just logout all users, or particular ones. But you should do something in your application. You should look at logout callback, to know where user is logged out. Or at every request, check if user logged in, if not, redirect to some authentication page. But I think, you should already have the same mehanizm.