go to post Evgeny Shvarov · Aug 8, 2017 With DO you can pass parameters into method or procedure/function and get the result back, with GOTO you can't.
go to post Evgeny Shvarov · Aug 7, 2017 Right. But if your method does something meaningful. E.g. what about the method which checks, if a class exists, like in another neighboring post: ClassMethod ClassExists(ClassName as %String) as %Boolean { return ##class(%Dictionary.CompiledClass).%ExistsId(ClassName) } Why would you need %Status here?
go to post Evgeny Shvarov · Aug 7, 2017 Thanks, Dan! Cool stuff!Never knew about .prepare() and .execute() and my +1 vote for .next() to introduce.One more general question: is it a good practice to embrace everything in a method in try/catch?Consider I have some method which interacts with UI and it has try/catch in it and it catches everything it calls. Let's name it UpperUIMethod. But should I introduce try/catch in every methods I'm calling from this UpperUIMethod? Sometimes I want to avoid it to give more sense to the logic itself.
go to post Evgeny Shvarov · Aug 7, 2017 Hi, Dan! Thanks!Maybe you have a similar general snippet for %SQL.Statement usage?
go to post Evgeny Shvarov · Aug 4, 2017 Hi, community!Unfortunately, there would be no InterSystems Developers Meetup on 8th of August!The meetup postponed and shortly I will post about the new date and time.Hope you'll join the next meetup too!
go to post Evgeny Shvarov · Aug 3, 2017 Hi, Kevin!Actually, we are working to make the search better at the very moment.Today you can use the google search option we added to retrieve the reasonable search result - see the related post.
go to post Evgeny Shvarov · Aug 3, 2017 Thanks, Daniel!So %Resultset vs %SQL.Statement can perform 4-7x faster in some cases? Did I understand properly?It would be fantastic if we have some speed test coming with our Samples database classes which would show any win in performance.
go to post Evgeny Shvarov · Jul 29, 2017 I think in your case of migrating MS SQL cube to DeepSee cube means building the whole BI solution in DeepSee from the scratch. I mean:1. ETL the data from MS SQL into Caché fact tables (Caché classes).2. Build DeepSee cube(or cubes) against the fact tables.3. Introduce pivot tables with MDX-queries against DeepSee cube (cubes).4. Make dashboards to provide the UI for this pivot tables.Profit!
go to post Evgeny Shvarov · Jul 28, 2017 Hi, Razvan!I doubt that it is possible at the moment.Caché has DeepSee embedded technology to build BI solutions.What exactly do you want to do? Move BI Solution from SQLServer to Caché?
go to post Evgeny Shvarov · Jul 25, 2017 Hi, Sebastien!If Robert's answer solves your problem, would you please mark it as an accepted? See the details.Thank you in advance!
go to post Evgeny Shvarov · Jul 21, 2017 There was an issue with the registration form. Now it is fixed, join the meetup!
