go to post Tani Frankel · Sep 6 Please see from here:https://www.intersystems.com/certifications/intersystems-iris-core-solut... Practice Questions This exam includes a set of practice questions to help candidates familiarize themselves with question formats and approaches. View Practice Questions
go to post Tani Frankel · Sep 4 Really enjoyed the webinar @Ron Sweeney Great content, insights and results, and thanks for the mentions
go to post Tani Frankel · Feb 9 Thanks Jeff! This is an important update for our customers - On one hand making them aware they now also have the CD releases as non-container kits, while on the other hand reminding them regarding the limitations of these kind of CD releases.
go to post Tani Frankel · Dec 29, 2021 Working with Yakov on this, we saw that for SCOPE_IDENTITY() to work on the SQL Serve side it needs to be in the same "scope" of the INSERT (for example in the same Stored Procedure), see here for reference. So what Yakov ended up doing was encapsulating the INSERT and SELECT SCOPE_IDENTITY() into a Stored Procedure which returns the newly inserted Row ID, and call the SP via the Adapter, thus inserting the new record and getting back the new ID.
go to post Tani Frankel · Dec 28, 2021 Congratulation to all winners! And especially to our local representative - @Yuval Golan! Yuval last year you were 3rd place, and this year up to 2nd... Bravo! @Kevin An beware next year
go to post Tani Frankel · Dec 20, 2021 Thanks Bob, yes, indeed JDBC/ODBC and using Couchbase's N1QL queries (and JSON results) is another connectivity option. If someone "wrapped" such connectivity into some Adapter that could also be interesting.
go to post Tani Frankel · Dec 11, 2021 I was able to get in, for example: $ docker-ls tags --registry https://containers.intersystems.com intersystems/irishealth ... requesting list . done repository: intersystems/irishealth tags: - 2019.1.1.615.1 - 2020.1.0.217.1 - 2020.1.1.408.0 - 2020.2.0.211.0 - 2020.3.0.221.0 - 2020.4.0.547.0 - 2021.1.0.215.0 - 2021.2.0.617.0
go to post Tani Frankel · Oct 28, 2021 Ok, Carig, so sorry about the superfluous explanation about the SQL Package to Schema name mapping... But now I do understand the problem better - First, as you realized you don't need the asterisk (*), just the name of the schema. And second you need to use the term SCHEMA in your statement before the schema name, or else we expect a table name (hence the error you got - table ... not found). So per the example I quoted originally above from the documentation: GRANT SELECT ON SCHEMA Sample TO Deborah In your example this would be: GRANT SELECT ON SCHEMA MyPkg_Messages TO myRole I just added the word 'SCHEMA' before the schema name. Hope this will get it to work for you.
go to post Tani Frankel · Oct 27, 2021 Hi Craig, I'm not 100% sure this is the problem you are seeing (you might be aware of this already) - but worth a try - When you define an OO package name (and sub-packages) for your classes, these "project" to SQL Schema names a little differently, so instead of "dots" (.) in your full package name you would have underscores (_) in your schema name. For example PackageA.PackageB.Class would be PackageA_PackageB.Class - so the schema name would be PackageA_PackageB (and not PackageA.PackageB). See here for example about this in the Documentation.
