go to post Michael Braam · Feb 2, 2018 Hi Jose,I can provide a SEF file for D01B to you. But please note, I haven't used it myself and it is not an official InterSystems product. Use is at your own risk. My customer typically use D96A.I have attached it to this answer.Hope this helpsMichael
go to post Michael Braam · Jul 18, 2017 You need to wrap it into a classmethod which is exposed as a stored procedure as in the example below: Class DC.Utils [ Abstract ]{ClassMethod AESBCEncrypt(pPlainText As %String,pKey As %String) As %String [ SqlProc ]{return $system.Encryption.AESCBCEncrypt(pPlainText, pKey)}} Once you have done this, you can use something like:update sample.person (Name) values (DC.Utils_AESBCEncrypt(name,'key'))
go to post Michael Braam · Feb 7, 2017 Hi Marcel,I have one. I'll send it to you in a separate mail.Haven't tried it. My customer usually use 96A.Regards,Michael
go to post Michael Braam · Feb 3, 2017 There is PERFMON and the Line-By-Line Monitor which you can use to analyze your routines. With PERFMON you can identify the most busy and expensive ROUTINES and you can then analyze a specific routine in detail.Here are the links to the docs:http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=...Hope this helps.-Michael
go to post Michael Braam · Jan 25, 2017 Hi Evgeny,you can add a context parameter to the MDX exression. It an be filters, rows or columns. So if I change my code to:[Measures].[Amount Sold]/%MDX("select [Measures].[Amount Sold] on 1 from holefoods","%CONTEXT","columns") it gives me the follwoing result:Does this help?Michael
go to post Michael Braam · Dec 28, 2016 All you need to do is, to specify the property name/sql field name in the select-list of your query.
go to post Michael Braam · Jul 22, 2016 You have a couple of choices.Either use the built in function $zhex or %SYSTEM.Utils.HexToDecimal or %SYSTEM.Utils.DecimalToHex.See the documentation for detailsHope this helps.
go to post Michael Braam · Jun 14, 2016 Something like this should do it:set x=""set x = $o(@x)while x'="" { write !,x," ",@x set x = $o(@x)}