go to post Robert Cemper · Jan 19, 2024 ChatGPT is just stupid and has no idea of IRIS / CachéA TABLE will by default never have the same name as the GLOBAL that stores the content>>>> HS.IHEX.RecordHistory and the global ^HS.IHEX.RecordHistory <<<<<HS.IHEX.RecordHistory is definitely not a handcrafted table.
go to post Robert Cemper · Jan 19, 2024 Thanks for the recognitions! 😀🖐It's a very strong motivation to be productive.Often to distract from personal struggles.Many thanks to the DX+OEX+GM team for their help! 👏 🌸🌼🌹🌻💐
go to post Robert Cemper · Jan 19, 2024 Hi @Daniel Aguilar for every DB you have a default collation that is tied to DB:you can see it in SMP System > Configuration > Local Databases > Database Properties this is the standard.If the collation of your source server is Spanish, German, Fench, , .... the DB may have used this national collation as default.On your target serve you need to have this collation to be installed.in SMP System > Configuration > Locale Definitions you see what is installed on your Caché instance You may need to add the missing collation table to your Caché instance:
go to post Robert Cemper · Jan 16, 2024 in the previous screenshot you see the namespace as a blue linkand the names of the DB in the yellow highlighted
go to post Robert Cemper · Jan 15, 2024 iristerm does NOT support ssh you need to run ( + install ?) a SSH service in your Linux SUSE 15 VM next, you connect from Win10 over any SSH terminal client (e.g. Putty, ...) to your SuSe VM console command line there you can run iris session ........... (the Linux equivalent of iristerm) Just as described in your question
go to post Robert Cemper · Jan 12, 2024 check if the date object var d=new Date();is inside your routine or at least globally defined
go to post Robert Cemper · Jan 12, 2024 take a look to Mgmt Portal and check NAMESPACE definitionto see DB-file vs. Namespace.In your case, I'd create a new namespace based on your DB-file to avoid conflicts.>>> the same Db for Routine (=code) and Globals
go to post Robert Cemper · Jan 12, 2024 applying WITH STORAGETYPE = COLUMNAR as last line item seems to work (as found in Docs)
go to post Robert Cemper · Jan 11, 2024 Big CONGRATULATIONS to all winners !It's a pleasure to follow your contributions.
go to post Robert Cemper · Jan 8, 2024 %Studio.Project).InstallFromGbl(... rejects explicitly for Versions before 2013.1 in line 1440 ... ("VERSION")),".",1,2)<2013.1 ..... ... Set sc=$$$ERROR($$$DplyVersion, ..... %occErrors.inc(2547): #define DplyVersion 7602 You better contact WRC for help with this 10 year old version
go to post Robert Cemper · Jan 5, 2024 Bonsoir Sylvain!Are you looking for something similar to this; Property MonJour As %String [ InitialExpression = "31/12/1840" ]; Property Jour As %Date [ InitialExpression = 0, SqlComputeCode = {set {*}= $ZDH({MonJour},4) }, SqlComputed, SqlComputeOnChange = MonJour ]; (Multiline just for readability)
go to post Robert Cemper · Jan 5, 2024 Thanks for the test data!It confirms known behavior: Oracle takes a lot of effort to prevent straightforward comparisons But over decades, I haven't ever seen them winning against IRIS / Caché. OK, and PostgreSQL or MySQL never was competitive, Great job !
go to post Robert Cemper · Jan 3, 2024 #1) what type of "routine" do you try to handle ? .cls .mac .int .obj #2) what is the Format you get those "routines" .ro .xml .udl some combinations may allow "command line" examination
go to post Robert Cemper · Jan 3, 2024 In ENSEMBLE default namespace SAMPLES holds a collection, CSP examples.
go to post Robert Cemper · Jan 3, 2024 there is a basic misunderstanding: inside the <CSP:WHILE...> block you are in HTML contextbut you issue instead JavaScript >>>> which just prints it out.To illustrate this see this simple example:But changing to JS_context solved my simple demo with alert(); <csp:WHILE CONDITION="resultSet.Next()"> <!-- xValues.push(#(resultSet.Get("StatsDate"))#) yValues.push(#(resultSet.Get("Value"))#) --> <p>#(resultSet.Get("StatsDate"))#<br>#(resultSet.Get("Value"))#</p> <script LANGUAGE="JavaScript"> alert(#(resultSet.Get("StatsDate"))#+'>>>'+#(resultSet.Get("Value"))#); </script> </csp:WHILE>
go to post Robert Cemper · Jan 2, 2024 Puoi dare un suggerimento in Ideas Portal Penso che ci sia abbastanza supporto lì. Perciò ?? @Luca Ravazzolo ??
go to post Robert Cemper · Dec 29, 2023 Great Stuff!This matches seamlessly to the "real" Customer benchmark I did in 2009 (with Caché)against PostgreSQL and MySQLYears went by but the principles haven't changed. keep memory consumption low data transfer between memory and "disk" (or what mimics a disk) is the the slowest component of your system (except human user) so keep it as flat as possible Glad to see that this is still as valid as it was since ever.After so many years, all new technology tricks didn't change that.
