go to post Dmitry Maslennikov · Nov 20, 2016 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
go to post Dmitry Maslennikov · Nov 19, 2016 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) }
go to post Dmitry Maslennikov · Nov 19, 2016 You can read this article about it here. Something like this. set ^CacheMsg("EnsColumns","en","RemoteArchivePath")="Remote Archive Path"
go to post Dmitry Maslennikov · Nov 18, 2016 I see at least one way to change it, you can use markdown editor.
go to post Dmitry Maslennikov · Nov 18, 2016 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.
go to post Dmitry Maslennikov · Nov 18, 2016 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.
go to post Dmitry Maslennikov · Nov 18, 2016 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.
go to post Dmitry Maslennikov · Nov 16, 2016 System Administration -> Configuration -> System Configuration -> Local Databasesselect database, uncheck mark, and Save
go to post Dmitry Maslennikov · Nov 15, 2016 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
go to post Dmitry Maslennikov · Nov 14, 2016 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.
go to post Dmitry Maslennikov · Nov 10, 2016 Do you have any issues with it, can you explain what are you asking for exactly?
go to post Dmitry Maslennikov · Nov 10, 2016 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.
go to post Dmitry Maslennikov · Nov 10, 2016 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.
go to post Dmitry Maslennikov · Nov 10, 2016 In first you should define ODBC DSN in your operation system, to your Oracle DB. Then you can look at this page in the documentation and class %SQLGatewayConnection
go to post Dmitry Maslennikov · Nov 9, 2016 you can do it with this command set oldPath=##class(%SYSTEM.Process).CurrentDirectory(newPath)
go to post Dmitry Maslennikov · Nov 9, 2016 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?
