go to post Robert Cemper · Feb 2, 2018 Hi Ben,I just installed a few samples as in description . CONGRATULATIONS !- not only that I get what I want and leave the rest aside- I also can split samples by subjects in several DBs and namespaces without being trapped by (hidden) dependencies.I think this makes live for training and teaching significantly easier!And allows central bug fixing independent from core release dates.A great idea! Thanks!
go to post Robert Cemper · Feb 2, 2018 To my understanding the main purpose of introducing %INLIST in our SQL wasto have a more handy option than the classic IN (....)%INLIST takes a Single $LISTBUILD() as parameter with a Variable number of values that you pass at runtime by only 1 "?"while IN (p1,p2,p3,p4) or better IN (?,?,?,?) requires a fixed static number of parameters during execution. so you have to know the maximum number of values ahead when you create your queryand eventually to fill unused parameters by some impossible value to feed the query
go to post Robert Cemper · Feb 1, 2018 I wasn't sure.therfore: .... some kind of code optimizer eventually might run.I remembered a discussion around Java JIT compiler and XEP being faster on globals that pure COS.But I can't remember any result or consequences.
go to post Robert Cemper · Feb 1, 2018 I had the issue short after an update of Eclipse.I fixed it by re-installing the glassfish stuff (whatever that might be) explicitly from Marketplace.
go to post Robert Cemper · Feb 1, 2018 That looks very interesting.Leaving the decision what change to apply to the developer is well acceptable. Syntax Checker is probably more important!And at a first glance it seems well suited to also control progress and impovement!
go to post Robert Cemper · Feb 1, 2018 There is an excellent series of 5 articles from Brendan Bannon The Art of Mapping Globals to Classeshttps://community.intersystems.com/post/art-mapping-globals-classes-1-3It tells you all details how to wrap existing globals into classes
go to post Robert Cemper · Feb 1, 2018 Query 1 Example 1 could be marginally faster by less line terminations and less command dispatch:But as this will be compiled some kind of code optimizer eventually might run.Query2 Example1 is faster by less line terminations and less command dispatch.BUT: Both cases aren't the place to win benchmarks. Rather look for Global access , SQL optimizing, ....
go to post Robert Cemper · Feb 1, 2018 query 1 misses a variant: set $lb(a,b,c,d,e,f)=$lb("345","arun","kumar","hi","yello","orange") query 2,example 2 should be I a=2 SET R="Arun"
go to post Robert Cemper · Feb 1, 2018 Hi Ben,- I like the idea of external samples. That offers definitely more flexibility .- DOCUMATIC is unchanged and works local! That's important. OK - JDBC: it isn't visible in Custom Install. You only see xDBC -> ODBC . Not an issue, rather a surprise. The .jar are where they used to be before.I'm really happy that we finally can get out of old chains imposed by 40yrs (DSM-11 and others) backward compatibility .Robert
go to post Robert Cemper · Jan 31, 2018 - no DOCBOOK- no SAMPLES- no JDBC Driver in installbut there is C:\InterSystems\IRIS\dev\java\lib\JDK18\isc-jdbc-3.0.0.jar .....- and a very small icon for csystray.exe in Win
go to post Robert Cemper · Jan 31, 2018 I wonder if it would be possible to have a more rigid syntax check (now in Atelier / and switchable)to enforce all kind of brackets (eg: condition like in JS). I tried to recommend this while teaching COS myself.With very limited success as some Dinos ignored it.
go to post Robert Cemper · Jan 31, 2018 rewrite of comment:if this is something likeSELECT people.name, holiday.date, people.ID||'^'||holiday.ID as UNIQFROM people JOIN holidayON people.country = holiday.countryThen the bolded expression should not be longer than your 50 Char.IF you use CachéStorageID is always a unique positive Integer (1.... 19digits) and you can always disassemble it by the separator.
go to post Robert Cemper · Jan 31, 2018 NO NEVER!ID in CacheStorage is an "autoincrement" positive Integer (1...2**64-1) ~19 digits decimal.AND is never reused.And you can split this construct in the original pieces if required
go to post Robert Cemper · Jan 31, 2018 totally right!!there is more old code out than you could / would like to imagineAnd Caché is backward compatible for 40 years (since DSM V1)New developers should not write it. But they need to understand it. Or at least recognize it.It's pretty similar to reading the bible in original language with no translation.
go to post Robert Cemper · Jan 31, 2018 if this is something likeSELECT people.name, holiday.date, people.ID||'^'||holiday.ID as UNIQFROM people JOIN holidayON people.country = holiday.countryThen the bolded expression should not be longer than your 50 Char.IF you use CachéStrorage
go to post Robert Cemper · Jan 31, 2018 I just added Quick Bookmarks plugin to my Atelier (better Eclipse)Works excellent and to my opinion far better than Studio.ALT+<num> to set numbered<CTRL>+B toggle / set unnumbered<CTRL>+N next<CTRL>+P previousJust installed from https://marketplace.eclipse.org/content/quick-bookmarks-plugin (ignore warnings)
go to post Robert Cemper · Jan 30, 2018 eventually an add-on from eclipse marketplace can close the gap.https://marketplace.eclipse.org/content/quick-bookmarks-plugin
