go to post Robert Cemper · Jul 18, 2024 another hack: create an SQL Procedure in SMP once compiled use Test Feature in SMP to execute it Example: CREATE PROCEDURE ANY.NAME() LANGUAGE OBJECTSCRIPT { ;;; fill in whatever you want to do }
go to post Robert Cemper · Jul 16, 2024 I just gave it a try: an 8-bit DB works with code and globals without problem on a UNICODE (16bit) installation I didn't try CSP pages in ns %SYS you have a utility ^GBLOCKCOPY converting a 8bit DB to a new 16bit DB for a DB conversion
go to post Robert Cemper · Jul 16, 2024 According to docs processing 8-bit on a unicode install should be possible Character Width Setting ,,,, while a Unicode instance can process both 8-bit and 16-bit data. It's anyhow a tricky exercise
go to post Robert Cemper · Jul 15, 2024 in OEX you find 13 matches for SWAGGER already and 6 articles in this forum simply search
go to post Robert Cemper · Jul 15, 2024 do LOG^%ETN does an actual snapshot and you my examining the actual content at that point of time in SMP
go to post Robert Cemper · Jul 14, 2024 This docu on Cached Queries may be an explanation of what you identified
go to post Robert Cemper · Jul 14, 2024 how do you identify 2 cached queries generated at the same time? and if so, what is the difference ?
go to post Robert Cemper · Jul 13, 2024 object code is just binary content.not even debugger can decipher it.I've never seen a decompiler (like for java) the last 25 years.
go to post Robert Cemper · Jul 11, 2024 in SMP > System Explorer > SQL you place your query and tab SHOW PLAN tells you the best approach with lowest cost - As any data in IRIS (Caché,...) are stored in Globals B+Tree structure always applies by design.
go to post Robert Cemper · Jul 11, 2024 Hi @Daniel Aguilar This looks pretty much like my case:https://community.intersystems.com/post/docker-start-iris-community20241-preview-fails-repeatedlyif your processor doesn't fit the requirements this applies also to Docker images.
go to post Robert Cemper · Jul 10, 2024 Basically every SQL statement whether internal or external is cached for eventual reuse in futureYou can find Cached Queries from SMP > System Explorer > SQL > Cached Queryclicking on one in the list you get the detailsTab SQL Statements shows much more detailsClick on SQL Statement Text offers a further drill down into details
go to post Robert Cemper · Jul 10, 2024 Typical mistakes with ODBC access over Windows DSN ODBC driver old version 32bit driver on 64bit installation or vice-versa not created & tested as System DSN user / password / namespace mismatch wrong configured TLS/SSL access
go to post Robert Cemper · Jul 9, 2024 How can I run this from my Win 11 + Desktop Docker ?it actually fails, issue is reported https://github.com/grongierisc/iris-flask-template/issues/1
go to post Robert Cemper · Jul 9, 2024 How can I run this from my Win 11 + Desktop Docker ?it actually fails, issue is reported https://github.com/grongierisc/iris-django-template/issues/1
go to post Robert Cemper · Jul 9, 2024 How can I run this from my Windows 11 Docker Desktop ?install fails. https://github.com/grongierisc/iris-fastapi-template/issues/1
go to post Robert Cemper · Jul 6, 2024 http://<server>:<port>/csp/......refers to the private webserver installed and used in past releases
go to post Robert Cemper · Jul 6, 2024 check if your external webserver listening to 8080 is started at all
go to post Robert Cemper · Jul 6, 2024 You probably should ask this in an Oracle forum.This is definitely not the best place to discuss such idea
go to post Robert Cemper · Jul 6, 2024 _SYSTEM is just another user name with role %ALLany other account with the same role can do it as well.Tying some code to a Username ignoring the power of roles is an elementary design error.