Keep up with latest product news

A docs-only patch resolving two setup blockers reported during the Open Exchange review. No code or public-API changes; existing installations do not need to be recompiled or reconfigured beyond the SSL step below.
%Embedding.Config.VectorDataType reference removed from setup examples. The property is not exposed on every IRIS 2026 build, and the previous INSERT INTO %Embedding.Config (…, VectorDataType, …) example failed at runtime on affected builds (Field '%EMBEDDING.CONFIG.VECTORDATATYPE' not found, or <PROPERTY DOES NOT EXIST> in ObjectScript). The example now uses only the portable minimum columns (Name, Configuration, EmbeddingClass, VectorLength, Description); VectorDataType is documented as build-dependent and set via property assignment when your build exposes it.sslConfig now correctly documented as required for every HTTPS provider. Prior examples omitted the key, causing %Embedding.OpenAI.IsValidConfig to reject the config at %Save() time with "Invalid Configuration: 'sslConfig' not set". Every JSON example in the README — Installation, Configuration Reference, and Demo — now includes "sslConfig":"OmniHTTPS" at both the top level (for the embedding provider) and inside the rerank sub-block (for the reranker). The Configuration Reference table upgrades sslConfig from optional to required for every HTTPS provider (Cohere, Voyage, Jina); not used by Ollama.Security.SSLConfigs entry (OmniHTTPS) in %SYS before wiring configs. Only skippable when Ollama is the sole provider.Engine.Rerank remains registered as [SqlProc], but this IRIS build's SQL result-set marshaller does not surface custom %SQL.CustomResultSet columns to callers of CALL dc_omniReRank.Engine_Rerank(...) from the SQL runner. The recommended path is the ObjectScript classmethod call followed by %Display() or %Next() iteration. Fully SQL-native surfacing is tracked as a follow-up.Search invocation instead of the SQL CALL (which returned SQLCODE=0 with zero rows displayed in SMP).v1.0.x: No code migration needed. If you followed a previous README to wire your %Embedding.Config, verify your Configuration JSON contains "sslConfig":"<your-ssl-config-name>" at both levels. If your IRIS build did not require sslConfig before, your row still needs it for the reranker to work — this is enforced by %Embedding.OpenAI and every SaaS reranker path.CALL dc_omniReRank.Engine_Rerank(...) from the SMP SQL runner or another %SQL.Statement returns SQLCODE=0 but does not display rows. Use the ObjectScript classmethod call. Fix scheduled for a subsequent release.LEN on %Vector columns — documented in the demo Catalog.cls (pinned at 1536 dims for OpenAI). Adjust LEN or drop the index if using an embedding model with a different dimensionality.










added DSW as suggested
USER>zpm "list"
dsw 4.0.32
mdx2json 3.2.50
samples-bi 1.0.5
vscode-per-namespace-settings 1.0.0




IsAuthError() method)RawJWT mode when the server returns only a JWT token as plain text. In this case, the API client extracts the expiration date from the token payload. I consciously did not add signature verification, since it requires additional elements (encryption algorithm, public key) and is not needed to extract the date



more detailsAn AI Assistant in the SQL editor with your own API key, an offline viewer for .gof global exports, jumping from a result row straight to its Global node, Azure SQL Database listing every reachable database, a Server Navigator search box with a properties-grid connection panel, and a broad round of fixes against the window freezing during long operations.
Five days after 4.01: 29 changes, headlined by two features that reach into territory SQL DATA LENS did not cover before — an AI Assistant in the SQL editor, and a way to read a .gof global export with no server connection at all.
One thing to know before you update. A newly opened SQL editor no longer collects IRIS/Caché execution statistics by default — the chart button in the editor toolbar, or Tools > Settings > InterSystems IRIS / Caché > SQL editor, turns it back on, per editor or as the default for editors you open afterwards. If you had already switched it on, that choice is kept.
NEW AI Assistant in the SQL editor. Three actions in a new AI menu — Generate SQL from description…, Explain statement, Explain execution plan — bring an AI model into the editor, with IRIS/Caché domain knowledge (maps, Master Map scans, bitmap vs. standard indexes, TuneTable state) added to what the model already knows about SQL. Bring your own API key for Anthropic, OpenAI, Azure OpenAI or a self-hosted OpenAI-compatible endpoint under Tools > Settings > AI Assistant. Off by default everywhere; switch it on per connection under the connection’s new AI tab. No row data and no connection credentials are ever sent, SQL literal values are masked by default, and a preview shows the exact text before anything goes out. Available in the paid editions and in the verified trial, not in the Free Edition. Details on AI Assistant.
NEW Open a .gof export with no server connection. File > Open .gof File… reads an InterSystems block-format global export (%GOF, OutputFormat 7) straight from disk: a header with format version, export time and namespace, a globals table with node and byte counts, and a subscript tree that expands level by level, so an export of several gigabytes with millions of nodes stays navigable. The value panel shows a node as text, as a hex dump, or as decoded $LIST elements. Filter the global list by name, jump to a node with Go to ^Global(1,"x"), and export or copy a selection as ZWRITE text or CSV. Needs a paid edition. See Global Browser.
NEW From a result row straight to its Global node. Right-click a row in a query result against IRIS/Caché and choose Show in Global Browser to open the Global Browser with the real subscript values of that row already filled in — a simple numeric key or a composite one, several rows at once for a pick list. Only offered when the row’s table resolves unambiguously (not for joins or views) and uses ordinary storage.
FIX Long operations stop freezing the window. Testing a connection, loading table details, scanning a folder for Query Cloud, collecting a support bundle, generating a table/view/procedure script, saving a trigger or an ER diagram, and expanding a connection’s Namespaces node now show a progress window after about a second, keep the window responding while they run, and offer a Cancel button that actually hands control back — even when a database driver is still waiting. Alongside it: a connection the server has quietly dropped is now recognised and rebuilt instead of failing on one that only looks alive, in table detail tabs, the ER diagram save and elsewhere.
FIX Azure SQL Database now lists every database your sign-in can reach, not just master. Leave Database Name empty on the Azure tab and Catalogs shows them all; opening one connects in the background, reusing the sign-in you already made — no second Microsoft Entra browser prompt. Fixes the database-switch error SQL Server 40508. Existing connections benefit without any change.
NEW A search box above the Server Navigator tree, and connection details as a real properties grid. Search by connection, group, host or user name (Ctrl+F, Esc, Arrow Down/Enter); matching groups expand and the tree returns to its previous state once you clear the box. The connection details panel is now sortable and copyable, shows host, port, namespace, driver, product version, read-only marking and the encryption in effect, a “Stand hh:mm:ss” timestamp plus a Refresh button, and — for a connection that is not open — its configured settings instead of an empty panel.
NEW Class view signatures, and a filter field that remembers. The IRIS/Caché class view now shows methods, properties and parameters with their full signatures and description text, not just bare names. The Data tab’s Filter field remembers the filters you last used on a table and offers them again as a dropdown, newest first. Alongside it, a security fix: a connection created before 4.01 could still carry a leftover user name, password or encryption setting on its Properties tab — it is now removed automatically the next time SQL DATA LENS loads your connections.
All 29 changes are in the complete 4.02 changelog.
Complete changelog for 4.02







Fix Link to Analyzer Plus
http://localhost:52773/csp/USER/BIExport.UI.Analyzer.cls
Not from SMP !