go to post Dmitry Maslennikov · Nov 19, 2020 Configuring SSH to connect to Caché, on Windows will be almost the same as doing it on Linux. You have to install any SSH server, for instance, OpenSSH. And then configure there default shell, to be something like this c:\intersystems\cache\bin\cache.exe -s c:\intersystems\cache\mgr or for iris, use irisdb.exe, instead c:\intersystems\iris\bin\irisdb.exe -s c:\intersystems\iris\mgr but it looks, that to change default shell in openSSH, you have to edit the registry.
go to post Dmitry Maslennikov · Nov 18, 2020 JWT, is mostly on the server-side in such relations. And in your case, I suppose google should send it. Could you please share the exact Google API you are going to use? It would be easier to understand what are you going to achieve and how to help. There is a way, on how to generate JWT in IRIS or in Caché latest versions, but I'm just not sure, that you are going the right way.
go to post Dmitry Maslennikov · Nov 13, 2020 To load such XML files, you have to use $system.OBJ.Load("/path/to/some.xml", "ck", .errors) - Just one file $system.OBJ.LoadStream(stream, "ck", .errors) - Load from stream $system.OBJ.LoadDir("/path/to/sources", "ck", .errors, 1) - Load any source code files, recursively $system.OBJ.ImportDir("/path/to/sources", "*.xml", "ck", .errors, 1) - Load any source code files by specified filter, recursively
go to post Dmitry Maslennikov · Nov 13, 2020 This may happen if you have not opened just created workspace. You have to open any folder or workspace file.
go to post Dmitry Maslennikov · Nov 9, 2020 I've never faced with accents, so, not sure about this case. But I see many useful use cases for using slugify in SQL. But this feature looks more complex in realization. There are many realizations in many languages, but no standard at all. For the info, slug, slugify, translates string in any language to ASCII, URL compatible string. For instance, it would help to get a cost-effective, language-independent index, but with a quite correct order.
go to post Dmitry Maslennikov · Nov 9, 2020 Sorry, it's just for discussion, to see how people would do some simple task.
go to post Dmitry Maslennikov · Nov 9, 2020 For sure, you have good points, but some points just out of scope at all. Yes, it's limited anyway. My main point is to not have a limited number of parameters like below ClassMethod setValue(key1, key2, key3, key4, value) As %Status And I was just curious if the community knows how to deal with MultiDimensional property, in such a case.
go to post Dmitry Maslennikov · Nov 9, 2020 Yes, this is better, I would even use this s name=$name(%session.Data)
go to post Dmitry Maslennikov · Nov 9, 2020 Nope, still not what I mean, I have a better solution, just would like to see if the community will find it.
go to post Dmitry Maslennikov · Nov 9, 2020 Quite simple, but could be even better, with no useless quotations
go to post Dmitry Maslennikov · Nov 6, 2020 IRIS is a kind of replacement for Caché, which now no active development. So, while you are evaluating it, you should not look for Caché, and switch to IRIS.
go to post Dmitry Maslennikov · Nov 6, 2020 You can download these versions. Community Edition just has a few limitations, but still can be used. And look at the installation guides
go to post Dmitry Maslennikov · Nov 4, 2020 Are you sure that, your insert queries send null and not an empty string? Null and empty strings are different, what are you trying to achieve it's a null, and $c(0) is an empty string. Documentation
go to post Dmitry Maslennikov · Nov 3, 2020 Unfortunately, it does not fully support work with CSP files. If you use local instance, you can just open the folder with CSP files in VSCode, and edit them as any local file. If your server is remote, so, the only way right now is using virtual filesystem isfs.
go to post Dmitry Maslennikov · Nov 2, 2020 In VSCode you just had to open any local folder. And it's a manual choice. When you opened any folder, which is supposed to be as a project root. Configured the server connection, you then should be able to open ObjectScript Server Explorer (by InterSystems logo icon). There you can observe your code on the server, and do export from context menu. Export will be logged to ObjectScript output, with full path's of exported items. Go to File explorer in VSCode (default view), and from context menu on any folder or class, you will have action Import and compile.
go to post Dmitry Maslennikov · Oct 31, 2020 Extracting such amount of data with using JDBC/ODBC, will be much slower than any sort of native access in Cache. InterSystems Cache offers a way to export the whole table, with selected columns Open System Management Portal, System Explorer, SQL. Switch to the desired namespace. Click on Wizards and select Data Export The next steps should be pretty much simple, just select what you need to export and starts in the background. So, you will be able to control how it is going. Look at the documentation for more details
go to post Dmitry Maslennikov · Oct 30, 2020 Extract data could be quite tricky depending on how old is application there. If you sure that the desired data is available through SQL, so you can use any SQL tools, DataGrip, DBeaver, Squirrel-SQL. DBeaver already supports Cache out of the box, and very soon will support IRIS as well.
go to post Dmitry Maslennikov · Oct 30, 2020 What kind of editor do you need? What do you need to do with this editor?
