All
Accepted answers
Evgeny Shvarov · Aug 8, 2017 go to post

With DO you can pass parameters into method or procedure/function and get the result back, with GOTO you can't. 

Evgeny Shvarov · Aug 7, 2017 go to post

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?

Evgeny Shvarov · Aug 7, 2017 go to post

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.

Evgeny Shvarov · Aug 7, 2017 go to post

Hi, Dan! Thanks!

Maybe you have a similar general snippet for %SQL.Statement usage?

Evgeny Shvarov · Aug 4, 2017 go to post

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!

Evgeny Shvarov · Aug 3, 2017 go to post

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.

Evgeny Shvarov · Aug 3, 2017 go to post

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.

Evgeny Shvarov · Jul 29, 2017 go to post

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!

Evgeny Shvarov · Jul 28, 2017 go to post

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é?

Evgeny Shvarov · Jul 25, 2017 go to post

Hi, Sebastien!

If Robert's answer solves your problem, would you please mark it as an accepted? See the details.

Thank you in advance!

Evgeny Shvarov · Jul 20, 2017 go to post

Hi, Mike!

What is a dedicated playlist?

If we have series of video related to one topic we put them in playlists.

Today we have following playlists on DC YouTube channel:

InterSystems: Who We Are - videos which describe our corporate code, who we are, what we do and what matters.

InterSystems iKnow - videos describing InterSystems iKnow technology which helps to build solutions by managing unstructured data.

Atelier - videos, related to InterSystems IDE Atelier.

Global Summit 2016 - videos from last year Global Summit sessions.

Community Projects - videos related to some community projects and solutions presentations. BTW, if you want to describe your solution, tool or a framework in a video we would love to upload it on DC channel in this playlist.

Also, are the video available on a plain hyperlink?

Sure.  E.g. here is the link: Many Data Sources - One Application.

Evgeny Shvarov · Jul 18, 2017 go to post

Hi, Lexi! 

Thanks for sharing that! 

Do you have any performance tests how much %SQL.Statement faster than %Resultset?

Evgeny Shvarov · Jul 18, 2017 go to post

Hi, Benjamin!

Am I able to deploy Aviation demo in a namespace other than Samples? What should I do to make it happen?